NBU restore oracle
After the database is installed, make sure that db_recovery_file_dest has a path
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
one
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 >
