---------------------------------------------------------
Fri Jun 15 14:56:06 EDT 2007
---------------- rman_tape_bkup.ksh started ------------------
Recovery Manager: Release 10.2.0.1.0 - Production on Fri Jun 15 14:56:07 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 15-JUN-07
allocated channel: ORA_SBT_TAPE_1
channel ORA_SBT_TAPE_1: sid=146 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=144 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=139 devtype=SBT_TAPE
channel ORA_SBT_TAPE_4: Tivoli Data Protection for Oracle: version 5.2.0.0
skipping backupset key 161; already backed up 1 time(s)
skipping backupset key 162; already backed up 1 time(s)
skipping backupset key 163; already backed up 1 time(s)
skipping backupset key 164; already backed up 1 time(s)
skipping backupset key 165; already backed up 1 time(s)
skipping backupset key 166; already backed up 1 time(s)
skipping backupset key 167; already backed up 1 time(s)
skipping backupset key 168; already backed up 1 time(s)
skipping backupset key 169; already backed up 1 time(s)
skipping backupset key 170; already backed up 1 time(s)
skipping backupset key 171; already backed up 1 time(s)
skipping backupset key 172; already backed up 1 time(s)
skipping backupset key 173; already backed up 1 time(s)
skipping backupset key 174; already backed up 1 time(s)
input backupset count=183 stamp=625325470 creation_time=15-JUN-07
channel ORA_SBT_TAPE_2: starting piece 1 at 15-JUN-07
channel ORA_SBT_TAPE_2: backup piece /u01/oracle/product/10.2.0/dbs/controlfile_c-1522268517-20070615-00
input backupset count=180 stamp=625321637 creation_time=15-JUN-07
channel ORA_SBT_TAPE_1: starting piece 1 at 15-JUN-07
channel ORA_SBT_TAPE_1: backup piece /u06/flash_recovery_area/sls1/backupset/2007_06_15/o1_mf_annnn_TAG20070615T122717_375hh73n_.bkp
piece handle=5kikb9l5_1_2 comment=API Version 2.0,MMS Version 5.2.0.0
channel ORA_SBT_TAPE_1: finished piece 1 at 15-JUN-07
channel ORA_SBT_TAPE_1: backup set complete, elapsed time: 00:00:03
piece handle=c-1522268517-20070615-00 comment=API Version 2.0,MMS Version 5.2.0.0
channel ORA_SBT_TAPE_2: finished piece 1 at 15-JUN-07
channel ORA_SBT_TAPE_2: backup set complete, elapsed time: 00:00:03
Finished backup at 15-JUN-07
Starting Control File and SPFILE Autobackup at 15-JUN-07
piece handle=c-1522268517-20070615-01 comment=API Version 2.0,MMS Version 5.2.0.0
Finished Control File and SPFILE Autobackup at 15-JUN-07
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 1024 /u07/oradata/sls1/temp01.dbf
RMAN>
RMAN>
Recovery Manager complete.
---------------------------------------------------------
Fri Jun 15 14:56:31 EDT 2007
---------------- rman_tape_bkup.ksh completed ----------------
 
;
No comments:
Post a Comment