-
Tivoli/Rman/9i
Tried to run a backup direct to tape and received :
RMAN-06004: ORACLE error from recovery catalog database: ORA-03114: not connected to ORACLE
Oracle 9i
Solaris 10
IBM Tivoli Storage Manager for Databases:
Data Protection for Oracle
Version 5, Release 3, Level 3.0
Backup script:
prompt> rman target / catalog=rmannew/rmannew@repo cmdfile=backup_rman_inc0
Recovery Manager: Release 9.2.0.8.0 - 64bit Production
Copyright (c) 1995, 2002, Oracle Corporation. All rights reserved.
connected to target database: COOPPROD (DBID=421256345)
connected to recovery catalog database
RMAN> run {
2> allocate channel t1 type 'SBT_TAPE' parms 'ENV=(TDPO_OPTFILE=/u1/app/oracle/TSM/tdpo.opt_COOPPROD)';
3> backup
4> incremental level 0
5> filesperset 3
6> format 'full_%d_%s_%p_%t'
7> (database);
8> change archivelog all validate;
9> backup
10> format 'arch_%d_%s_%p_%t'
11> filesperset 10
12> (archivelog until time 'Sysdate-3' all delete input);
13> release channel t1;
14> }
15>
16>
allocated channel: t1
channel t1: sid=28 devtype=SBT_TAPE
channel t1: Data Protection for Oracle: version 5.3.3.0
Starting backup at 01-DEC-09
channel t1: starting incremental level 0 datafile backupset
channel t1: specifying datafile(s) in backupset
input datafile fno=00013 name=/u2/oradata/COOPPROD/cfa01.dbf
input datafile fno=00021 name=/u3/oradata/COOPPROD/coa_index.dbf
input datafile fno=00012 name=/u3/oradata/COOPPROD/aura_index01.dbf
channel t1: starting piece 1 at 01-DEC-09
channel t1: finished piece 1 at 01-DEC-09
piece handle=full_COOPPROD_94_1_704469246 comment=API Version 2.0,MMS Version 5.3.3.0
channel t1: backup set complete, elapsed time: 01:18:58
channel t1: starting incremental level 0 datafile backupset
channel t1: specifying datafile(s) in backupset
input datafile fno=00028 name=/u2/oradata/COOPPROD/cfa02.dbf
input datafile fno=00002 name=/u4/oradata/COOPPROD/undotbs01.dbf
input datafile fno=00023 name=/u3/oradata/COOPPROD/ftreg_index01.dbf
channel t1: starting piece 1 at 01-DEC-09
channel t1: finished piece 1 at 01-DEC-09
piece handle=full_COOPPROD_95_1_704473984 comment=API Version 2.0,MMS Version 5.3.3.0
channel t1: backup set complete, elapsed time: 00:32:06
channel t1: starting incremental level 0 datafile backupset
channel t1: specifying datafile(s) in backupset
input datafile fno=00029 name=/u4/oradata/COOPPROD/coop_interface01.dbf
input datafile fno=00022 name=/u2/oradata/COOPPROD/ftreg01.dbf
input datafile fno=00030 name=/u2/oradata/COOPPROD/ftreg02.dbf
channel t1: starting piece 1 at 01-DEC-09
channel t1: finished piece 1 at 01-DEC-09
piece handle=full_COOPPROD_96_1_704475910 comment=API Version 2.0,MMS Version 5.3.3.0
channel t1: backup set complete, elapsed time: 00:16:25
channel t1: starting incremental level 0 datafile backupset
channel t1: specifying datafile(s) in backupset
input datafile fno=00020 name=/u2/oradata/COOPPROD/coa01.dbf
input datafile fno=00011 name=/u2/oradata/COOPPROD/aura01.dbf
input datafile fno=00018 name=/u2/oradata/COOPPROD/cfglog.dbf
channel t1: starting piece 1 at 01-DEC-09
channel t1: finished piece 1 at 01-DEC-09
piece handle=full_COOPPROD_97_1_704476896 comment=API Version 2.0,MMS Version 5.3.3.0
channel t1: backup set complete, elapsed time: 00:07:55
channel t1: starting incremental level 0 datafile backupset
channel t1: specifying datafile(s) in backupset
input datafile fno=00017 name=/u3/oradata/COOPPROD/cfa_index01.dbf
input datafile fno=00019 name=/u3/oradata/COOPPROD/cfglog_index01.dbf
input datafile fno=00026 name=/u3/oradata/COOPPROD/takeon_index.dbf
channel t1: starting piece 1 at 01-DEC-09
channel t1: finished piece 1 at 01-DEC-09
piece handle=full_COOPPROD_98_1_704477371 comment=API Version 2.0,MMS Version 5.3.3.0
channel t1: backup set complete, elapsed time: 00:07:25
channel t1: starting incremental level 0 datafile backupset
channel t1: specifying datafile(s) in backupset
including current SPFILE in backupset
including current controlfile in backupset
input datafile fno=00001 name=/u2/oradata/COOPPROD/system01.dbf
channel t1: starting piece 1 at 01-DEC-09
channel t1: finished piece 1 at 01-DEC-09
piece handle=full_COOPPROD_99_1_704477816 comment=API Version 2.0,MMS Version 5.3.3.0
channel t1: backup set complete, elapsed time: 00:04:56
channel t1: starting incremental level 0 datafile backupset
channel t1: specifying datafile(s) in backupset
input datafile fno=00009 name=/u2/oradata/COOPPROD/users01.dbf
input datafile fno=00008 name=/u2/oradata/COOPPROD/tools01.dbf
input datafile fno=00024 name=/u2/oradata/COOPPROD/snaplog.dbf
channel t1: starting piece 1 at 01-DEC-09
channel t1: finished piece 1 at 01-DEC-09
piece handle=full_COOPPROD_100_1_704478112 comment=API Version 2.0,MMS Version 5.3.3.0
channel t1: backup set complete, elapsed time: 00:04:45
channel t1: starting incremental level 0 datafile backupset
channel t1: specifying datafile(s) in backupset
input datafile fno=00005 name=/u2/oradata/COOPPROD/example01.dbf
input datafile fno=00010 name=/u2/oradata/COOPPROD/xdb01.dbf
input datafile fno=00003 name=/u2/oradata/COOPPROD/cwmlite01.dbf
channel t1: starting piece 1 at 01-DEC-09
channel t1: finished piece 1 at 01-DEC-09
piece handle=full_COOPPROD_101_1_704478397 comment=API Version 2.0,MMS Version 5.3.3.0
channel t1: backup set complete, elapsed time: 00:04:15
channel t1: starting incremental level 0 datafile backupset
channel t1: specifying datafile(s) in backupset
input datafile fno=00004 name=/u2/oradata/COOPPROD/drsys01.dbf
input datafile fno=00007 name=/u2/oradata/COOPPROD/odm01.dbf
input datafile fno=00025 name=/u2/oradata/COOPPROD/takeon.dbf
channel t1: starting piece 1 at 01-DEC-09
channel t1: finished piece 1 at 01-DEC-09
piece handle=full_COOPPROD_102_1_704478652 comment=API Version 2.0,MMS Version 5.3.3.0
channel t1: backup set complete, elapsed time: 00:04:35
channel t1: starting incremental level 0 datafile backupset
channel t1: specifying datafile(s) in backupset
input datafile fno=00006 name=/u3/oradata/COOPPROD/indx01.dbf
channel t1: starting piece 1 at 01-DEC-09
channel t1: finished piece 1 at 01-DEC-09
piece handle=full_COOPPROD_103_1_704478927 comment=API Version 2.0,MMS Version 5.3.3.0
channel t1: backup set complete, elapsed time: 00:04:55
Finished backup at 01-DEC-09
released channel: t1
RMAN-00571: ===========================================================
RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
RMAN-00571: ===========================================================
RMAN-03002: failure of crosscheck command at 12/01/2009 16:49:06
RMAN-06004: ORACLE error from recovery catalog database: ORA-03114: not connected to ORACLE
Can't see a crosscheck in there? Any help would be great.
-
It looks to me you are using a shared connection to connect to rman, while doing rman always use a dedicated connection.
Pablo (Paul) Berzukov
Author of Understanding Database Administration available at amazon and other bookstores.
Disclaimer: Advice is provided to the best of my knowledge but no implicit or explicit warranties are provided. Since the advisor explicitly encourages testing any and all suggestions on a test non-production environment advisor should not held liable or responsible for any actions taken based on the given advice.
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
Click Here to Expand Forum to Full Width
|