Recovery Manager: Release 10.2.0.1.0 - Production on Mon Jun 2 01:00:02 2008

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

RMAN> 
RMAN> CONNECT TARGET *
connected to target database: ORA01 (DBID=639147973)

RMAN> CONNECT CATALOG *
connected to recovery catalog database

RMAN> **end-of-file**

RMAN> 
RMAN> # INCREMENTAL LEVEL 1 
2> RUN
3> {
4>      ALLOCATE CHANNEL c1 DEVICE TYPE 'sbt_tape'PARMS
5>     'ENV=(TDPO_OPTFILE=/opt/tivoli/tsm/client/oracle/bin/tdpo.opt)';
6> 
7>     BACKUP INCREMENTAL LEVEL 1 FILESPERSET 1
8>     TAG = 'INC LVL 1 DB BKUP' DATABASE INCLUDE CURRENT CONTROLFILE
9>     FORMAT = 'Inc_1_%U_%T.bkp';
10>     
11> 
12>     BACKUP FILESPERSET 10
13>     FORMAT = 'Arch_%U_%T.bkp'
14>     ARCHIVELOG ALL 
15>     DELETE INPUT;
16>     #DELETE ARCHIVELOG UNTIL TIME 'SYSDATE-1';
17>     RELEASE CHANNEL c1;
18> }
allocated channel: c1
channel c1: sid=96 devtype=SBT_TAPE
channel c1: Data Protection for Oracle: version 5.3.3.0

Starting backup at 02-JUN-08
channel c1: starting incremental level 1 datafile backupset
channel c1: specifying datafile(s) in backupset
input datafile fno=00016 name=/u01/mannual/oracle/oradata/ora01/mannual_M_IND/mannual_M_IND_01.dbf
channel c1: starting piece 1 at 02-JUN-08
RMAN-00571: ===========================================================
RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
RMAN-00571: ===========================================================
RMAN-03009: failure of backup command on c1 channel at 06/02/2008 01:13:50
RMAN-10038: database session for channel c1 terminated unexpectedly

RMAN> 
RMAN> 
RMAN> RUN
2> {
3>      ALLOCATE CHANNEL a1 TYPE DISK;
4>      ALLOCATE CHANNEL c1 DEVICE TYPE 'sbt_tape'PARMS
5>     'ENV=(TDPO_OPTFILE=/opt/tivoli/tsm/client/oracle/bin/tdpo.opt)';
6> 
7> 
8>     CROSSCHECK BACKUP;
9>     DELETE EXPIRED BACKUP;
10> 
11>     DELETE OBSOLETE;
12> 
13>     RELEASE CHANNEL c1;
14>     RELEASE CHANNEL a1;
15> }
allocated channel: a1
channel a1: sid=96 devtype=DISK

allocated channel: c1
channel c1: sid=108 devtype=SBT_TAPE
channel c1: Data Protection for Oracle: version 5.3.3.0



RMAN retention policy will be applied to the command
RMAN retention policy is set to redundancy 2
Deleting the following obsolete backups and copies:
Type                 Key    Completion Time    Filename/Handle
-------------------- ------ ------------------ --------------------
Control File Copy     133418 31-MAY-08          /home/oracle/RMAN_BACKUP/cpcurrCTL_cf_D-ORA01_id-639147973_frjhngo8_20080531.ora
released channel: a1
released channel: c1
RMAN-00571: ===========================================================
RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
RMAN-00571: ===========================================================
RMAN-03009: failure of delete command on c1 channel at 06/02/2008 01:13:53
RMAN-10015: error compiling PL/SQL program
RMAN-10014: PL/SQL error 0 on line 621 column 4: Statement ignored
RMAN-10014: PL/SQL error 201 on line 621 column 4: identifier 'EXITED' must be declared
RMAN-10014: PL/SQL error 0 on line 573 column 16: Statement ignored
RMAN-10014: PL/SQL error 201 on line 573 column 16: identifier 'DEB' must be declared
RMAN-10014: PL/SQL error 0 on line 463 column 16: Statement ignored
RMAN-10014: PL/SQL error 201 on line 463 column 16: identifier 'DEB' must be declared
RMAN-10014: PL/SQL error 0 on line 381 column 16: Statement ignored
RMAN-10014: PL/SQL error 201 on line 381 column 16: identifier 'DEB' must be declared
RMAN-10014: PL/SQL error 0 on line 336 column 16: Statement ignored
RMAN-10014: PL/SQL error 201 on line 336 column 16: identifier 'DEB' must be declared
RMAN-10014: PL/SQL error 0 on line 259 column 13: Statement ignored
RMAN-10014: PL/SQL error 201 on line 259 column 29: identifier 'STAMP2DATE' must be declared
RMAN-10014: PL/SQL error 0 on line 234 column 10: Statement ignored
RMAN-10014: PL/SQL error 201 on line 235 column 24: identifier 'BOOL2CHAR' must be declared
RMAN-10014: PL/SQL error 0 on line 231 column 16: Statement ignored
RMAN-10014: PL/SQL error 201 on line 231 column 16: identifier 'DEB' must be declared
RMAN-10014: PL/SQL error 0 on line 226 column 16: Statement ignored
RMAN-10014: PL/SQL error 201 on line 226 column 16: identifier 'DEB' must be declared
RMAN-10014: PL/SQL error 0 on line 208 column 16: Statement ignored
RMAN-10014: PL/SQL error 201 on line 208 column 16: identifier 'DEB' must be declared
RMAN-10014: PL/SQL error 0 on line 201 column 16: Statement ignored
RMAN-10014: PL/SQL error 201 on line 201 column 16: identifier 'DEB' must be declared
RMAN-10014: PL/SQL error 0 on line 199 column 13: Statement ignored
RMAN-10014: PL/SQL error 201 on line 199 column 13: identifier 'DEB' must be declared
RMAN-10014: PL/SQL error 0 on line 196 column 7: Statement ignored
RMAN-10014: PL/SQL error 201 on line 196 column 50: identifier 'BOOL2CHAR' must be declared
RMAN-10014: PL/SQL error 0 on line 191 column 10: Statement ignored
RMAN-10014: PL/SQL error 201 on line 191 column 10: identifier 'DEB' must be declared
RMAN-10014: PL/SQL error 0 on line 189 column 10: Statement ignored
RMAN-10014: PL/SQL error 201 on line 189 column 10: identifier 'DEB' must be declared
RMAN-10014: PL/SQL error 0 on line 181 column 19: Statement ignored
RMAN-10014: PL/SQL error 201 on line 181 column 44: identifier 'GETERRM' must be declared
RMAN-10014: PL/SQL error 0 on line 109 column 7: Statement ignored
RMAN-10014: PL/SQL error 201 on line 109 column 7: identifier 'DEB' must be declared
RMAN-10014: PL/SQL error 0 on line 105 column 7: Statement ignored
RMAN-10014: PL/SQL error 201 on line 105 column 7: identifier 'DEB' must be declared
RMAN-10014: PL/SQL error 0 on line 68 column 4: SQL Statement ignored
RMAN-10014: PL/SQL error 201 on line 77 column 11: identifier 'X$DUAL' must be declared
RMAN-10014: PL/SQL error 0 on line 67 column 4: Statement ignored
RMAN-10014: PL/SQL error 201 on line 67 column 4: identifier 'DEB' must be declared
RMAN-10014: PL/SQL error 0 on line 66 column 4: Statement ignored
RMAN-10014: PL/SQL error 201 on line 66 column 4: identifier 'ENTERED' must be declared

RMAN> 
RMAN> RUN
2> {
3>  ALLOCATE CHANNEL t1 TYPE DISK;
4>  BACKUP AS COPY CURRENT CONTROLFILE FORMAT  '/home/oracle/RMAN_BACKUP/cpcurrCTL_%U_%T.ora';
5>  RELEASE CHANNEL t1;
6> }
allocated channel: t1
channel t1: sid=96 devtype=DISK

Starting backup at 02-JUN-08
channel t1: starting datafile copy
copying current control file
output filename=/home/oracle/RMAN_BACKUP/cpcurrCTL_cf_D-ORA01_id-639147973_hajhskqh_20080602.ora tag=TAG20080602T011353 recid=512 stamp=656298834
channel t1: datafile copy complete, elapsed time: 00:00:01
Finished backup at 02-JUN-08

released channel: t1

RMAN> **end-of-file**

RMAN> 

Recovery Manager complete.