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:ADSM-L AT VM.MARIST DOT EDU]On Behalf Of
Muhammad Sadat
Sent: Monday, August 30, 2004 6:20 AM
To: ADSM-L AT VM.MARIST DOT EDU
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
             <jurjen-tsm@STUPE
             NDOUS.ORG>                                                 To
             Sent by: "ADSM:
             Dist Stor                 ADSM-L AT VM.MARIST DOT EDU
             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