How To Restore Rman Backups On A Different Node When The Directory Structures Are Different
(Doc ID 419137.1)
Last updated on DECEMBER 09, 2024
Applies to:
Oracle Database - Enterprise Edition - Version 10.1.0.2 and laterInformation in this document applies to any platform.
Goal
NOTE: In the images and/or the document content below, the user information and environment data used represents fictitious data from the
Oracle sample schema(s), Public Documentation delivered with an Oracle database product or other training material. Any similarity to actual
environments, actual persons, living or dead, is purely coincidental and not intended in any manner.
Oracle sample schema(s), Public Documentation delivered with an Oracle database product or other training material. Any similarity to actual
environments, actual persons, living or dead, is purely coincidental and not intended in any manner.
Restoring Rman backup on a different node with different backup directory structures and different database directory structures .
Solution
To view full details, sign in with your My Oracle Support account. |
|
Don't have a My Oracle Support account? Click to get started! |
In this Document
| Goal |
| Solution |
| Steps to acheive the goal: 1) Connect to the target database using rman and backup the database ---> ON NODE 1 |
| 3) Edit the PFILE on NODE 2 to change the environment specific parameters like . |
| 4) Once the PFILE is suitably modified invoke Rman on the NODE 2 after setting the Oracle environment variables and start the database in nomount mode: |
| 5) Restore the controlfile from the backup piece. |
| 7) Now catalog the backup pieces that were shipped from NODE 1 |
| 8) Get to know the last sequence available in the archivelog backup using the following command.This will help us in recovering the database till that archivelog. |
| 9) Rename the Redolog files,so that they can be created in new locations when opened the database is opened in resetlogs |
| 10) Now restore the datafiles to new locations and recover. Since we are recovering the database here till the archivelog sequence 50 the sequence number in the SET UNTIL SEQUENCE clause |
| 11) Confirm your tempfiles |
| References |