一、把43p-db的tdpo_node文件的TDPO_NODE改为 h50b的node name # vi /usr/tivoli/tsm/client/oracle/bin/tdpo.opt
TDPO_NODE tdp_h50b
# cd /usr/tivoli/tsm/client/oracle/bin/
# tdpoconf password
************************************************************
* Tivoli Data Protection for Oracle Utility *
* Password file initialization/update program *
* ROOT privilege needed to update value *
*************************************************************
Please enter current password:
Please enter new password:
Please reenter new password for verification:
ANU0260I Password successfully changed.
二、Copy h50B的configora8_sb.ora initora8_sb.ora和口令文件到43p-db相应目录。所有相应的目录都要预先创建好 三、43p-db的oracle为Startup nomount状态 在H50b:
恢复控制文件
$ export ORACLE_SID=ora8_sb
$ rman target system/passwd1@43p-db rcvcat rman/rman@forjy
Recovery Manager: Release 8.0.5.2.1 - Production
RMAN-06006: connected to target database: ora8_sb (not mounted)
RMAN-06008: connected to recovery catalog database
RMAN> run {
allocate channel t1 type 'sbt_tape' parms
'ENV=(TDPO_OPTFILE=/usr/tivoli/tsm/client/oracle/bin/tdpo.opt)';
restore controlfile to '/sbfs/ctl01sb.ctl';
release channel t1;
allocate channel d1 type disk;
replicate controlfile from '/sbfs/ctl01sb.ctl';
sql 'alter database mount';
release channel d1;
}
RMAN-03022: compiling command: allocate
RMAN-03023: executing command: allocate
RMAN-08030: allocated channel: t1
RMAN-08500: channel t1: sid=12 devtype=SBT_TAPE
RMAN-03022: compiling command: restore
RMAN-03022: compiling command: IRESTORE
RMAN-03023: executing command: IRESTORE
RMAN-08016: channel t1: starting datafile backupset restore
RMAN-08502: set_count=0 set_stamp=0
RMAN-08021: channel t1: restoring controlfile
RMAN-08505: output filename=/sbfs/ctl01sb.ctl
RMAN-08023: channel t1: restored backup piece 1
RMAN-08511: piece handle=ORA8_SB_full_497711454_17_1 params=NULL
RMAN-08024: channel t1: restore complete
RMAN-03022: compiling command: release
RMAN-03023: executing command: release
RMAN-08031: released channel: t1
RMAN-03022: compiling command: allocate
RMAN-03023: executing command: allocate
RMAN-08030: allocated channel: d1
RMAN-08500: channel d1: sid=12 devtype=DISK
RMAN-03022: compiling command: replicate
RMAN-03023: executing command: replicate
RMAN-08058: replicating controlfile
RMAN-08506: input filename=/sbfs/ctl01sb.ctl
RMAN-08505: output filename=/sbfs/sbdata1/ctl02sb.ctl
RMAN-08505: output filename=/sbfs/sbdata2/ctl03sb.ctl
RMAN-03022: compiling command: sql
RMAN-06162: sql statement: alter database mount
RMAN-03023: executing command: sql
RMAN-03022: compiling command: release
RMAN-03023: executing command: release
RMAN-08031: released channel: d1
RMAN>exit
Recovery Manager complete.
责任编辑：虫虫
您现在的位置： 