How To Restore Rman Backups On A Different Node When The Directory Structur
755639Jun 1 2011 — edited Jun 2 2011Dear All,
Having doubt in RMAN Restore backup concept On a different node, i am practicing a to restore a RMAN data backup, i am following Oracle Metalink ID : 419137.1
I am totally confused when i crossing the 9th step in that document
that is :
9) Rename the Redologfiles,so that they can be created in new locations when opened the database is opened in resetlogs
SQL> alter database rename file '/*node1/database/prod/redo01.log*' to '/*node2/database/prod/redo01.log*';
My Doubt is : i am restoring this in a new empty database, already it having redo logs and other files under oradata folder, in the above mentioned document says to rename it !!
What i have to rename,, How to rename, as per the above SQL statement node1 is a non existing node, we only having its Backup pieces alone. if i rename it like the above statement , do i need to give the old location where the redo log was before, or i can give any name,, ( Yes i know its a logical representation not a physical one) .
Some one explain how to represent this redo log to my new database.
Thanks & Regards,
HAMEED