Skip to Main Content

Oracle Database Discussions

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

How To Restore Rman Backups On A Different Node When The Directory Structur

755639Jun 1 2011 — edited Jun 2 2011
Dear 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
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Jun 30 2011
Added on Jun 1 2011
8 comments
197 views