Output log of restore_datafile_new.ksh

Output log of restore_datafile_new.ksh. read this along with restore_datafile_new.ksh script

Recovery Manager: Release 10.2.0.1.0 - Production on Tue Jul 17 16:15:13 2007

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

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

RMAN>
RMAN> 2> 3> 4> 5> 6> 7> 8> 9> 10> 11> 12> 13> 14> 15>
using target database control file instead of recovery catalog
allocated channel: disk_1
channel disk_1: sid=41 devtype=DISK

sql statement: alter database datafile 6 offline

executing command: SET NEWNAME

Starting restore at 17-JUL-07

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

datafile 6 switched to datafile copy
input datafile copy recid=10 stamp=628186526 filename=/u02/oradata/slsd/new_users01.dbf

Starting recover at 17-JUL-07

starting media recovery

archive log thread 1 sequence 3 is already on disk as file /u06/flash_recovery_area/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_area/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_area/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_area/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_area/slsd/archivelog/2007_07_15/o1_mf_1_7_39ogtxon_.arc
archive log thread 1 sequence 8 is already on disk as file /u06/flash_recovery_area/slsd/archivelog/2007_07_16/o1_mf_1_8_39rb0ylf_.arc
channel disk_1: starting archive log restore to default destination
channel disk_1: restoring archive log
archive log thread=1 sequence=2
channel disk_1: reading from backup piece /u06/flash_recovery_area/slsd/backupset/2007_07_13/o1_mf_annnn_TAG20070713T143007_39hk5kjq_.bkp
channel disk_1: restored backup piece 1
piece handle=/u06/flash_recovery_area/slsd/backupset/2007_07_13/o1_mf_annnn_TAG20070713T143007_39hk5kjq_.bkp tag=TAG20070713T143007
channel disk_1: restore complete, elapsed time: 00:00:02
archive log filename=/u06/flash_recovery_area/slsd/archivelog/2007_07_17/o1_mf_1_2_39t8v19h_.arc thread=1 sequence=2
channel default: deleting archive log(s)
archive log filename=/u06/flash_recovery_area/slsd/archivelog/2007_07_17/o1_mf_1_2_39t8v19h_.arc recid=60 stamp=628186529
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
archive log filename=/u06/flash_recovery_area/slsd/archivelog/2007_07_15/o1_mf_1_6_39ogtvj5_.arc thread=1 sequence=6
media recovery complete, elapsed time: 00:00:04
Finished recover at 17-JUL-07

sql statement: alter database datafile 6 online
released channel: disk_1

RMAN>
RMAN>

Recovery Manager complete.