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 DECEMBER 06, 2017

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***

Goal

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

++ Rman backup of database is done on NODE 1.
++ 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.

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

This document is being delivered to you via Oracle Support's Rapid Visibility (RaV) process and therefore has not been subject to an independent technical review.
My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.