This discussion is archived
1 2 Previous Next 26 Replies Latest reply: Oct 29, 2012 2:33 AM by user522961 RSS

Duplicate in 11g

user522961 Newbie
Currently Being Moderated
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 Guru
    Currently Being Moderated
    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 Oracle ACE
    Currently Being Moderated
    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 Newbie
    Currently Being Moderated
    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 Guru
    Currently Being Moderated
    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 Oracle ACE
    Currently Being Moderated
    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 Newbie
    Currently Being Moderated
    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 Oracle ACE
    Currently Being Moderated
    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 Oracle ACE
    Currently Being Moderated
    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 Newbie
    Currently Being Moderated
    the source database is open and in archive log mode.
    Regards.
  • 10. Re: Duplicate in 11g
    John Stegeman Oracle ACE
    Currently Being Moderated
    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 Newbie
    Currently Being Moderated
    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 Oracle ACE
    Currently Being Moderated
    Source, obviously (the destination doesn't exist yet) - however, read the post above...
  • 13. Re: Duplicate in 11g
    abdul: Newbie
    Currently Being Moderated
    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 Oracle ACE
    Currently Being Moderated
    No, that's not what I meant.

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

Legend

  • Correct Answers - 10 points
  • Helpful Answers - 5 points