RE: help - rman doesn't work on non archilve log db

RE: help - rman doesn't work on non archilve log db

 

  

If you want to backup using RMAN and the target is in NO ARCHIVE mode
the target cannot be OPEN. You have to shut it down and put it in a
MOUNT state. Note that if you backup this way you will only be able to
restore the DB from the last backup and you will lose all data between
backups. Also, if you use ARCHIVE mode you do not have to shutdown the
database at all and you can do a full recover up to the point of
failure.

If you put the target DB in ARCHIVE mode the first example will work but
you do not have to shut down. You would connect to both target and
catalog and remove the mount command. You would also need to include
backing up your archive logs.

In the second example you are not connected to the catalog DB and RMAN
needs to be to do the type of backup you are trying to do.

When you try to connect to the catalog it says is is down or shutting
down. Verify the catalog DB is up and running.

If you decide to do RMAN backups in NO ARCHIVE mode you will not need to
connect to a catalog. Shutdown the target DB, connect to the target, and
run your script with the MOUNT command. You will then need an "alter
database open;" at the end.


~Gaurav
Database administrator.
Service power.
Louisville,KY


-----Original Message-----
From: Kay Hume
[mailto:oracledba-ezmlmshield-x70524220.[Email address protected]
Sent: Monday, July 31, 2006 5:10 PM
To: LazyDBA Discussion
Subject: help - rman doesn't work on non archilve log db

Here is the error. Does anyone know why this would come up?



Starting backup at 31-JUL-06

channel d1: starting full datafile backupset

channel d1: specifying datafile(s) in backupset

released channel: d1

released channel: d2

released channel: d3

released channel: d4

RMAN-00571: ===========================================================

RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============

RMAN-00571: ===========================================================

RMAN-03009: failure of backup command on d1 channel at 07/31/2006
03:00:20

ORA-19602: cannot backup or copy active file in NOARCHIVELOG mode



RMAN>



--------
website: http://www.LazyDBA.com
Please don't reply to RTFM questions
Oracle documentation is here: http://tahiti.oracle.com
To unsubscribe: see http://www.lazydba.com/unsubscribe.html
To subscribe: see http://www.lazydba.com
By using this list you agree to these
terms:http://www.lazydba.com/legal.html


Oracle LazyDBA home page