Shulou(Shulou.com)06/01 Report--

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 >

Welcome to subscribe "Shulou Technology Information " to get latest news, interesting things and hot topics in the IT industry, and controls the hottest and latest Internet news, technology news and IT industry trends.