Recovery Manager: Release 9.2.0.5.0 - Production

Copyright (c) 1995, 2002, Oracle Corporation.  All rights reserved.

RMAN> #************************************************************************
2> #       Filename      : backup_O920_ONLINE.rcv
3> #       Description   : RMAN ONLINE backup for O920 database
4> #       Use           : rman nocatalog @backup_O920_ONLINE.rcv
5> #                       20050420_1623 Generated by PDS::run_rman()
6> #************************************************************************
7> 
8> host 'echo "`date` : RMAN Start"';
9> 
10> connect target
11> 
12> run {
13> 
14> # Allocate 1 'SBT_TAPE' channel(s)
15> allocate channel PDS_SBT_TAPE_1 type 'SBT_TAPE'
16> parms 'ENV=(NSR_SERVER=nsr01,NSR_GROUP=db01)';
17> 
18> set command id to 'rman_%d_ONLINE';
19> 
20> backup incremental level 1 
21> skip inaccessible
22> tag bkup_db_ONLINE_inc_1 
23> format 'dbONLINE_%d_t%t_s%s_p%p'
24> # Cap backup set size at 8 GB
25> #maxsetsize = 8192M
26> filesperset 5
27> database;
28> 
29> sql 'alter system archive log current';
30> 
31> # Run archived redo log backup
32> backup  
33> format 'dbREDO_%d_t%t_s%s_p%p'
34> # Cap backup set size at 8 GB
35> #maxsetsize = 8192M
36> filesperset 10
37> archivelog
38> from time "to_date('04/14/2005-22:56:59','MM/DD/YYYY-HH24:MI:SS')";
39> 
40> # Backup/purge archived redo log files
41> backup  
42> format 'dbREDO_%d_t%t_s%s_p%p'
43> # Cap backup set size at 8 GB
44> #maxsetsize = 8192M
45> filesperset 10
46> archivelog
47> until time "to_date('04/14/2005-22:56:59','MM/DD/YYYY-HH24:MI:SS')" delete input;
48> 
49> # Release 1 'SBT_TAPE' channel(s)
50> release channel PDS_SBT_TAPE_1;
51> 
52> }
53> 
54> host 'echo "`date` : RMAN Done"';
55> #************************************************************************
56> 
57> 
Wed Apr 20 16:23:17 EDT 2005 : RMAN Start
host command complete

connected to target database: O920 (DBID=1541654257)
using target database controlfile instead of recovery catalog

allocated channel: PDS_SBT_TAPE_1
channel PDS_SBT_TAPE_1: sid=12 devtype=SBT_TAPE
channel PDS_SBT_TAPE_1: MMS Version 2.1.2.0

executing command: SET COMMAND ID

Starting backup at 20-APR-2005 16:23:21
channel PDS_SBT_TAPE_1: starting incremental level 1 datafile backupset
channel PDS_SBT_TAPE_1: specifying datafile(s) in backupset
input datafile fno=00005 name=/d05/oradata/O920/example01.dbf
input datafile fno=00010 name=/d05/oradata/O920/xdb01.dbf
input datafile fno=00008 name=/d05/oradata/O920/tools01.dbf
input datafile fno=00006 name=/d05/oradata/O920/indx01.dbf
input datafile fno=00009 name=/d05/oradata/O920/users01.dbf
channel PDS_SBT_TAPE_1: starting piece 1 at 20-APR-2005 16:23:23
channel PDS_SBT_TAPE_1: finished piece 1 at 20-APR-2005 16:23:48
piece handle=dbONLINE_O920_t556129403_s277_p1 comment=API Version 1.1,MMS Version 2.1.2.0
channel PDS_SBT_TAPE_1: backup set complete, elapsed time: 00:00:25
channel PDS_SBT_TAPE_1: starting incremental level 1 datafile backupset
channel PDS_SBT_TAPE_1: specifying datafile(s) in backupset
input datafile fno=00002 name=/d05/oradata/O920/undotbs01.dbf
input datafile fno=00011 name=/d05/oradata/O920/rman01.dbf
input datafile fno=00003 name=/d05/oradata/O920/cwmlite01.dbf
input datafile fno=00007 name=/d05/oradata/O920/odm01.dbf
channel PDS_SBT_TAPE_1: starting piece 1 at 20-APR-2005 16:23:48
channel PDS_SBT_TAPE_1: finished piece 1 at 20-APR-2005 16:24:03
piece handle=dbONLINE_O920_t556129428_s278_p1 comment=API Version 1.1,MMS Version 2.1.2.0
channel PDS_SBT_TAPE_1: backup set complete, elapsed time: 00:00:15
channel PDS_SBT_TAPE_1: starting incremental level 1 datafile backupset
channel PDS_SBT_TAPE_1: specifying datafile(s) in backupset
including current SPFILE in backupset
including current controlfile in backupset
input datafile fno=00001 name=/d05/oradata/O920/system01.dbf
input datafile fno=00004 name=/d05/oradata/O920/drsys01.dbf
channel PDS_SBT_TAPE_1: starting piece 1 at 20-APR-2005 16:24:05
channel PDS_SBT_TAPE_1: finished piece 1 at 20-APR-2005 16:24:20
piece handle=dbONLINE_O920_t556129444_s279_p1 comment=API Version 1.1,MMS Version 2.1.2.0
channel PDS_SBT_TAPE_1: backup set complete, elapsed time: 00:00:16
Finished backup at 20-APR-2005 16:24:20

sql statement: alter system archive log current

Starting backup at 20-APR-2005 16:24:26
current log archived
channel PDS_SBT_TAPE_1: starting archive log backupset
channel PDS_SBT_TAPE_1: specifying archive log(s) in backup set
input archive log thread=1 sequence=144 recid=138 stamp=555635107
input archive log thread=1 sequence=145 recid=139 stamp=555660212
input archive log thread=1 sequence=146 recid=140 stamp=556129466
input archive log thread=1 sequence=147 recid=141 stamp=556129467
channel PDS_SBT_TAPE_1: starting piece 1 at 20-APR-2005 16:24:28
channel PDS_SBT_TAPE_1: finished piece 1 at 20-APR-2005 16:24:43
piece handle=dbREDO_O920_t556129467_s280_p1 comment=API Version 1.1,MMS Version 2.1.2.0
channel PDS_SBT_TAPE_1: backup set complete, elapsed time: 00:00:16
Finished backup at 20-APR-2005 16:24:43

Starting backup at 20-APR-2005 16:24:43
channel PDS_SBT_TAPE_1: starting archive log backupset
channel PDS_SBT_TAPE_1: specifying archive log(s) in backup set
input archive log thread=1 sequence=124 recid=124 stamp=554985640
input archive log thread=1 sequence=125 recid=125 stamp=554994342
input archive log thread=1 sequence=126 recid=126 stamp=554994345
input archive log thread=1 sequence=127 recid=127 stamp=555353455
input archive log thread=1 sequence=128 recid=128 stamp=555353456
input archive log thread=1 sequence=129 recid=129 stamp=555353649
input archive log thread=1 sequence=130 recid=130 stamp=555353649
input archive log thread=1 sequence=131 recid=131 stamp=555408068
input archive log thread=1 sequence=132 recid=132 stamp=555408070
input archive log thread=1 sequence=133 recid=133 stamp=555408087
channel PDS_SBT_TAPE_1: starting piece 1 at 20-APR-2005 16:24:46
channel PDS_SBT_TAPE_1: finished piece 1 at 20-APR-2005 16:25:01
piece handle=dbREDO_O920_t556129485_s281_p1 comment=API Version 1.1,MMS Version 2.1.2.0
channel PDS_SBT_TAPE_1: backup set complete, elapsed time: 00:00:16
channel PDS_SBT_TAPE_1: deleting archive log(s)
archive log filename=/d105/oradata/O920/archive/arch_1_124.dbf recid=124 stamp=554985640
archive log filename=/d105/oradata/O920/archive/arch_1_125.dbf recid=125 stamp=554994342
archive log filename=/d105/oradata/O920/archive/arch_1_126.dbf recid=126 stamp=554994345
archive log filename=/d105/oradata/O920/archive/arch_1_127.dbf recid=127 stamp=555353455
archive log filename=/d105/oradata/O920/archive/arch_1_128.dbf recid=128 stamp=555353456
archive log filename=/d105/oradata/O920/archive/arch_1_129.dbf recid=129 stamp=555353649
archive log filename=/d105/oradata/O920/archive/arch_1_130.dbf recid=130 stamp=555353649
archive log filename=/d105/oradata/O920/archive/arch_1_131.dbf recid=131 stamp=555408068
archive log filename=/d105/oradata/O920/archive/arch_1_132.dbf recid=132 stamp=555408070
archive log filename=/d105/oradata/O920/archive/arch_1_133.dbf recid=133 stamp=555408087
channel PDS_SBT_TAPE_1: starting archive log backupset
channel PDS_SBT_TAPE_1: specifying archive log(s) in backup set
input archive log thread=1 sequence=134 recid=134 stamp=555408090
input archive log thread=1 sequence=141 recid=135 stamp=555584322
input archive log thread=1 sequence=142 recid=136 stamp=555584531
input archive log thread=1 sequence=143 recid=137 stamp=555609755
input archive log thread=1 sequence=144 recid=138 stamp=555635107
channel PDS_SBT_TAPE_1: starting piece 1 at 20-APR-2005 16:25:03
channel PDS_SBT_TAPE_1: finished piece 1 at 20-APR-2005 16:25:28
piece handle=dbREDO_O920_t556129502_s282_p1 comment=API Version 1.1,MMS Version 2.1.2.0
channel PDS_SBT_TAPE_1: backup set complete, elapsed time: 00:00:26
channel PDS_SBT_TAPE_1: deleting archive log(s)
archive log filename=/d105/oradata/O920/archive/arch_1_134.dbf recid=134 stamp=555408090
archive log filename=/d105/oradata/O920/archive/arch_1_141.dbf recid=135 stamp=555584322
archive log filename=/d105/oradata/O920/archive/arch_1_142.dbf recid=136 stamp=555584531
archive log filename=/d105/oradata/O920/archive/arch_1_143.dbf recid=137 stamp=555609755
archive log filename=/d105/oradata/O920/archive/arch_1_144.dbf recid=138 stamp=555635107
Finished backup at 20-APR-2005 16:25:28

released channel: PDS_SBT_TAPE_1

Wed Apr 20 16:25:29 EDT 2005 : RMAN Done
host command complete

Recovery Manager complete.