How To Restore Rman Backups On A Node With Different Directory Structures

ID 419137.1

In this Document
  Goal
  Solution
  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.

Applies to:

Oracle Server - Enterprise Edition - Version: 10.1.0.2 to 11.1.0.8 - Release: 10.1 to 11.1
Information in this document applies to any platform.

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

ASSUMPTIONS 
-----------------------

++ The backups on NODE 1 are done to '/node1/database/backup' 
++ The database files on NODE 1 are in '/node1/database/prod' 
++ The backups on NODE 2 will be in location '/node2/database/backup' 
++ The database files on NODE 2 will be restored to '/node2/database/prod

Steps to acheive the goal:

1) Connect to the target database using rman and backup the database ---&gt ON NODE 1

$ rman target / 

Recovery Manager: Release 10.2.0.1.0 - Production on Tue Feb 13 00:29:33 2007 
Copyright (c) 1982, 2005, Oracle. All rights reserved. 
connected to target database: ORA10G (DBID=3932056136) 


RMAN> backup database plus archivelog; 


Starting backup at 13-FEB-07 
current log archived 
using channel ORA_DISK_1 
channel ORA_DISK_1: starting archive log backupset 
channel ORA_DISK_1: specifying archive log(s) in backup set 
input archive log thread=1 sequence=143 recid=109 stamp=614392105 
channel ORA_DISK_1: starting piece 1 at 13-FEB-07 
channel ORA_DISK_1: finished piece 1 at 13-FEB-07 
piece handle=/node1/database/backup/o1_mf_annnn_TAG20070213T002825_2x21kbds 
_.bkp tag=TAG20070213T002825 comment=NONE 
channel ORA_DISK_1: backup set complete, elapsed time: 00:00:02 
Finished backup at 13-FEB-07 

Starting backup at 13-FEB-07 
using channel ORA_DISK_1 
channel ORA_DISK_1: starting full datafile backupset 
channel ORA_DISK_1: specifying datafile(s) in backupset 
input datafile fno=00003 name=/node1/database/prod/sysaux01.dbf 
input datafile fno=00001 name=/node1/database/prod/system01.dbf 
input datafile fno=00002 name=/node1/database/prod/undotbs01.dbf 
input datafile fno=00004 name=/node1/database/prod/users01.dbf 
input datafile fno=00005 name=/node1/database/prod/1.dbf 
input datafile fno=00006 name=/node1/database/prod/sysaux02.dbf 
input datafile fno=00007 name=/node1/database/prod/undotbs02.dbf 
channel ORA_DISK_1: starting piece 1 at 13-FEB-07 
channel ORA_DISK_1: finished piece 1 at 13-FEB-07 
piece handle=/node1/database/backup/o1_mf_nnndf_TAG20070213T002827_2x21kd12 
_.bkp tag=TAG20070213T002827 comment=NONE 
channel ORA_DISK_1: backup set complete, elapsed time: 00:00:55 
Finished backup at 13-FEB-07 


Starting backup at 13-FEB-07 
current log archived 
using channel ORA_DISK_1 
channel ORA_DISK_1: starting archive log backupset 
channel ORA_DISK_1: specifying archive log(s) in backup set 
input archive log thread=1 sequence=144 recid=110 stamp=614392165 
channel ORA_DISK_1: starting piece 1 at 13-FEB-07 
channel ORA_DISK_1: finished piece 1 at 13-FEB-07 
piece handle=/node1/database/backup/o1_mf_annnn_TAG20070213T002925_2x21m6ty 
_.bkp tag=TAG20070213T002925 comment=NONE 
channel ORA_DISK_1: backup set complete, elapsed time: 00:00:02 
Finished backup at 13-FEB-07 


Starting Control File and SPFILE Autobackup at 13-FEB-07 
piece handle=/u01/oracle/product/ora10g/dbs/c-3932056136-20070213-02 comment=NONE 
Finished Control File and SPFILE Autobackup at 13-FEB-07 


RMAN> exit
  
2) Move the following files to the NODE 2:
+ The database backup pieces to location '/node2/database/backup' 
+ Controlfile backup piece to the location '/node2/database/backup' 
+ The parameter file i.e init.ora file to the default location i.e $ORACLE_HOME/dbs

3) Edit the PFILE on NODE 2 to change the environment specific parameters like .

user_dump_dest =  
background_dump_dest = 
control_files =

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:   

[oracle@test-br test]$ export ORACLE_HOME=/u01/oracle/product/ora10g 
[oracle@test-br test]$ export ORACLE_SID=ora10g 
[oracle@test-br test]$ export PATH=$ORACLE_HOME/bin:$PATH 
[oracle@test-br test]$ rman target / 
Recovery Manager: Release 10.2.0.1.0 - Production on Tue Feb 13 00:36:55 2007 
Copyright (c) 1982, 2005, Oracle.  All rights reserved. 
connected to target database (not started) 
RMAN> startup nomount 
Oracle instance started 
Total System Global Area     205520896 bytes 
Fixed Size                     1218508 bytes 
Variable Size                 75499572 bytes 
Database Buffers             121634816 bytes 
Redo Buffers                   7168000 bytes

5) Restore the controlfile from the backup piece.

RMAN> restore controlfile from  '/node2/database/backup/c-3932056136-20070213-02';  
Starting restore at 13-FEB-07  
using target database control file instead of recovery catalog  
allocated channel: ORA_DISK_1  
channel ORA_DISK_1: sid=155 devtype=DISK  
channel ORA_DISK_1: restoring control file  
channel ORA_DISK_1: restore complete,  
elapsed time: 00:00:02  
output filename=/node2/database/prod/control01.ctl  
Finished restore at 13-FEB-07  

 

6) Mount the database

RMAN > alter database mount      
     

 

7) Now catalog the backup pieces that were shipped from NODE 1
     

RMAN> catalog backuppiece '/node2/database/backup/o1_mf_annnn_TAG20070213T002925_2x21m6ty_.bkp'; 

RMAN> catalog backuppiece '/node2/database/backup/o1_mf_annnn_TAG20070213T002825_2x21kbds_.bkp'; 

RMAN> catalog backuppiece '/node2/database/backup/o1_mf_nnndf_TAG20070213T002827_2x21kd12_.bkp'; 
 

This feature of cataloging backup pieces is available from ORACLE 10g versions. Prior to Oracle 10g we were not able to catalog the backup pieces. For more information on cataloging options refer the metalink note 470463.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.

RMAN > list backup of archivelog all;
Let us assume the last sequence of last archivelog in the backup is 50.
            

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'; 
......
......
......
           

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 should be  50 (+1)

RMAN> run 
 {
 set until sequence 51;
 set newname for datafile 1 to '/node2/database/prod/sys01.dbf';
 set newname for datafile 2 to '/node2/database/prod/undotbs01.dbf';
 set newname for datafile 3 to '/node2/database/prod/sysaux01.dbf';
 set newname for datafile 4 to '/node2/database/prod/users01.dbf';
 set newname for datafile 5 to '/node2/database/prod/1.dbf';
 set newname for datafile 6 to '/node2/database/prod/sysaux02.dbf';
 set newname for datafile 7 to '/node2/database/prod/undotbs02.dbf';
 restore database;
 switch datafile all;
 recover database;
 alter database open resetlogs;
 }


If we are restoring the Rman backups  from tapes,then we should ensure the same media manager variables that were used during backups are maintained during restore too. 

The below article gives the information of various media manager Environment Variables. 

NOTE.312737.1 RMAN and Specific Media Managers Environment Variables.

References

NOTE:228257.1 - RMAN 'Duplicate Database' Feature in Oracle9i / 10G and 11G
NOTE:73974.1 - RMAN: Restoring an RMAN Backup to Another Node

来自 “ ITPUB博客 ” ,链接:http://blog.itpub.net/38267/viewspace-742112/,如需转载,请注明出处,否则将追究法律责任。

转载于:http://blog.itpub.net/38267/viewspace-742112/

  • 0
    点赞
  • 0
    收藏
    觉得还不错? 一键收藏
  • 0
    评论
评论
添加红包

请填写红包祝福语或标题

红包个数最小为10个

红包金额最低5元

当前余额3.43前往充值 >
需支付:10.00
成就一亿技术人!
领取后你会自动成为博主和红包主的粉丝 规则
hope_wisdom
发出的红包
实付
使用余额支付
点击重新获取
扫码支付
钱包余额 0

抵扣说明:

1.余额是钱包充值的虚拟货币,按照1:1的比例进行支付金额的抵扣。
2.余额无法直接购买下载,可以购买VIP、付费专栏及课程。

余额充值