Re: RMAN Incremental backups.

From: <Prasada.Gunda1_at_hartfordlife.com>
Date: Wed, 06 Feb 2002 16:48:46 -0800
Message-ID: <F001.004082AB.20020206162340@fatcity.com>

Thank you ALL for your responses. Rachel, I quoted exactly what the documentation says. It is in oracle 8i backup and recovery training doc by oracle. It is on page 43 of 12th chapter. That is why I was confused and seeking some suggestions.

Since our system is data warehouse system, we decided to run in noarchive log mode. All we care is, restoring the last backup. From the business point of view, It is okay to see the data as of last backup (that is previous day) and repopulate current day's data. We do not want to take the burden of running in archive log mode.

Having said this (please see my earlier mail down below for the questions I asked),
1. Are the incremental backups are valid which are done when the database is in mount state?
2. Since I want to keep the db open while doing rman backups, I wanted to open the db in archive log mode during backups(backup including archive logs) just for the sake of backups. Do you think the backups are not good for restore.

Thanks in advance for your help.

Best regards,
Prasad

                                                                                       
                            
                    Rachel                                                             
                            
                    Carmichael           To:     Multiple recipients of list ORACLE-L 
<ORACLE-L_at_fatcity.com>       
                    <wisernet100@        cc:                                           
                            
                    YAHOO.COM>           Subject:     Re: RMAN Incremental backups.    
                            
                    Sent by:                                                           
                            
                    root_at_fatcity.                                                      
                            
                    com                                                                
                            
                                                                                       
                            
                                                                                       
                            
                    02/06/2002                                                         
                            
                    01:08 PM                                                           
                            
                    Please                                                             
                            
                    respond to                                                         
                            
                    ORACLE-L

the documentation told you: no they are not

just because the incremental backup completed does not mean that it is usable.

Either leave the database in archivelog mode to do incremental backups or keep it in noarchivelog mode (and why you would not want to do that is a whole other discussion) and do full backups

Prasada.Gunda1_at_hartfordlife.com wrote:
>
>
>
>
> 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: Prasada.Gunda1_at_hartfordlife.com
>
> 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: ListGuru_at_fatcity.com (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).

Do You Yahoo!?
Send FREE Valentine eCards with Yahoo! Greetings! http://greetings.yahoo.com

--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: Rachel Carmichael
  INET: wisernet100_at_yahoo.com

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: ListGuru_at_fatcity.com (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).



-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: 
  INET: Prasada.Gunda1_at_hartfordlife.com

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: ListGuru_at_fatcity.com (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).

Received on Wed Feb 06 2002 - 18:48:46 CST