NetBackup™ for Oracle 管理者ガイド

リカバリポイントから ASM ストレージにシングルステップでリストアするには

1. リカバリポイントのバックアップをカタログに登録します。

   RMAN> catalog start with '/db_mp/';
   
   searching for all files that match the pattern /db_mp/
   
   List of Files Unknown to the Database
   =====================================
   File Name: /db_mp/data_D-ORAC112_I-3955369132_TS-SYSAUX_FNO-2_8hrgu3qd_s-1297_I-3955369132
   File Name: /db_mp/data_D-ORAC112_I-3955369132_TS-SYSTEM_FNO-1_8irgu3qk_s-1298_I-3955369132
   File Name: /db_mp/data_D-ORAC112_I-3955369132_TS-UNDOTBS1_FNO-3_8jrgu3qr_s-1299_I-3955369132
   File Name: /db_mp/data_D-ORAC112_I-3955369132_TS-USERS_FNO-4_8krgu3qt_s-1300_I-3955369132
   File Name: /db_mp/arch_D-ORAC112_I-3955369132_SCN-5248163_a8rh0s3b
   File Name: /db_mp/spfile_D-ORAC112_I-3955369132_T-20160929_a9rh0s3c
   File Name: /db_mp/cf_D-ORAC112_I-3955369132_T-20160929_aarh0s3d
   
   Do you really want to catalog the above files (enter YES or NO)? YES
   cataloging files...
   cataloging done
   
   List of Cataloged Files
   =======================
   File Name: /db_mp/data_D-ORAC112_I-3955369132_TS-SYSAUX_FNO-2_8hrgu3qd_s-1297_I-3955369132
   File Name: /db_mp/data_D-ORAC112_I-3955369132_TS-SYSTEM_FNO-1_8irgu3qk_s-1298_I-3955369132
   File Name: /db_mp/data_D-ORAC112_I-3955369132_TS-UNDOTBS1_FNO-3_8jrgu3qr_s-1299_I-3955369132
   File Name: /db_mp/data_D-ORAC112_I-3955369132_TS-USERS_FNO-4_8krgu3qt_s-1300_I-3955369132
   File Name: /db_mp/arch_D-ORAC112_I-3955369132_SCN-5248163_a8rh0s3b
   File Name: /db_mp/spfile_D-ORAC112_I-3955369132_T-20160929_a9rh0s3c
   File Name: /db_mp/cf_D-ORAC112_I-3955369132_T-20160929_aarh0s3d
   

2. 特定の時点のリカバリポイントからデータファイルをリストアします。

   以下の RMAN でディスク (DISK) からリストアします。また、この例では RMAN の実行前に環境で設定した NLS_DATE_FORMAT="DD-MM-YYYY-HH24:MI:SS" コマンドを使用します。使用環境の日付形式を使用します。

   RMAN> restore until time '2016-09-29-10:00:00' database;
   
   Starting restore at 2016-10-12:15:51:22
   allocated channel: ORA_DISK_1
   channel ORA_DISK_1: SID=193 device type=DISK
   
   channel ORA_DISK_1: restoring datafile 00001
   input datafile copy RECID=461 STAMP=925055096 
   file name=/demo_2/data_D-ORAC112_I-3955369132_TS-SYSTEM_FNO-1_8irgu3qk_s-1298_I-3955369132
   destination for restore of datafile 00001: /db/orac112/app/oradata/orac112/system01.dbf
   channel ORA_DISK_1: copied datafile copy of datafile 00001
   output file name=/db/orac112/app/oradata/orac112/system01.dbf RECID=0 STAMP=0
   Finished restore at 2016-10-12:15:51:34
   

3. データベースをリカバリします。

   ディスクでアーカイブログをリストアできない場合、ログは NetBackup (sbt_tape) からリストアされます。

   RMAN> run
   {
   allocate channel ch00 type sbt_Tape;
   recover database;
   release channel ch00;
   }
   
   released channel: ORA_DISK_1
   allocated channel: ch00
   channel ch00: SID=193 device type=SBT_TAPE
   channel ch00: Veritas NetBackup for Oracle - Release 8.0 (2016091418)
   
   Starting recover at 2016-10-12:15:54:13
   
   starting media recovery
   
   archived log for thread 1 with sequence 508 is already on disk as file 
   /db/orac112/app/fast_recovery_area/ORAC112/archivelog/2016_09_29/o1_mf_1_508_cytbkv22_.arc
   archived log for thread 1 with sequence 509 is already on disk as file 
   /db/orac112/app/fast_recovery_area/ORAC112/archivelog/2016_09_29/o1_mf_1_509_cytbkv36_.arc
   ....
   archived log file name=
   /db/orac112/app/fast_recovery_area/ORAC112/archivelog/2016_09_29/o1_mf_1_508_cytbkv22_.arc 
   thread=1 sequence=508
   archived log file name=
   /db/orac112/app/fast_recovery_area/ORAC112/archivelog/2016_09_29/o1_mf_1_509_cytbkv36_.arc 
   thread=1 sequence=509
   ....
   media recovery complete, elapsed time: 00:00:55
   Finished recover at 2016-10-12:15:55:09
   
   released channel: ch00
   
   RMAN>