Output log of restore_controlfile_from_tape.ksh

Output log of restore_controlfile_from_tape.ksh

Recovery Manager: Release 10.2.0.1.0 - Production on Fri Jul 13 14:21:58 2007

Copyright (c) 1982, 2005, Oracle. All rights reserved.

RMAN>
RMAN>
connected to target database (not started)

RMAN>
RMAN>
Oracle instance started

Total System Global Area 402653184 bytes

Fixed Size 2021192 bytes
Variable Size 146802872 bytes
Database Buffers 247463936 bytes
Redo Buffers 6365184 bytes

RMAN>
RMAN> 2> 3> 4>
executing command: SET DBID

RMAN>
RMAN> 2> 3> 4>
executing command: SET CONTROLFILE AUTOBACKUP FORMAT
using target database control file instead of recovery catalog

RMAN> 2> 3> 4> 5> 6> 7> 8> 9>
allocated channel: tape_1
channel tape_1: sid=62 devtype=SBT_TAPE
channel tape_1: Tivoli Data Protection for Oracle: version 5.2.0.0

Starting restore at 13-JUL-07

channel tape_1: looking for autobackup on day: 20070713
channel tape_1: autobackup found: c-3183102432-20070713-06
channel tape_1: control file restore from autobackup complete
output filename=/u01/oradata/slsd/control01.ctl
output filename=/u05/oradata/slsd/control02.ctl
output filename=/u07/oradata/slsd/control03.ctl
Finished restore at 13-JUL-07
released channel: tape_1

RMAN> 2> 3> 4>
database mounted

RMAN> 2> 3> 4> 5> 6> 7>
Starting recover at 13-JUL-07
Starting implicit crosscheck backup at 13-JUL-07
allocated channel: ORA_DISK_1
channel ORA_DISK_1: sid=62 devtype=DISK
allocated channel: ORA_DISK_2
channel ORA_DISK_2: sid=60 devtype=DISK
allocated channel: ORA_DISK_3
channel ORA_DISK_3: sid=59 devtype=DISK
allocated channel: ORA_DISK_4
channel ORA_DISK_4: sid=58 devtype=DISK
Crosschecked 8 objects
Finished implicit crosscheck backup at 13-JUL-07

Starting implicit crosscheck copy at 13-JUL-07
using channel ORA_DISK_1
using channel ORA_DISK_2
using channel ORA_DISK_3
using channel ORA_DISK_4
Finished implicit crosscheck copy at 13-JUL-07

searching for all files in the recovery area
cataloging files...
no files cataloged

using channel ORA_DISK_1
using channel ORA_DISK_2
using channel ORA_DISK_3
using channel ORA_DISK_4
allocated channel: ORA_SBT_TAPE_1
channel ORA_SBT_TAPE_1: sid=57 devtype=SBT_TAPE
channel ORA_SBT_TAPE_1: Tivoli Data Protection for Oracle: version 5.2.0.0
allocated channel: ORA_SBT_TAPE_2
channel ORA_SBT_TAPE_2: sid=56 devtype=SBT_TAPE
channel ORA_SBT_TAPE_2: Tivoli Data Protection for Oracle: version 5.2.0.0
allocated channel: ORA_SBT_TAPE_3
channel ORA_SBT_TAPE_3: sid=55 devtype=SBT_TAPE
channel ORA_SBT_TAPE_3: Tivoli Data Protection for Oracle: version 5.2.0.0
allocated channel: ORA_SBT_TAPE_4
channel ORA_SBT_TAPE_4: sid=54 devtype=SBT_TAPE
channel ORA_SBT_TAPE_4: Tivoli Data Protection for Oracle: version 5.2.0.0

starting media recovery

archive log thread 1 sequence 3 is already on disk as file /u02/oradata/slsd/red
o3b.rdo
archive log filename=/u02/oradata/slsd/redo3b.rdo thread=1 sequence=3
media recovery complete, elapsed time: 00:00:01
Finished recover at 13-JUL-07

RMAN>
database opened

RMAN> 2> 3> 4> 5> 6>

Recovery Manager complete.