How To Restore Rman Backups On A Different Node When The Directory Structures Are Different
(Doc ID 419137.1)
Last updated on JANUARY 22, 2020
Applies to:Oracle Database - Enterprise Edition - Version 10.1.0.2 and later
Information in this document applies to any platform.
***Checked for relevance on 20-July-2015***
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 .
++ The database has to be has to be restored from the Rman backup on NODE 2.
++ The directory structures for the backups and the database files are different on NODE 2.
++ The Rman backups have to put in new directory structure on NODE 2 unlike as they were on NODE 1.
++ Also the database has to be restored to a different directory structure on NODE 2.
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
|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|