Outputlog of restore_controlfile.ksh

This shows the screen output that gets produced when restore_controlfile.ksh is run

Recovery Manager: Release 10.2.0.1.0 - Production on Fri Jul 13 13:38:13 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 142608568 bytes
Database Buffers 251658240 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>
allocated channel: disk_1
channel disk_1: sid=62 devtype=DISK

Starting restore at 13-JUL-07

recovery area destination: /u06/flash_recovery_area
database name (or database unique name) used for search: slsd
channel disk_1: no autobackups found in the recovery area
channel disk_1: looking for autobackup on day: 20070713
channel disk_1: autobackup found: controlfile_c-3183102432-20070713-03
channel disk_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: disk_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 7 objects
Crosschecked 13 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 /u04/oradata/slsd/red
o2a.rdo
archive log filename=/u04/oradata/slsd/redo2a.rdo thread=1 sequence=3
media recovery complete, elapsed time: 00:00:00
Finished recover at 13-JUL-07

RMAN>
database opened

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

Recovery Manager complete.