Output log of rman_arch_bkup.ksh

This shows the output log of rman_arch_bkup.ksh

---------------------------------------------------------
Tue Jun 26 14:25:25 EDT 2007
---------------- rman_arch_bkup.ksh started ------------------

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

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

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=137 devtype=DISK
allocated channel: ORA_DISK_2
channel ORA_DISK_2: sid=135 devtype=DISK
allocated channel: ORA_DISK_3
channel ORA_DISK_3: sid=134 devtype=DISK
allocated channel: ORA_DISK_4
channel ORA_DISK_4: sid=133 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=15 recid=416 stamp=626279130
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_TAG20070626T142533_382pjytc_.bkp tag=TAG20070626T142533 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_15_382pjsyy_.arc recid=416 stamp=626279130
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-02 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=132 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=141 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=139 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=136 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 187 26-JUN-07
Backup Piece 245 26-JUN-07 /u01/oracle/product/10.2.0/dbs/controlfile_c-1522268517-20070626-01
deleted backup piece
backup piece handle=/u01/oracle/product/10.2.0/dbs/controlfile_c-1522268517-20070626-01 recid=245 stamp=626279056
Deleted 1 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 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 &
nbsp; 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 14:25:48 EDT 2007
---------------- rman_arch_bkup.ksh completed ----------------