Database Backup and Recovery (MOSC)

MOSC Banner

Restore RAC DB to non-RAC

edited Sep 24, 2012 8:27AM in Database Backup and Recovery (MOSC) 1 commentAnswered
Hi,We have a requirement to restore the RAC DB to non-RAC, non-ASM single instance. The source uses ASM disks for DB files,online redologs & controlfiles.
I have an understanding about restoring the controlfile & datafiles to non-ASM  (regular filesytem) using 'set new name' command. But my question is

1.How would I get the online redologs move to regular filesystem?
2. If the recovery requires  a data to be applied from online redologs, how can i apply the data from the redologs because the redologs doesn't exist (for the reason that the source uses ASM disk groups and the target server doesn't use ASM).

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center