Today's Birthday
Quote of the Day
This Day in History

Sunday, June 3, 2007

Output log of rman_bkup.ksh

This shows the output log of rman_bkup.ksh


---------------------------------------------------------
Tue Jun 26 14:26:50 EDT 2007
---------------- rman_bkup.ksh started ------------------
sls1
oracle
/u01/oracle/product/agent10g/bin/rman

Recovery Manager: Release 10.2.0.1.0 - Production on Tue Jun 26 14:26:50 2007

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

RMAN>
RMAN>
connected to target database: sls1 (DBID=1522268517)

RMAN>
RMAN>
using target database control file instead of recovery catalog
RMAN configuration parameters are:
CONFIGURE RETENTION POLICY TO REDUNDANCY 1;
CONFIGURE BACKUP OPTIMIZATION ON;
CONFIGURE DEFAULT DEVICE TYPE TO DISK;
CONFIGURE CONTROLFILE AUTOBACKUP ON;
CONFIGURE CONTROLFILE AUTOBACKUP FORMAT FOR DEVICE TYPE DISK TO 'controlfile_%F';
CONFIGURE CONTROLFILE AUTOBACKUP FORMAT FOR DEVICE TYPE SBT_TAPE TO '%F'; # default
CONFIGURE DEVICE TYPE DISK PARALLELISM 4 BACKUP TYPE TO BACKUPSET;
CONFIGURE DEVICE TYPE 'SBT_TAPE' PARALLELISM 4 BACKUP TYPE TO BACKUPSET;
CONFIGURE DATAFILE BACKUP COPIES FOR DEVICE TYPE DISK TO 1; # default
CONFIGURE DATAFILE BACKUP COPIES FOR DEVICE TYPE SBT_TAPE TO 1; # default
CONFIGURE ARCHIVELOG BACKUP COPIES FOR DEVICE TYPE DISK TO 1; # default
CONFIGURE ARCHIVELOG BACKUP COPIES FOR DEVICE TYPE SBT_TAPE TO 1; # default
CONFIGURE CHANNEL DEVICE TYPE 'SBT_TAPE' PARMS 'ENV=(TDPO_OPTFILE=/usr/tivoli/tsm/client/oracle/bin64/tdpo.opt)' FORMAT '%u_%p_%c';
CONFIGURE MAXSETSIZE TO UNLIMITED; # default
CONFIGURE ENCRYPTION FOR DATABASE OFF; # default
CONFIGURE ENCRYPTION ALGORITHM 'AES128'; # default
CONFIGURE ARCHIVELOG DELETION POLICY TO NONE; # default
CONFIGURE SNAPSHOT CONTROLFILE NAME TO '/u01/oracle/product/10.2.0/dbs/snapcf_sls1.f'; # default

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

Starting backup at 26-JUN-07
current log archived
allocated channel: ORA_DISK_1
channel ORA_DISK_1: sid=134 devtype=DISK
allocated channel: ORA_DISK_2
channel ORA_DISK_2: sid=133 devtype=DISK
allocated channel: ORA_DISK_3
channel ORA_DISK_3: sid=132 devtype=DISK
allocated channel: ORA_DISK_4
channel ORA_DISK_4: sid=141 devtype=DISK
channel ORA_DISK_1: starting archive log backupset
channel ORA_DISK_1: specifying archive log(s) in backup set
input archive log thread=1 sequence=16 recid=417 stamp=626279214
channel ORA_DISK_1: starting piece 1 at 26-JUN-07
channel ORA_DISK_1: finished piece 1 at 26-JUN-07
piece handle=/u06/flash_recovery_area/sls1/backupset/2007_06_26/o1_mf_annnn_TAG20070626T142658_382pmmo0_.bkp tag=TAG20070626T142658 comment=NONE
channel ORA_DISK_1: backup set complete, elapsed time: 00:00:02
channel ORA_DISK_1: deleting archive log(s)
archive log filename=/u06/flash_recovery_area/sls1/archivelog/2007_06_26/o1_mf_1_16_382pmgt9_.arc recid=417 stamp=626279214
Finished backup at 26-JUN-07

Starting backup at 26-JUN-07
using channel ORA_DISK_1
using channel ORA_DISK_2
using channel ORA_DISK_3
using channel ORA_DISK_4
channel ORA_DISK_1: starting full datafile backupset
channel ORA_DISK_1: specifying datafile(s) in backupset
input datafile fno=00004 name=/u03/oradata/sls1/sls1_data_01.dbf
channel ORA_DISK_1: starting piece 1 at 26-JUN-07
channel ORA_DISK_2: starting full datafile backupset
channel ORA_DISK_2: specifying datafile(s) in backupset
input datafile fno=00005 name=/u03/oradata/sls1/sls1_data_02.dbf
channel ORA_DISK_2: starting piece 1 at 26-JUN-07
channel ORA_DISK_3: starting full datafile backupset
channel ORA_DISK_3: specifying datafile(s) in backupset
input datafile fno=00007 name=/u04/oradata/sls1/sls1_index_01.dbf
channel ORA_DISK_3: starting piece 1 at 26-JUN-07
channel ORA_DISK_4: starting full datafile backupset
channel ORA_DISK_4: specifying datafile(s) in backupset
input datafile fno=00009 name=/u05/oradata/sls1/sls1aud_arch_01.dbf
channel ORA_DISK_4: starting piece 1 at 26-JUN-07
channel ORA_DISK_4: finished piece 1 at 26-JUN-07
piece handle=/u06/flash_recovery_area/sls1/backupset/2007_06_26/o1_mf_nnndf_TAG20070626T142701_382pms0g_.bkp tag=TAG20070626T142701 comment=NONE
channel ORA_DISK_4: backup set complete, elapsed time: 00:05:56
channel ORA_DISK_4: starting full datafile backupset
channel ORA_DISK_4: specifying datafile(s) in backupset
input datafile fno=00012 name=/u05/oradata/sls1/sls1hist_arch_01.dbf
channel ORA_DISK_4: starting piece 1 at 26-JUN-07
channel ORA_DISK_3: finished piece 1 at 26-JUN-07
piece handle=/u06/flash_recovery_area/sls1/backupset/2007_06_26/o1_mf_nnndf_TAG20070626T142701_382pmpqw_.bkp tag=TAG20070626T142701 comment=NONE
channel ORA_DISK_3: backup set complete, elapsed time: 00:06:33
channel ORA_DISK_3: starting full datafile backupset
channel ORA_DISK_3: specifying datafile(s) in backupset
input datafile fno=00001 name=/u02/oradata/sls1/system01.dbf
channel ORA_DISK_3: starting piece 1 at 26-JUN-07
channel ORA_DISK_3: finished piece 1 at 26-JUN-07
piece handle=/u06/flash_recovery_area/sls1/backupset/2007_06_26/o1_mf_nnndf_TAG20070626T142701_382q019s_.bkp tag=TAG20070626T142701 comment=NONE
channel ORA_DISK_3: backup set complete, elapsed time: 00:03:35
channel ORA_DISK_3: starting full datafile backupset
channel ORA_DISK_3: specifying datafile(s) in backupset
input datafile fno=00006 name=/u03/oradata/sls1/sls1_data_03.dbf
channel ORA_DISK_3: starting piece 1 at 26-JUN-07
channel ORA_DISK_1: finished piece 1 at 26-JUN-07
piece handle=/u06/flash_recovery_area/sls1/backupset/2007_06_26/o1_mf_nnndf_TAG20070626T142701_382pmpov_.bkp tag=TAG20070626T142701 comment=NONE
channel ORA_DISK_1: backup set complete, elapsed time: 00:11:46
channel ORA_DISK_1: starting full datafile backupset
channel ORA_DISK_1: specifying datafile(s) in backupset
input datafile fno=00008 name=/u04/oradata/sls1/sls1_index_02.dbf
channel ORA_DISK_1: starting piece 1 at 26-JUN-07
channel ORA_DISK_2: finished piece 1 at 26-JUN-07
piece handle=/u06/flash_recovery_area/sls1/backupset/2007_06_26/o1_mf_nnndf_TAG20070626T142701_382pmppv_.bkp tag=TAG20070626T142701 comment=NONE
channel ORA_DISK_2: backup set complete, elapsed time: 00:12:14
channel ORA_DISK_2: starting full datafile backupset
channel ORA_DISK_2: specifying datafile(s) in backupset
input datafile fno=00010 name=/u05/oradata/sls1/sls1aud_arch_02.dbf
channel ORA_DISK_2: starting piece 1 at 26-JUN-07
channel ORA_DISK_3: finished piece 1 at 26-JUN-07
piece handle=/u06/flash_recovery_area/sls1/backupset/2007_06_26/o1_mf_nnndf_TAG20070626T142701_382q6z41_.bkp tag=TAG20070626T142701 comment=NONE
channel ORA_DISK_3: backup set complete, elapsed time: 00:04:02
channel ORA_DISK_3: starting full datafile backupset
channel ORA_DISK_3: specifying datafile(s) in backupset
input datafile fno=00002 name=/u05/oradata/sls1/undotbs01.dbf
channel ORA_DISK_3: starting piece 1 at 26-JUN-07
channel ORA_DISK_2: finished piece 1 at 26-JUN-07
piece handle=/u06/flash_recovery_area/sls1/backupset/2007_06_26/o1_mf_nnndf_TAG20070626T142701_382qbwdp_.bkp tag=TAG20070626T142701 comment=NONE
channel ORA_DISK_2: backup set complete, elapsed time: 00:02:14
channel ORA_DISK_2: starting full datafile backupset
channel ORA_DISK_2: specifying datafile(s) in backupset
input datafile fno=00003 name=/u02/oradata/sls1/sysaux01.dbf
channel ORA_DISK_2: starting piece 1 at 26-JUN-07
channel ORA_DISK_1: finished piece 1 at 26-JUN-07
piece handle=/u06/flash_recovery_area/sls1/backupset/2007_06_26/o1_mf_nnndf_TAG20070626T142701_382q9wwh_.bkp tag=TAG20070626T142701 comment=NONE
channel ORA_DISK_1: backup set complete, elapsed time: 00:03:38
channel ORA_DISK_1: starting full datafile backupset
channel ORA_DISK_1:
specifying datafile(s) in backupset
input datafile fno=00011 name=/u02/oradata/sls1/users01.dbf
channel ORA_DISK_1: starting piece 1 at 26-JUN-07
channel ORA_DISK_1: finished piece 1 at 26-JUN-07
piece handle=/u06/flash_recovery_area/sls1/backupset/2007_06_26/o1_mf_nnndf_TAG20070626T142701_382qjqpj_.bkp tag=TAG20070626T142701 comment=NONE
channel ORA_DISK_1: backup set complete, elapsed time: 00:00:35
channel ORA_DISK_1: starting full datafile backupset
channel ORA_DISK_1: specifying datafile(s) in backupset
input datafile fno=00013 name=/u05/oradata/sls1/FLOW_1.dbf
channel ORA_DISK_1: starting piece 1 at 26-JUN-07
channel ORA_DISK_2: finished piece 1 at 26-JUN-07
piece handle=/u06/flash_recovery_area/sls1/backupset/2007_06_26/o1_mf_nnndf_TAG20070626T142701_382qh399_.bkp tag=TAG20070626T142701 comment=NONE
channel ORA_DISK_2: backup set complete, elapsed time: 00:01:58
channel ORA_DISK_1: finished piece 1 at 26-JUN-07
piece handle=/u06/flash_recovery_area/sls1/backupset/2007_06_26/o1_mf_nnndf_TAG20070626T142701_382qkxlw_.bkp tag=TAG20070626T142701 comment=NONE
channel ORA_DISK_1: backup set complete, elapsed time: 00:04:01
channel ORA_DISK_4: finished piece 1 at 26-JUN-07
piece handle=/u06/flash_recovery_area/sls1/backupset/2007_06_26/o1_mf_nnndf_TAG20070626T142701_382pyyjy_.bkp tag=TAG20070626T142701 comment=NONE
channel ORA_DISK_4: backup set complete, elapsed time: 00:29:02
channel ORA_DISK_3: finished piece 1 at 26-JUN-07
piece handle=/u06/flash_recovery_area/sls1/backupset/2007_06_26/o1_mf_nnndf_TAG20070626T142701_382qgsmc_.bkp tag=TAG20070626T142701 comment=NONE
channel ORA_DISK_3: backup set complete, elapsed time: 00:22:51
Finished backup at 26-JUN-07

Starting backup at 26-JUN-07
current log archived
using channel ORA_DISK_1
using channel ORA_DISK_2
using channel ORA_DISK_3
using channel ORA_DISK_4
channel ORA_DISK_1: starting archive log backupset
channel ORA_DISK_1: specifying archive log(s) in backup set
input archive log thread=1 sequence=17 recid=418 stamp=626281450
channel ORA_DISK_1: starting piece 1 at 26-JUN-07
channel ORA_DISK_1: finished piece 1 at 26-JUN-07
piece handle=/u06/flash_recovery_area/sls1/backupset/2007_06_26/o1_mf_annnn_TAG20070626T150411_382rsf32_.bkp tag=TAG20070626T150411 comment=NONE
channel ORA_DISK_1: backup set complete, elapsed time: 00:00:02
channel ORA_DISK_1: deleting archive log(s)
archive log filename=/u06/flash_recovery_area/sls1/archivelog/2007_06_26/o1_mf_1_17_382rsb9f_.arc recid=418 stamp=626281450
Finished backup at 26-JUN-07

Starting Control File and SPFILE Autobackup at 26-JUN-07
piece handle=/u01/oracle/product/10.2.0/dbs/controlfile_c-1522268517-20070626-03 comment=NONE
Finished Control File and SPFILE Autobackup at 26-JUN-07

RMAN>
RMAN retention policy will be applied to the command
RMAN retention policy is set to redundancy 1
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=136 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=139 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=140 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=138 devtype=SBT_TAPE
channel ORA_SBT_TAPE_4: Tivoli Data Protection for Oracle: version 5.2.0.0
Deleting the following obsolete backups and copies:
Type Key Completion Time Filename/Handle
-------------------- ------ ------------------ --------------------
Backup Set 164 14-JUN-07
Backup Piece 230 14-JUN-07 54ik8t17_1_2
Backup Set 164 14-JUN-07
Backup Piece 205 14-JUN-07 /u06/flash_recovery_area/sls1/backupset/2007_06_14/o1_mf_nnndf_TAG20070614T143933_3732v7rf_.bkp
Backup Set 165 14-JUN-07
Backup Piece 231 14-JUN-07 55ik8t17_1_2
Backup Set 165 14-JUN-07
Backup Piece 206 14-JUN-07 /u06/flash_recovery_area/sls1/backupset/2007_06_14/o1_mf_nnndf_TAG20070614T143933_3732v7tr_.bkp
Backup Set 162 14-JUN-07
Backup Piece 229 14-JUN-07 56ik8t17_1_2
Backup Set 162 14-JUN-07
Backup Piece 203 14-JUN-07 /u06/flash_recovery_area/sls1/backupset/2007_06_14/o1_mf_nnndf_TAG20070614T143933_3732v7vs_.bkp
Backup Set 161 14-JUN-07
Backup Piece 202 14-JUN-07 /u06/flash_recovery_area/sls1/backupset/2007_06_14/o1_mf_nnndf_TAG20070614T143933_3732v9vs_.bkp
Backup Set 161 14-JUN-07
Backup Piece 217 14-JUN-07 57ik8t17_1_2
Backup Set 172 14-JUN-07
Backup Piece 225 14-JUN-07 58ik8tcl_1_2
Backup Set 172 14-JUN-07
Backup Piece 213 14-JUN-07 /u06/flash_recovery_area/sls1/backupset/2007_06_14/o1_mf_nnndf_TAG20070614T143933_37336ohr_.bkp
Backup Set 163 14-JUN-07
Backup Piece 218 14-JUN-07 59ik8tdo_1_2
Backup Set 163 14-JUN-07&nb
sp;
Backup Piece 204 14-JUN-07 /u06/flash_recovery_area/sls1/backupset/2007_06_14/o1_mf_nnndf_TAG20070614T143933_37337snk_.bkp
Backup Set 166 14-JUN-07
Backup Piece 219 14-JUN-07 5aik8tjs_1_2
Backup Set 166 14-JUN-07
Backup Piece 207 14-JUN-07 /u06/flash_recovery_area/sls1/backupset/2007_06_14/o1_mf_nnndf_TAG20070614T143933_3733g0j5_.bkp
Backup Set 168 14-JUN-07
Backup Piece 209 14-JUN-07 /u06/flash_recovery_area/sls1/backupset/2007_06_14/o1_mf_nnndf_TAG20070614T143933_3733kmdh_.bkp
Backup Set 168 14-JUN-07
Backup Piece 221 14-JUN-07 5bik8tng_1_2
Backup Set 167 14-JUN-07
Backup Piece 220 14-JUN-07 5cik8tol_1_2
Backup Set 167 14-JUN-07
Backup Piece 208 14-JUN-07 /u06/flash_recovery_area/sls1/backupset/2007_06_14/o1_mf_nnndf_TAG20070614T143933_3733lswb_.bkp
Backup Set 173 14-JUN-07
Backup Piece 214 14-JUN-07 /u06/flash_recovery_area/sls1/backupset/2007_06_14/o1_mf_nnndf_TAG20070614T143933_3733p33c_.bkp
Backup Set 173 14-JUN-07
Backup Piece 226 14-JUN-07 5dik8trv_1_2
Backup Set 170 14-JUN-07
Backup Piece 223 14-JUN-07 5eik8tsq_1_2
Backup Set 170 14-JUN-07
Backup Piece 211 14-JUN-07 /u06/flash_recovery_area/sls1/backupset/2007_06_14/o1_mf_nnndf_TAG20070614T143933_3733pwvf_.bkp
Backup Set 169 14-JUN-07
Backup Piece 210 14-JUN-07 /u06/flash_recovery_area/sls1/backupset/2007_06_14/o1_mf_nnndf_TAG20070614T143933_3733rlpk_.bkp
Backup Set 169 14-JUN-07
Backup Piece 222 14-JUN-07 5fik8tui_1_2
Backup Set 171 14-JUN-07
Backup Piece 224 14-JUN-07 5gik8tvm_1_2
Backup Set 171 14-JUN-07
Backup Piece 212 14-JUN-07 /u06/flash_recovery_area/sls1/backupset/2007_06_14/o1_mf_nnndf_TAG20070614T143933_3733srm3_.bkp
Backup Set 174 14-JUN-07
Backup Piece 227 14-JUN-07 5hik8v8l_1_2
Backup Set 174 14-JUN-07
Backup Piece 215 14-JUN-07 /u06/flash_recovery_area/sls1/backupset/2007_06_14/o1_mf_annnn_TAG20070614T151741_37352pv5_.bkp
Backup Set 177 15-JUN-07
Backup Piece 236 15-JUN-07 5kikb9l5_1_2
Backup Set 177 15-JUN-07
Backup Piece 233 15-JUN-07 /u06/flash_recovery_area/sls1/backupset/2007_06_15/o1_mf_annnn_TAG20070615T122717_375hh73n_.bkp
Backup Set 182 26-JUN-07
Backup Piece 240 26-JUN-07 /u06/flash_recovery_area/sls1/backupset/2007_06_26/o1_mf_annnn_TAG20070626T140558_382odbd8_.bkp
Backup Set 183 26-JUN-07
Backup Piece 241 26-JUN-07 /u06/flash_recovery_area/sls1/backupset/2007_06_26/o1_mf_annnn_TAG20070626T140558_382odbgc_.bkp
Backup Set 184 26-JUN-07
Backup Piece 242 26-JUN-07 /u06/flash_recovery_area/sls1/backupset/2007_06_26/o1_mf_annnn_TAG20070626T140558_382odbhd_.bkp
Backup Set 180 26-JUN-07
Backup Piece 238 26-JUN-0
7 /u06/flash_recovery_area/sls1/backupset/2007_06_26/o1_mf_annnn_TAG20070626T140558_382odbf8_.bkp
Backup Set 181 26-JUN-07
Backup Piece 239 26-JUN-07 /u06/flash_recovery_area/sls1/backupset/2007_06_26/o1_mf_annnn_TAG20070626T140558_382ofrxg_.bkp
Backup Set 186 26-JUN-07
Backup Piece 244 26-JUN-07 /u06/flash_recovery_area/sls1/backupset/2007_06_26/o1_mf_annnn_TAG20070626T142413_382pggv5_.bkp
Backup Set 188 26-JUN-07
Backup Piece 246 26-JUN-07 /u06/flash_recovery_area/sls1/backupset/2007_06_26/o1_mf_annnn_TAG20070626T142533_382pjytc_.bkp
Backup Set 189 26-JUN-07
Backup Piece 247 26-JUN-07 /u01/oracle/product/10.2.0/dbs/controlfile_c-1522268517-20070626-02
Backup Set 190 26-JUN-07
Backup Piece 248 26-JUN-07 /u06/flash_recovery_area/sls1/backupset/2007_06_26/o1_mf_annnn_TAG20070626T142658_382pmmo0_.bkp
deleted backup piece
backup piece handle=/u06/flash_recovery_area/sls1/backupset/2007_06_14/o1_mf_nnndf_TAG20070614T143933_3732v7rf_.bkp recid=205 stamp=625243175
deleted backup piece
backup piece handle=/u06/flash_recovery_area/sls1/backupset/2007_06_14/o1_mf_nnndf_TAG20070614T143933_3732v7tr_.bkp recid=206 stamp=625243175
deleted backup piece
backup piece handle=/u06/flash_recovery_area/sls1/backupset/2007_06_14/o1_mf_nnndf_TAG20070614T143933_3732v7vs_.bkp recid=203 stamp=625243175
deleted backup piece
backup piece handle=/u06/flash_recovery_area/sls1/backupset/2007_06_14/o1_mf_nnndf_TAG20070614T143933_3732v9vs_.bkp recid=202 stamp=625243177
deleted backup piece
backup piece handle=/u06/flash_recovery_area/sls1/backupset/2007_06_14/o1_mf_nnndf_TAG20070614T143933_37336ohr_.bkp recid=213 stamp=625243541
deleted backup piece
backup piece handle=/u06/flash_recovery_area/sls1/backupset/2007_06_14/o1_mf_nnndf_TAG20070614T143933_37337snk_.bkp recid=204 stamp=625243577
deleted backup piece
backup piece handle=/u06/flash_recovery_area/sls1/backupset/2007_06_14/o1_mf_nnndf_TAG20070614T143933_3733g0j5_.bkp recid=207 stamp=625243774
deleted backup piece
backup piece handle=/u06/flash_recovery_area/sls1/backupset/2007_06_14/o1_mf_nnndf_TAG20070614T143933_3733kmdh_.bkp recid=209 stamp=625243890
deleted backup piece
backup piece handle=/u06/flash_recovery_area/sls1/backupset/2007_06_14/o1_mf_nnndf_TAG20070614T143933_3733lswb_.bkp recid=208 stamp=625243928
deleted backup piece
backup piece handle=/u06/flash_recovery_area/sls1/backupset/2007_06_14/o1_mf_nnndf_TAG20070614T143933_3733p33c_.bkp recid=214 stamp=625244034
deleted backup piece
backup piece handle=/u06/flash_recovery_area/sls1/backupset/2007_06_14/o1_mf_nnndf_TAG20070614T143933_3733pwvf_.bkp recid=211 stamp=625244058
deleted backup piece
backup piece handle=/u06/flash_recovery_area/sls1/backupset/2007_06_14/o1_mf_nnndf_TAG20070614T143933_3733rlpk_.bkp recid=210 stamp=625244114
deleted backup piece
backup piece handle=/u06/flash_recovery_area/sls1/backupset/2007_06_14/o1_mf_nnndf_TAG20070614T143933_3733srm3_.bkp recid=212 stamp=625244151
deleted backup piece
backup piece handle=/u06/flash_recovery_area/sls1/backupset/2007_06_14/o1_mf_annnn_TAG20070614T151741_37352pv5_.bkp recid=215 stamp=625245462
deleted backup piece
backup piece handle=/u06/flash_recovery_area/sls1/backupset/2007_06_15/o1_mf_annnn_TAG20070615T122717_375hh73n_.bkp recid=233 stamp=625321639
deleted backup piece
backup piece handle=/u06/flash_recovery_area/sls1/backupset/2007_06_26/o1_mf_annnn_TAG20070626T140558_382odbd8_.bkp recid=240 stamp=626277962
deleted backup piece
backup piece handle=/u06/flash_recovery_area/sls1/backupset/2007_06_26/o1_mf_annnn_TAG20070626T140558_382odbgc_.bkp recid=241 stamp=626277962
deleted backup piece
backup piece handle=/u06/flash_recovery_area/sls1/backupset/2007_06_26/o1_mf_annnn_TAG20070626T140558_382odbhd_.bkp recid=242 stamp=626277962
deleted backup piece
backup piece handle=/u06/flash_recovery_area/sls1/backupset/2007_06_26/o1_mf_annnn_TAG20070626T140558_382odbf8_.bkp recid=238 stamp=626277962
deleted backup piece
backup piece handle=/u06/flash_recovery_area/sls1/backupset/2007_06_26/o1_mf_annnn_TAG20070626T140558_382ofrxg_.bkp recid=239 stamp=626278008
deleted backup piece
backup piece handle=/u06/flash_recovery_area/sls1/backupset/2007_06_26/o1_mf_annnn_TAG20070626T142413_382pggv5_.bkp recid=244 stamp=626279054
deleted backup piece
backup piece handle=/u06/flash_recovery_area/sls1/backupset/2007_06_26/o1_mf_annnn_TAG20070626T142533_382pjytc_.bkp recid=246 stamp=626279134
deleted backup piece
backup piece handle=/u01/oracle/product/10.2.0/dbs/controlfile_c-1522268517-20070626-02 recid=247 stamp=626279136
deleted backup piece
backup piece handle=/u06/flash_recovery_area/sls1/backupset/2007_06_26/o1_mf_annnn_TAG20070626T142658_382pmmo0_.bkp recid=248 stamp=626279219
Deleted 24 objects

deleted backup piece
backup piece handle=54ik8t17_1_2 recid=230 stamp=625248833
deleted backup piece
backup piece handle=55ik8t17_1_2 recid=231 stamp=625249002
deleted backup piece
backup piece handle=56ik8t17_1_2 recid=229 stamp=625248832
deleted backup piece
backup piece handle=57ik8t17_1_2 recid=217 stamp=625248832
deleted backup piece
backup piece handle=58ik8tcl_1_2 recid=225 stamp=625249429
deleted backup piece
backup piece handle=59ik8tdo_1_2 recid=218 stamp=625248849
deleted backup piece
backup piece handle=5aik8tjs_1_2 recid=219 stamp=625249055
deleted backup piece
backup piece handle=5bik8tng_1_2 recid=221 stamp=625249186
deleted backup piece
backup piece handle=5cik8tol_1_2 recid=220 stamp=625249144
deleted backup piece
backup piece handle=5dik8trv_1_2 recid=226 stamp=625249433
deleted backup piece
backup piece handle=5eik8tsq_1_2 recid=223 stamp=625249316
deleted backup piece
backup piece handle=5fik8tui_1_2 recid=222 stamp=625249313
deleted backup piece
backup piece handle=5gik8tvm_1_2 recid=224 stamp=625249413
deleted backup piece
backup piece handle=5hik8v8l_1_2 recid=227 stamp=625249481
deleted backup piece
backup piece handle=5kikb9l5_1_2 recid=236 stamp=625330580
Deleted 15 objects


RMAN>
RMAN>
Report of database schema

List of Permanent Datafiles
===========================
File Size(MB) Tablespace RB segs Datafile Name
---- -------- -------------------- ------- ------------------------
1 1024 SYSTEM *** /u02/oradata/sls1/system01.dbf
2 &n
bsp; 512 UNDOTBS1 *** /u05/oradata/sls1/undotbs01.dbf
3 512 SYSAUX *** /u02/oradata/sls1/sysaux01.dbf
4 2040 SLS1_DATA *** /u03/oradata/sls1/sls1_data_01.dbf
5 2040 SLS1_DATA *** /u03/oradata/sls1/sls1_data_02.dbf
6 1024 SLS1_DATA *** /u03/oradata/sls1/sls1_data_03.dbf
7 2040 SLS1_INDEX *** /u04/oradata/sls1/sls1_index_01.dbf
8 1024 SLS1_INDEX *** /u04/oradata/sls1/sls1_index_02.dbf
9 2036 SLS1AUD_ARCH *** /u05/oradata/sls1/sls1aud_arch_01.dbf
10 1024 SLS1AUD_ARCH *** /u05/oradata/sls1/sls1aud_arch_02.dbf
11 128 USERS *** /u02/oradata/sls1/users01.dbf
12 1972 SLS1HIST_ARCH *** /u05/oradata/sls1/sls1hist_arch_01.dbf
13 100 FLOW_1 *** /u05/oradata/sls1/FLOW_1.dbf

List of Temporary Files
=======================
File Size(MB) Tablespace Maxsize(MB) Tempfile Name
---- -------- -------------------- ----------- --------------------
1 528 TEMP 1024 /u07/oradata/sls1/temp01.dbf

RMAN>
Report of files that need backup due to unrecoverable operations
File Type of Backup Required Name
---- ----------------------- -----------------------------------

RMAN>
RMAN>

Recovery Manager complete.
---------------------------------------------------------
Tue Jun 26 15:05:36 EDT 2007
---------------- rman_bkup.ksh completed ----------------

Posted by at
Labels: , , ,

No comments:

Post a Comment

Subscribe to: Post Comments (Atom)