以TSPITR方式恢复表空间数据一例 - 数据库编程

ified point in time
List of tablespaces expected to have UNDO segments --有undo段的表空间列表 tablespace SYSTEM tablespace UNDOTBS1
Creating automatic instance, with SID='xvBc' --创建一个自动化实例，随机SID为xvBc
initialization parameters used for automatic instance: --为自动化实例分配的参数 db_name=ORA10G compatible=10.2.0.1.0 db_block_size=8192 db_files=200 db_unique_name=tspitr_ORA10G_xvBc large_pool_size=1M shared_pool_size=110M #No auxiliary parameter file used db_create_file_dest=/u01/aux --之前创建的auxiliary目录 control_files=/u01/aux/cntrl_tspitr_ORA10G_xvBc.f --控制文件的位置

starting up automatic instance ORA10G --启动自动化实例
Oracle instance started
Total System Global Area 201326592 bytes
Fixed Size 1218508 bytes Variable Size 146802740 bytes Database Buffers 50331648 bytes Redo Buffers 2973696 bytes Automatic instance created

contents of Memory Script: --第1个内存脚本内容 { # set the until clause set until logseq 33 thread 1; --指定的需要恢复到的logseq # restore the controlfile restore clone controlfile; # mount the controlfile sql clone 'alter database mount clone database'; # archive current online log for tspitr to a resent until time sql 'alter system archive log current'; # avoid unnecessary autobackups for structural changes during TSPITR sql 'begin dbms_backup_restore.AutoBackupFlag(FALSE); end;'; } executing Memory Script
executing command: SET until clause
Starting restore at 26-DEC-14 allocated channel: ORA_AUX_DISK_1 channel ORA_AUX_DISK_1: sid=36 devtype=DISK
channel ORA_AUX_DISK_1: starting datafile backupset restore channel ORA_AUX_DISK_1: restoring control file channel ORA_AUX_DISK_1: reading from backup piece /u01/orabackup/backupsets/ora10g-c-4175411955-20141226-05.ctl channel ORA_AUX_DISK_1: restored backup piece 1 piece handle=/u01/orabackup/backupsets/ora10g-c-4175411955-20141226-05.ctl tag=TAG20141226T164935 channel ORA_AUX_DISK_1: restore complete, elapsed time: 00:00:02 output filename=/u01/aux/cntrl_tspitr_ORA10G_xvBc.f Finished restore at 26-DEC-14
sql statement: alter database mount clone database
sql statement: alter system archive log current
sql statement: begin dbms_backup_restore.AutoBackupFlag(FALSE); end; released channel: ORA_DISK_1 released channel: ORA_AUX_DISK_1
contents of Memory Script: --第2个内存脚本内容 { # generated tablespace point-in-time recovery script # set the until clause set until logseq 33 thread 1; plsql <<<-- tspitr_2 declare sqlstatement varchar2(512); offline_not_needed exception; pragma exception_init(offline_not_needed, -01539); begin sqlstatement := 'alter tablespace '|| 'TSPITR' ||' offline for recover'; krmicd.writeMsg(6162, sqlstatement); krmicd.execSql(sqlstatement); exception when offline_not_needed then null; end; >>>; # set an omf destination filename for restore set newname for clone datafile 1 to new; # set an omf destination filename for restore set newname for clone datafile 2 to new; # set an omf destination tempfile set newname for clone tempfile 2 to new; # set a destination filename for restore set newname for datafile 6 to "/data/oradata/ora10g/tspitr01.dbf"; # rename all tempfiles switch clone tempfile all; # restore the tablespaces in the recovery set plus the auxilliary tablespaces restore clone datafile 1, 2, 6; switch clone datafile all; #online the datafiles restored or flipped sql clone "alter database datafile 1 online"; #online the datafiles restored or flipped sql clone "alter database datafile 2 online"; #online the datafiles restored or flipped sql clone "alter database datafile 6 online"; # make the controlfile point at the restored datafiles, then recover them recover clone database tablespace "TSPITR", "SYSTEM", "UNDOTBS1" delete archivelog; alter clone database open resetlogs; # PLUG HERE the creation of a temporary tablespace if export fa

以TSPITR方式恢复表空间数据一例(四)