Re: Cloning from physical standby
- From: David Fitzjarrell <oratune@xxxxxxxxx>
- To: painterman@xxxxxxxxx, oracle-l@xxxxxxxxxxxxx
- Date: Tue, 1 Feb 2011 11:48:00 -0800 (PST)
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@xxxxxxxxx>
To: oracle-l@xxxxxxxxxxxxx
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
Other related posts:
