Hi All,

I am new to RMAN. I am reading RMAN documentation and doing some testing on
our development box.

I have couple of questions.

1. Our database is in NOARCHIVE LOG mode and I would like to do Incremental
backups.
     Since db is in noarchive log mode, I put the database in mount state
and did the base level
     and incremental backups. Looks like it worked fine.

     In one of the training documentation, it says 'Because the database is
in noarchive log mode, the incrementals are
     not applicable,  so use the full backup option'.

     It is contrary to what I did. Am I missing something here. please
clarify me. Are the backups valid?


2. Since the database is in noarchive log mode, db is in mount state during
full/incremental backup.
     I want to keep the database open if possible and would like to know if
the following procedure works to
    keep the database open during the backup.

   1. Shutdown the db before backup.
   2. Bring back the db in ARCHIVE LOG mode.
   3. Perform full/incremental backups (including archive log files) while
the database is open.
   4. Shutdown the db after backup is done.
   5. Bring back the db in NOARCHIVE LOG mode.

   I am not sure whether it makes sense or not. Please pass your
suggestions.

Thanks in advance for your suggestions.
Best regards,
Prasad



-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: 
  INET: [EMAIL PROTECTED]

Fat City Network Services    -- (858) 538-5051  FAX: (858) 538-5051
San Diego, California        -- Public Internet access / Mailing Lists
--------------------------------------------------------------------
To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).

Reply via email to