Re: Cloning from physical standby

From: David Fitzjarrell <oratune_at_yahoo.com>
Date: Tue, 1 Feb 2011 11:48:00 -0800 (PST)
Message-ID: <932901.1352.qm_at_web65415.mail.ac4.yahoo.com>

You can start here:

http://oratips-ddf.blogspot.com/2010/06/please-stand-by.html

to create a secondary standby from the primary. Copy the archivelogs necessary then set autorecovery on and execute, at the SQL> prompt:

recover automatic standby database

until the archivelogs are applied and no messages appear stating that the database would experience errors on an open resetlogs. When that is complete then, at the SQL> prompt, execute:

alter database recover managed standby database finish;

followed by:

alter database activate physical standby database; alter database open;

and you should be done.  

David Fitzjarrell  

---

From: David Pintor <painterman_at_gmail.com> To: oracle-l_at_freelists.org
Sent: Mon, January 31, 2011 5:22:00 AM
Subject: Cloning from physical standby

Hi,

This question might seem a bit obvious for many of you, I'm just trying to figure out which would be the best way to clone a database using the physical standby (so i don't need to touch prod) into a test environment. I was thinking about the following steps:

• Stopping the physical standby
• Copying the files across to the test environment
• Restarting the physical standby (so it gets in sync again)
• Recreating the control file in test and starting up the db.

Would this, roughly, be correct?

Thanks for your help.

David       

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

Received on Tue Feb 01 2011 - 13:48:00 CST