Re: Creating Standby with RMAN documentation

From: <Laimutis.Nedzinskas_at_seb.lt>
Date: Wed, 8 Sep 2010 08:30:15 +0300
Message-ID: <OF98245753.BF838021-ONC2257798.001E2C74-C2257798.001E3CC6_at_seb.lt>

that's true. Oracle has db unique name in the catalog to deal with both databases.

---

Please consider the environment before printing this e-mail

                                                                           
             Fuad Arshad                                                   
             <fuadar_at_yahoo.com                                             


             >                                                          To 

             Sent by:                  "jkstill_at_gmail.com"                 
             oracle-l-bounce_at_f         <jkstill_at_gmail.com>                 
             reelists.org                                               cc 
                                       "aprilcsims_at_gmail.com"              
                                       <aprilcsims_at_gmail.com>,             
             2010.09.02 19:58          "oracle-l_at_freelists.org"            
                                       <oracle-l_at_freelists.org>            
                                                                   Subject 
             Please respond to         Re: Creating Standby with RMAN      
             fuadar_at_yahoo.com          documentation                       
                                                                           
                                                                           
                                                                           
                                                                           
                                                                           
                                                                           

Actually it's already registered as tw primary so you ca n use the same catalog entry to backup both or anyone and use the entries for restore purposes on the other

Fuad

On Sep 2, 2010, at 11:15 AM, Jared Still <jkstill_at_gmail.com> wrote:

      On Thu, Sep 2, 2010 at 8:52 AM, April Sims <aprilcsims_at_gmail.com>
      wrote:
            Can anyone else clarify this entry in the documentation? The
            part I am questioning is the "not register" statement. This is
            in the appendix F Creating a Standby Database with Recovery
            Manager

            "A standby database, unlike a duplicate database created by
            DUPLICATE without the FOR STANDBY OPTION, does not get a new
            DBID. Thus, you should not register the standby database with
            your recovery catalog."


      I have not done this, but I understand their intent.

      Two databases with the same DBID should not be registered in a
      recovery catalog,
      as the DBID is the primary key used to identify a database.

      You can register  the primary or the standby in a catalog, but not
      both.

      That doesn't mean you can't backup either/both, they just can't
      both be in the same recovery catalog.

      HTH

      Jared Still
      Certifiable Oracle DBA and Part Time Perl Evangelist
      Oracle Blog: http://jkstill.blogspot.com.
      Home Page: http://jaredstill.com.

--
http://www.freelists.org/webpage/oracle-l

Received on Wed Sep 08 2010 - 00:30:15 CDT