(ZT) restore controlfile from backuppiece with TSM
SQL> declare
2 devtype varchar2(256);
3 done boolean;
4 begin
5 devtype:=dbms_backup_restore.deviceallocate('sbt_tape',params=>'ENV=(TDPO_OPTFILE=/opt/tivoli/tsm/client/oracle/bin64/tdpodbac.opt)');
6 dbms_backup_restore.restoresetdatafile;
7 dbms_backup_restore.restorecontrolfileto('/tmp/abc.cf');
8 dbms_backup_restore.restorebackuppiece('df_652960629_409_1',done=>done);
9 end;
10 /
PL/SQL procedure successfully completed.
$ cp abc.cf /xxx/xxxx/xxxx/data/xxxprd1_control01.ctl
$ cp xxxprd1_control01.ctl xxxxprd1_control02.ctl
$ rman target / catalog rman/rman@rman
Recovery Manager: Release 10.2.0.3.0 - Production on Mon May 5 07:12:18 2008
Copyright (c) 1982, 2005, Oracle. All rights reserved.
connected to target database: accaprd1 (not mounted)
connected to recovery catalog database
RMAN> alter database mount;
database mounted
2 devtype varchar2(256);
3 done boolean;
4 begin
5 devtype:=dbms_backup_restore.deviceallocate('sbt_tape',params=>'ENV=(TDPO_OPTFILE=/opt/tivoli/tsm/client/oracle/bin64/tdpodbac.opt)');
6 dbms_backup_restore.restoresetdatafile;
7 dbms_backup_restore.restorecontrolfileto('/tmp/abc.cf');
8 dbms_backup_restore.restorebackuppiece('df_652960629_409_1',done=>done);
9 end;
10 /
PL/SQL procedure successfully completed.
$ cp abc.cf /xxx/xxxx/xxxx/data/xxxprd1_control01.ctl
$ cp xxxprd1_control01.ctl xxxxprd1_control02.ctl
$ rman target / catalog rman/rman@rman
Recovery Manager: Release 10.2.0.3.0 - Production on Mon May 5 07:12:18 2008
Copyright (c) 1982, 2005, Oracle. All rights reserved.
connected to target database: accaprd1 (not mounted)
connected to recovery catalog database
RMAN> alter database mount;
database mounted
来自 “ ITPUB博客 ” ，链接：https://blog.itpub.net/386081/viewspace-590921/ ，如需转载，请注明出处，否则将追究法律责任。
请登录后发表评论
登录
全部评论
