Output log of restore_datafile.ksh

This is the output log of restore_datafile.ksh. Read this along with restore_datafile.ksh

Recovery Manager: Release 10.2.0.1.0 - Production on Mon Jul 16 15:58:15 2007

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

RMAN>
RMAN>
connected to target database: slsd (DBID=3183102432)

RMAN>
RMAN> 2> 3> 4>
using target database control file instead of recovery catalog
sql statement: alter database datafile 6 offline

RMAN>
Starting restore at 16-JUL-07
allocated channel: ORA_DISK_1
channel ORA_DISK_1: sid=39 devtype=DISK
allocated channel: ORA_DISK_2
channel ORA_DISK_2: sid=58 devtype=DISK
allocated channel: ORA_DISK_3
channel ORA_DISK_3: sid=40 devtype=DISK
allocated channel: ORA_DISK_4
channel ORA_DISK_4: sid=41 devtype=DISK
allocated channel: ORA_SBT_TAPE_1
channel ORA_SBT_TAPE_1: sid=55 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=42 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=63 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=56 devtype=SBT_TAPE
channel ORA_SBT_TAPE_4: Tivoli Data Protection for Oracle: version 5.2.0.0

channel ORA_DISK_1: starting datafile backupset restore
channel ORA_DISK_1: specifying datafile(s) to restore from backup set
restoring datafile 00006 to /u02/oradata/slsd/users01.dbf
channel ORA_DISK_1: reading from backup piece /u06/flash_recovery_area/slsd/back
upset/2007_07_13/o1_mf_nnndf_TAG20070713T142343_39hjzqbh_.bkp
channel ORA_DISK_1: restored backup piece 1
piece handle=/u06/flash_recovery_area/slsd/backupset/2007_07_13/o1_mf_nnndf_TAG2
0070713T142343_39hjzqbh_.bkp tag=TAG20070713T142343
channel ORA_DISK_1: restore complete, elapsed time: 00:00:08
Finished restore at 16-JUL-07

RMAN>
Starting recover at 16-JUL-07
using channel ORA_DISK_1
using channel ORA_DISK_2
using channel ORA_DISK_3
using channel ORA_DISK_4
using channel ORA_SBT_TAPE_1
using channel ORA_SBT_TAPE_2
using channel ORA_SBT_TAPE_3
using channel ORA_SBT_TAPE_4

starting media recovery

archive log thread 1 sequence 3 is already on disk as file /u06/flash_recovery_a
rea/slsd/archivelog/2007_07_14/o1_mf_1_3_39kwb3tf_.arc
archive log thread 1 sequence 4 is already on disk as file /u06/flash_recovery_a
rea/slsd/archivelog/2007_07_15/o1_mf_1_4_39ogg8pf_.arc
archive log thread 1 sequence 5 is already on disk as file /u06/flash_recovery_a
rea/slsd/archivelog/2007_07_15/o1_mf_1_5_39ogtt12_.arc
archive log thread 1 sequence 6 is already on disk as file /u06/flash_recovery_a
rea/slsd/archivelog/2007_07_15/o1_mf_1_6_39ogtvj5_.arc
archive log thread 1 sequence 7 is already on disk as file /u06/flash_recovery_a
rea/slsd/archivelog/2007_07_15/o1_mf_1_7_39ogtxon_.arc
channel ORA_DISK_1: starting archive log restore to default destination
channel ORA_DISK_1: restoring archive log
archive log thread=1 sequence=2
channel ORA_DISK_1: reading from backup piece /u06/flash_recovery_area/slsd/back
upset/2007_07_13/o1_mf_annnn_TAG20070713T143007_39hk5kjq_.bkp
channel ORA_DISK_1: restored backup piece 1
piece handle=/u06/flash_recovery_area/slsd/backupset/2007_07_13/o1_mf_annnn_TAG2
0070713T143007_39hk5kjq_.bkp tag=TAG20070713T143007
channel ORA_DISK_1: restore complete, elapsed time: 00:00:02
archive log filename=/u06/flash_recovery_area/slsd/archivelog/2007_07_16/o1_mf_1
_2_39qmhxq7_.arc thread=1 sequence=2
channel default: deleting archive log(s)
archive log filename=/u06/flash_recovery_area/slsd/archivelog/2007_07_16/o1_mf_1
_2_39qmhxq7_.arc recid=57 stamp=628099133
archive log filename=/u06/flash_recovery_area/slsd/archivelog/2007_07_14/o1_mf_1
_3_39kwb3tf_.arc thread=1 sequence=3
archive log filename=/u06/flash_recovery_area/slsd/archivelog/2007_07_15/o1_mf_1
_4_39ogg8pf_.arc thread=1 sequence=4
archive log filename=/u06/flash_recovery_area/slsd/archivelog/2007_07_15/o1_mf_1
_5_39ogtt12_.arc thread=1 sequence=5
media recovery complete, elapsed time: 00:00:06
Finished recover at 16-JUL-07

RMAN>
sql statement: alter database datafile 6 online

RMAN>
RMAN>
RMAN>

Recovery Manager complete.