RMAN backup failure with error RMAN-03009 & ORA-19602

pawanratwani

Active Newcomer
Joined
Nov 23, 2010
Messages
9
Reaction score
1
Points
0
Hi,
I am using TSM6.2 client (win32bit) and TSM6.2 server(Win64bit). Whle trying to take RMAN backup I encountered following error:
Starting backup at 04-FEB-11
channel ch00: starting incremental level 0 datafile backup set
channel ch00: specifying datafile(s) in backup set
RMAN-03009: failure of backup command on ch00 channel at 02/04/2011 04:19:14
ORA-19602: cannot backup or copy active file in NOARCHIVELOG mode
continuing other job steps, job failed will not be re-run
channel ch00: starting incremental level 0 datafile backup set
channel ch00: specifying datafile(s) in backup set
including current control file in backup set
including current SPFILE in backup set
channel ch00: starting piece 1 at 04-FEB-11
channel ch00: finished piece 1 at 04-FEB-11
piece handle=1om3pse2_1_1 tag=TAG20110204T041909 comment=API Version 2.0,MMS Version 5.5.1
.0
channel ch00: backup set complete, elapsed time: 00:00:07
released channel: ch00
RMAN-00571: ================================================== =========
RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
RMAN-00571: ================================================== =========
RMAN-03009: failure of backup command on ch00 channel at 02/04/2011 04:19:14
ORA-19602: cannot backup or copy active file in NOARCHIVELOG mode
---------------------------------------
The configuration for my system are:
Version 5, Release 5, Level 1.0
(C) Copyright IBM Corporation 1997, 2008. All rights reserved.

Data Protection for Oracle Information
Version: 5
Release: 5
Level: 1
Sublevel: 0
Platform: 32bit DP Oracle Win32
Tivoli Storage Manager Server Information
Server Name: DSMSERV
Server Address: 192.168.12.99
Server Type: Windows
Server Port: 1500
Communication Method: TCP/IP
Session Information
Node Name: win2k3-hyperv1
Node Type: DP Oracle Win32
DSMI_DIR: c:\Tivoli\TSM\baclient
DSMI_ORC_CONFIG: c:\Tivoli\TSM\baclient\dsm.opt
TDPO_OPTFILE: C:\Tivoli\TSM\AgentOBA\tdpo.opt
Compression: FALSE
License Information: License file exists and contains valid license data.
--------------------------------------------------
Before this I have already shutdown the database, after some google, yet this doesn't work.
 
ORA-19602: cannot backup or copy active file in NOARCHIVELOG mode

DB has to be in archivelog mode for online and transactionlog backups
 
Hi Jeroen,
Thanks for the response.
I tried following steps before attempting even then backup failed:
SQL> SHUTDOWN

Could you suggest a sequence of steps which need to be followed before performing backup? Also what is the significance of of RMAN-03009 error here?
 
i am very new to this site, i want to know where to direct my problem to relating to my pc.or can you help me?
 
Back
Top