Hi Muhammad, you have to switch your Oracle database to ARCHIVELOG mode if you want to do backups with TDP Oracle. In this mode, all transactions made in database are written into archive redolog files, which are cumulated at given place. During online backup of Oracle DB (with TDP Oracle) it is switched into backup mode, which means that NO TRANSACTIONS are made in database but only into transaction (archive) redologs. This is why database must be in ARCHIVELOG mode. After backup completes, all transactions made in redologs are rolled forward to database back and it comes operational again. Of course, you must have enough space for archive redologs to keep data during backup and BETWEEN database or redolog backups.
Regards Tomas -----Original Message----- From: ADSM: Dist Stor Manager [mailto:[EMAIL PROTECTED] Behalf Of Muhammad Sadat Sent: Monday, August 30, 2004 6:20 AM To: [EMAIL PROTECTED] Subject: Re: TDP for Oracle --exception raised in RPC: ORA-19602: cannot backup or copy active file in NOARCHIVELOG mode ----- Stuck -- Help hmm thanks Jurjen. I was also thinking about going into the depths of Oracle alittle or atleast gather my DBA resource..! Regards, Sadat Jurjen Oskam <[EMAIL PROTECTED] NDOUS.ORG> To Sent by: "ADSM: Dist Stor [EMAIL PROTECTED] Manager" cc <[EMAIL PROTECTED] .EDU> 08/27/2004 06:51 PM Subject Re: TDP for Oracle --exception raised in RPC: ORA-19602: cannot Please respond to backup or copy active file in "ADSM: Dist Stor NOARCHIVELOG mode ----- Stuck -- Manager" Help <[EMAIL PROTECTED] .EDU> On Fri, Aug 27, 2004 at 03:45:19PM +0500, Muhammad Sadat wrote: > RMAN-10035: exception raised in RPC: ORA-19602: cannot backup or copy > active file in NOARCHIVELOG mode > Please advise where i go wrong? Your database is in NOARCHIVELOG mode, and you're trying to perform an inconsistent backup. This is not possible. You should read the Oracle documentation about backup and recovery for an explanation; the error you're encountering is not a TSM error. It's important that you understand the basics of Oracle backups, otherwise you might be unpleasantly surprised when you need to restore something. -- Jurjen Oskam "I often reflect that if "privileges" had been called "responsibilities" or "duties", I would have saved thousands of hours explaining to people why they were only gonna get them over my dead body." - Lee K. Gleason, VMS sysadmin
