NBU恢复oracle

数据库安装后，确保db_recovery_file_dest有路径 SQL> show parameter recovery NAME                                 TYPE ------------------------------------ ---------------------- VALUE ------------------------------ db_recovery_file_dest                string +DATA db_recovery_file_dest_size           big integer 3882M recovery_parallelism                 integer SQL> shutdown immediate Database closed. Database dismounted. ORACLE instance shut down. rman>set dbid=3676330291 rman> startup nomount ORACLE instance started. RMAN> run { ALLOCATE CHANNEL CH00 TYPE 'SBT_TAPE'; SEND 'NB_ORA_CLIENT=ITS032,NB_ORA_SERV=it00t181.uaes.com'; RESTORE CONTROLFILE FROM '/cntrl_571_1_900522626'; RELEASE CHANNEL CH00; } allocated channel: CH00 channel CH00: SID=135 device type=SBT_TAPE channel CH00: Veritas NetBackup for Oracle - Release 7.6 (2014042414) sent command to channel: CH00 Starting restore at 2014-08-21 14:58:21 channel CH00: restoring control file channel CH00: restore complete, elapsed time: 00:00:15 output file name=+DATA/p6r8db/controlfile/current.257.856191335 output file name=+DATA/p6r8db/controlfile/current.258.856191335 Finished restore at 2014-08-21 14:58:36 released channel: CH00 RMAN> sql 'alter database mount'; sql statement: alter database mount RMAN> run { ALLOCATE CHANNEL CH00 TYPE 'SBT_TAPE'; ALLOCATE CHANNEL CH01 TYPE 'SBT_TAPE'; SEND 'NB_ORA_CLIENT=ITS032,NB_ORA_SERV=it00t181.uaes.com'; RESTORE DATABASE; RELEASE CHANNEL CH00; RELEASE CHANNEL CH01; } allocated channel: CH00 channel CH00: SID=135 device type=SBT_TAPE channel CH00: Veritas NetBackup for Oracle - Release 7.6 (2014042414) allocated channel: CH01 channel CH01: SID=136 device type=SBT_TAPE channel CH01: Veritas NetBackup for Oracle - Release 7.6 (2014042414) sent command to channel: CH00 sent command to channel: CH01 Starting restore at 2014-08-21 14:59:57 Starting implicit crosscheck backup at 2014-08-21 14:59:57 ……………… channel CH00: restored backup piece 1 channel CH00: restore complete, elapsed time: 00:00:15 Finished restore at 2014-08-21 15:38:19 released channel: CH00 released channel: CH01 RMAN> run { ALLOCATE CHANNEL CH00 TYPE 'SBT_TAPE'; SEND 'NB_ORA_CLIENT=ITS032,NB_ORA_SERV=it00t181.uaes.com'; recover database; RELEASE CHANNEL CH00; } allocated channel: CH00 channel CH00: SID=137 device type=SBT_TAPE channel CH00: Veritas NetBackup for Oracle - Release 7.6 (2014042414) sent command to channel: CH00 Starting recover at 2014-08-21 15:39:41 starting media recovery channel CH00: starting archived log restore to default destination channel CH00: restoring archived log archived log thread=1 sequence=36981 channel CH00: restoring archived log archived log thread=2 sequence=39359 channel CH00: restoring archived log archived log thread=2 sequence=39360 channel CH00: reading from backup piece arch_dUAESWC_ummpge01q_s2774_p1_t856096826 channel CH00: piece handle=arch_dUAESWC_ummpge01q_s2774_p1_t856096826 tag=TAG20140820T124026 channel CH00: restored backup piece 1 channel CH00: restore complete, elapsed time: 00:00:15 archived log file name=+DATA/uaeswc/archivelog/1_36981_732715985.dbf thread=1 sequence=36981 archived log file name=+DATA/uaeswc/archivelog/2_39359_732715985.dbf thread=2 sequence=39359 archived log file name=+DATA/uaeswc/archivelog/2_39360_732715985.dbf thread=2 sequence=39360 channel CH00: starting archived log restore to default destination channel CH00: restoring archived log archived log thread=1 sequence=36982 channel CH00: reading from backup piece arch_dUAESWC_umnpge038_s2775_p1_t856096872 channel CH00: piece handle=arch_dUAESWC_umnpge038_s2775_p1_t856096872 tag=TAG20140820T124026 channel CH00: restored backup piece 1 channel CH00: restore complete, elapsed time: 00:00:15 archived log file name=+DATA/uaeswc/archivelog/1_36982_732715985.dbf thread=1 sequence=36982 unable to find archived log archived log thread=1 sequence=36983 released channel: CH00 RMAN-00571: =========================================================== RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS =============== RMAN-00571: =========================================================== RMAN-03002: failure of recover command at 08/21/2014 15:40:17 RMAN-06054: media recovery requesting unknown archived log for thread 1 with sequence 36983 and starting SCN of 1438035679 RMAN> exit Recovery Manager complete. [oracle@it00t158 ~]$ sqlplus /nolog SQL*Plus: Release 11.2.0.1.0 Production on Thu Aug 21 15:40:28 2014 Copyright (c) 1982, 2009, Oracle.  All rights reserved. SQL> conn /as sysdba Connected. SQL> select instance_name,status from v$instance; INSTANCE_NAME                    STATUS -------------------------------- ------------------------ uaeswc                           MOUNTED SQL> show parameter recovery NAME                                 TYPE ------------------------------------ ---------------------- VALUE ------------------------------ db_recovery_file_dest                string +DATA db_recovery_file_dest_size           big integer 3882M recovery_parallelism                 integer SQL> recover database until cancel using backup controlfile; ORA-00279: change 1438035679 generated at 08/20/2014 12:40:22 needed for thread 1 ORA-00289: suggestion : +DATA/uaeswc/archivelog/1_36983_732715985.dbf ORA-00280: change 1438035679 for thread 1 is in sequence #36983 Specify log: {<RET>=suggested | filename | AUTO | CANCEL} cancel Media recovery cancelled. SQL> alter database open resetlogs; Database altered. SQL>