Output log of rman_dr.ksh

This is the output log of rman_dr.ksh. Please see rman_dr.ksh also to make sense of this log

Recovery Manager: Release 10.2.0.1.0 - Production on Thu Jul 12 16:33:59 2007

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

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

RMAN>
RMAN>
startup failed: ORA-01078: failure in processing system parameters
ORA-01565: error in identifying file '/u01/oracle/product/10.2.0/dbs/spfileslsd.
ora'
ORA-27037: unable to obtain file status
IBM AIX RISC System/6000 Error: 2: No such file or directory
Additional information: 3

starting Oracle instance without parameter file for retrival of spfile
Oracle instance started

Total System Global Area 159383552 bytes

Fixed Size 2019328 bytes
Variable Size 67108864 bytes
Database Buffers 83886080 bytes
Redo Buffers 6369280 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=37 devtype=SBT_TAPE
channel tape_1: Tivoli Data Protection for Oracle: version 5.2.0.0

Starting restore at 12-JUL-07

channel tape_1: looking for autobackup on day: 20070712
channel tape_1: autobackup found: c-3183102432-20070712-02
channel tape_1: SPFILE restore from autobackup complete
Finished restore at 12-JUL-07
released channel: tape_1

RMAN> 2> 3> 4>
Oracle instance shut down

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

Total System Global Area 402653184 bytes

Fixed Size 2021192 bytes
Variable Size 130025656 bytes
Database Buffers 264241152 bytes
Redo Buffers 6365184 bytes

RMAN>
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 12-JUL-07

channel tape_1: looking for autobackup on day: 20070712
channel tape_1: autobackup found: c-3183102432-20070712-02
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 12-JUL-07
released channel: tape_1

RMAN>
RMAN> 2> 3> 4>
database mounted

RMAN>
RMAN> 2> 3> 4> 5> 6> 7>
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 12-JUL-07
Starting implicit crosscheck backup at 12-JUL-07
Crosschecked 11 objects
Finished implicit crosscheck backup at 12-JUL-07

Starting implicit crosscheck copy at 12-JUL-07
Finished implicit crosscheck copy at 12-JUL-07

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

channel tape_1: starting datafile backupset restore
channel tape_1: specifying datafile(s) to restore from backup set
restoring datafile 00001 to /u02/oradata/slsd/system01.dbf
channel tape_1: reading from backup piece 08imku8o_1_2
channel tape_1: restored backup piece 1
piece handle=08imku8o_1_2 tag=TAG20070712T104647
channel tape_1: restore complete, elapsed time: 00:01:26
channel tape_1: starting datafile backupset restore
channel tape_1: specifying datafile(s) to restore from backup set
restoring datafile 00004 to /u03/oradata/slsd/sa_data_01.dbf
channel tape_1: reading from backup piece 09imku8o_1_2
channel tape_1: restored backup piece 1
piece handle=09imku8o_1_2 tag=TAG20070712T104647
channel tape_1: restore complete, elapsed time: 00:01:25
channel tape_1: starting datafile backupset restore
channel tape_1: specifying datafile(s) to restore from backup set
restoring datafile 00005 to /u04/oradata/slsd/sa_index_01.dbf
channel tape_1: reading from backup piece 0aimku8o_1_2
channel tape_1: restored backup piece 1
piece handle=0aimku8o_1_2 tag=TAG20070712T104647
channel tape_1: restore complete, elapsed time: 00:01:15
channel tape_1: starting datafile backupset restore
channel tape_1: specifying datafile(s) to restore from backup set
restoring datafile 00006 to /u02/oradata/slsd/users01.dbf
channel tape_1: reading from backup piece 0dimkuem_1_2
channel tape_1: restored backup piece 1
piece handle=0dimkuem_1_2 tag=TAG20070712T104647
channel tape_1: restore complete, elapsed time: 00:00:07
channel tape_1: starting datafile backupset restore
channel tape_1: specifying datafile(s) to restore from backup set
restoring datafile 00003 to /u02/oradata/slsd/sysaux01.dbf
channel tape_1: reading from backup piece 0cimkuej_1_2
channel tape_1: restored backup piece 1
piece handle=0cimkuej_1_2 tag=TAG20070712T104647
channel tape_1: restore complete, elapsed time: 00:00:35
channel tape_1: starting datafile backupset restore
channel tape_1: specifying datafile(s) to restore from backup set
restoring datafile 00002 to /u05/oradata/slsd/undotbs01.dbf
channel tape_1: reading from backup piece 0bimku8o_1_2
channel tape_1: restored backup piece 1
piece handle=0bimku8o_1_2 tag=TAG20070712T104647
channel tape_1: restore complete, elapsed time: 00:00:45
Finished restore at 12-JUL-07

Starting recover at 12-JUL-07

starting media recovery

archive log thread 1 sequence 44 is already on disk as file /u04/oradata/slsd/re
do2a.rdo
archive log thread 1 sequence 45 is already on disk as file /u02/oradata/slsd/re
do3b.rdo
archive log thread 1 sequence 46 is already on disk as file /u02/oradata/slsd/re
do1a.rdo
channel tape_1: starting archive log restore to default destination
channel tape_1: restoring archive log
archive log thread=1 sequence=42
channel tape_1: reading from backup piece 0eimkul0_1_2
channel tape_1: restored backup piece 1
piece handle=0eimkul0_1_2 tag=TAG20070712T105320
channel tape_1: restore complete, elapsed time: 00:00:04
archive log filename=/u06/flash_recovery_area/slsd/archivelog/2007_07_12/o1_mf_1
_42_39f4gskr_.arc thread=1 sequence=42
channel default: deleting archive log(s)
archive log filename=/u06/flash_recovery_area/slsd/archivelog/2007_07_12/o1_mf_1
_42_39f4gskr_.arc recid=12 stamp=627756057
channel tape_1: starting archive log restore to default destination
channel tape_1: restoring archive log
archive log thread=1 sequence=43
channel tape_1: reading from backup piece 0gimldma_1_2
channel tape_1: restored backup piece 1
piece handle=0gimldma_1_2 tag=TAG20070712T151000
channel tape_1: restore complete, elapsed time: 00:00:02
archive log filename=/u06/flash_recovery_area/slsd/archivelog/2007_07_12/o1_mf_1
_43_39f4gzy
r_.arc thread=1 sequence=43
channel default: deleting archive log(s)
archive log filename=/u06/flash_recovery_area/slsd/archivelog/2007_07_12/o1_mf_1
_43_39f4gzyr_.arc recid=13 stamp=627756064
archive log filename=/u04/oradata/slsd/redo2a.rdo thread=1 sequence=44
archive log filename=/u02/oradata/slsd/redo3b.rdo thread=1 sequence=45
archive log filename=/u02/oradata/slsd/redo1a.rdo thread=1 sequence=46
media recovery complete, elapsed time: 00:00:10
Finished recover at 12-JUL-07
released channel: tape_1

RMAN> 2> 3> 4> 5>

Recovery Manager complete.