nbu还原oracle,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: {=suggested | filename | AUTO | CANCEL}

cancel

Media recovery cancelled.

SQL> alter database open resetlogs;

Database altered.

SQL>