ADSM-L

TDP for Oracle --exception raised in RPC: ORA-19602: cannot backup or copy active file in NOARCHIVELOG mode ----- Stuck -- Help

2004-08-27 06:48:31
Subject: TDP for Oracle --exception raised in RPC: ORA-19602: cannot backup or copy active file in NOARCHIVELOG mode ----- Stuck -- Help
From: Muhammad Sadat <sadat AT INFOTECH.COM DOT PK>
To: ADSM-L AT VM.MARIST DOT EDU
Date: Fri, 27 Aug 2004 15:45:19 +0500
Dear All,
I have just installed TDP for oracle 5.2.2 on Windows 2000 and Oracle 9i.
I had sent an e-mail with attachment to the list, which bounced back saying
there might be some virus in the e-mail attachment. anyways here are the
text of all the files.

Here are the files with configuration:


***************************************
1- tdpo.opt
DSMI_ORC_CONFIG    c:\Program Files\tivoli\tsm\agentoba\dsm.opt
DSMI_LOG           c:\Program Files\tivoli\tsm\agentoba

TDPO_FS            \ORACLE

TDPO_DATE_FMT  1
TDPO_TIME_FMT  1
TDPO_NUM_FMT   1
TDPO_LANGUAGE  enu

***************************************

2-dsm.opt

commmethod      tcpip
tcpport          1500
TCPServeraddress 192.168.0.244

*commmethod namedpipe
namedpipename \\.\pipe\adsmpipe

* COMPression ON
* COMPression OFf

Nodename ora-mobil

TCPBUFFSIZE   31
TCPWINDOWSIZE 24

Verbose

passwordaccess generate


***************************************
3-dbbk.scr (Script file to be run as cmdfile
run
{
allocate channel t1 type 'sbt_tape' parms
'ENV=(TDPO_OPTFILE=c:\RMAN\scripts\tdpo.opt)';
allocate channel t2 type 'sbt_tape' parms
'ENV=(TDPO_OPTFILE=c:\RMAN\scripts\tdpo.opt)';
backup filesperset 5 format 'df_%t_%s_%p' (database);
}

***************************************
4- RMAN Command to initiate backup.

rman target system/manager@ORACLE cmdfile c:\dbbk.scr msglog c:\dbbk.log

***************************************
5- dbbk.log

Recovery Manager: Release 9.0.1.1.1 - Production

(c) Copyright 2001 Oracle Corporation.  All rights reserved.

connected to target database: ORACLE (DBID=1408285449)

RMAN> run
2> {
3> allocate channel t1 type 'sbt_tape' parms
'ENV=(TDPO_OPTFILE=C:\tdpo.opt)';
4> allocate channel t2 type 'sbt_tape' parms
'ENV=(TDPO_OPTFILE=C:\tdpo.opt)';
5> backup filesperset 5 format 'df_%t_%s_%p' (database);
6> }
7>
using target database controlfile instead of recovery catalog
allocated channel: t1
channel t1: sid=9 devtype=SBT_TAPE
channel t1: Tivoli Data Protection for Oracle: version 5.2.0.0

allocated channel: t2
channel t2: sid=10 devtype=SBT_TAPE
channel t2: Tivoli Data Protection for Oracle: version 5.2.0.0

Starting backup at 27-AUG-04
channel t1: starting full datafile backupset
channel t1: specifying datafile(s) in backupset
including current controlfile in backupset
RMAN-00571: ===========================================================
RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
RMAN-00571: ===========================================================
RMAN-00579: the following error occurred at 08/27/2004 12:37:08
RMAN-03007: retryable error occurred during execution of command: backup
RMAN-12004: unhandled exception during command execution on channel t1
RMAN-10035: exception raised in RPC: ORA-19602: cannot backup or copy
active file in NOARCHIVELOG mode
RMAN-10031: ORA-19624 occurred during call to
DBMS_BACKUP_RESTORE.BACKUPDATAFILE

Recovery Manager complete.

***************************************

Please advise where i go wrong?

Sure TDP for orracle is very hard to setup.

Sadi