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

    Duplicate in 11g

    user522961
    user522961 Oct 9, 2012 5:35 AM
      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.
      • 563 Views
      • Tags:
        • 1. Re: Duplicate in 11g
          JohnWatson
          JohnWatson Oct 9, 2012 5:52 AM (in response to user522961)
          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.
          1 person found this helpful
          • 2. Re: Duplicate in 11g
            Osama_Mustafa
            Osama_Mustafa Oct 9, 2012 5:58 AM (in response to user522961)
            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
            1 person found this helpful
            • 3. Re: Duplicate in 11g
              user522961
              user522961 Oct 9, 2012 6:12 AM (in response to Osama_Mustafa)
              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
                JohnWatson Oct 9, 2012 6:17 AM (in response to user522961)
                Correct. The only impact on the source is the disc activity as the files are checkpointed and copied.
                1 person found this helpful
                • 5. Re: Duplicate in 11g
                  Osama_Mustafa
                  Osama_Mustafa Oct 9, 2012 6:19 AM (in response to user522961)
                  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
                  1 person found this helpful
                  • 6. Re: Duplicate in 11g
                    user522961
                    user522961 Oct 10, 2012 9:09 AM (in response to Osama_Mustafa)
                    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
                      Osama_Mustafa Oct 9, 2012 7:21 AM (in response to user522961)
                      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
                        John Stegeman Oct 9, 2012 7:30 AM (in response to user522961)
                        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
                          user522961 Oct 9, 2012 7:45 AM (in response to user522961)
                          the source database is open and in archive log mode.
                          Regards.
                          • 10. Re: Duplicate in 11g
                            John Stegeman
                            John Stegeman Oct 9, 2012 7:51 AM (in response to user522961)
                            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
                              user522961 Oct 9, 2012 7:51 AM (in response to John Stegeman)
                              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
                                John Stegeman Oct 9, 2012 7:52 AM (in response to user522961)
                                Source, obviously (the destination doesn't exist yet) - however, read the post above...
                                • 13. Re: Duplicate in 11g
                                  abdul:
                                  abdul: Oct 9, 2012 8:03 AM (in response to user522961)
                                  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
                                    John Stegeman Oct 9, 2012 8:22 AM (in response to abdul:)
                                    No, that's not what I meant.

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