1 2 Previous Next 26 Replies Latest reply: Oct 29, 2012 4:33 AM by user522961 RSS

    Duplicate in 11g

    user522961
      Hi,
      in 11g on Win 2008,
      has duplicating from active database any impact on source database ?

      In documentation it is mentioned :
      http://docs.oracle.com/cd/E11882_01/backup.112/e10642/rcmdupdb.htm#CHDJHHCC
       
      2.If you are performing active database duplication, then ensure that the following additional requirements are met: 
      
      ◦If the source database is open, then archiving must be enabled. 
      
      ◦If the source database is not open, then the database does not require instance recovery. 
      If the source is OPEN why does it require instance recovery ?
      Thank you.
        • 1. Re: Duplicate in 11g
          JohnWatson
          If the source is OPEN why does it require instance recovery ?
          Thank you.>
          The duplicate is made by copying files which are open, and therefore inconsistent: so you have to recover the duplicate to make it consistent before opening.
          • 2. Re: Duplicate in 11g
            Osama_Mustafa
            instance recovery means getting the database to a normal functioning state. which is mean changes that should happen with the database are not happened in a regular manner when the database starts a process called instance recovery happens such as rolling forward the committed transactions and rolling backward the uncommitted transactons
            • 3. Re: Duplicate in 11g
              user522961
              Ok, thank you. Then it is the duplicated database (the new one) that would be recovered ?
              And source databse would not be impacted ?
              • 4. Re: Duplicate in 11g
                JohnWatson
                Correct. The only impact on the source is the disc activity as the files are checkpointed and copied.
                • 5. Re: Duplicate in 11g
                  Osama_Mustafa
                  Ok, thank you. Then it is the duplicated database (the new one) that would be recovered ?
                  Yes
                  And source databse would not be impacted ?
                  Yes

                  Just As Note :
                  A duplicate database is distinct from a standby database, although both types of databases are created with the DUPLICATE command. A standby database is a copy of the primary database that you can update continually or periodically by using archived logs from the primary database. If the primary database is damaged or destroyed, then you can perform failover to the standby database and effectively transform it into the new primary database. A duplicate database, on the other hand, cannot be used in this way: it is not intended for failover scenarios and does not support the various standby recovery and failover options.

                  Read
                  http://docs.oracle.com/cd/B10500_01/server.920/a96566/rcmdupdb.htm#441820
                  • 6. Re: Duplicate in 11g
                    user522961
                    Let me come back.

                    I ran duplicate in ROMAN ;
                     
                    
                    DUPLICATE DATABASE TO NEWDB 
                       FROM ACTIVE DATABASE 
                      NOFILENAMECHECK; 
                    But it did not work. Because of :
                     
                    
                    ORA-19505: failed to identify file "M:\BASES\OLDDB\DATA\PREE.DBF"; 
                    ORA-27086: unable to lock file - already in use 
                    Of course , source database is open and in use.
                    Should it be in mount ?

                    For me it means that source should not be open but in documentation I did not see that be mentioned.

                    thanks.
                    • 7. Re: Duplicate in 11g
                      Osama_Mustafa
                      Sorry for that but can't post question into answered thread
                      Open New thread and i will help you there
                      • 8. Re: Duplicate in 11g
                        John Stegeman
                        I thought the documentation was quite clear. Either:

                        a). The database should be OPEN and in archivelog mode
                        b). The database should be MOUNTed and not requiring any recovery (e.g. it was shut down cleanly before restarting in MOUNT mode)
                        • 9. Re: Duplicate in 11g
                          user522961
                          the source database is open and in archive log mode.
                          Regards.
                          • 10. Re: Duplicate in 11g
                            John Stegeman
                            Sorry - didn't pay attention to the error message :)

                            http://docs.oracle.com/cd/E11882_01/backup.112/e10643/rcmsynta020.htm - search that page for 27086
                            • 11. Re: Duplicate in 11g
                              user522961
                              Thank you John.
                              a). The database should be OPEN and in archivelog mode
                              b). The database should be MOUNTed and not requiring any recovery (e.g. it was shut down cleanly before restarting in MOUNT mode) 
                              Are you talking about source database or duplicated(new DB) ?
                              • 12. Re: Duplicate in 11g
                                John Stegeman
                                Source, obviously (the destination doesn't exist yet) - however, read the post above...
                                • 13. Re: Duplicate in 11g
                                  abdul:
                                  hi,
                                  john means
                                  [on source]
                                  >
                                  a). The database should be OPEN and in archivelog mode
                                  >

                                  [on duplicate]
                                  >
                                  b). The database should be MOUNTed and not requiring any recovery (e.g. it was shut down cleanly before restarting in MOUNT mode)
                                  • 14. Re: Duplicate in 11g
                                    John Stegeman
                                    No, that's not what I meant.

                                    I meant the source database in both cases
                                    1 2 Previous Next