My Oracle Support Banner

How To Restore Rman Backups On A Different Node When The Directory Structures Are Different (Doc ID 419137.1)

Last updated on JANUARY 29, 2022

Applies to:

Oracle Database - Enterprise Edition - Version and later
Information in this document applies to any platform.


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.

Restoring Rman backup on a different node with different backup directory structures and different database directory structures .


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

My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.