Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Mailing Lists -> Oracle-L -> RE: Do anyone implemented Physical Standby using primary db hot backups?

RE: Do anyone implemented Physical Standby using primary db hot backups?

From: <oracle-l-bounce_at_freelists.org>
Date: Mon, 11 Sep 2006 11:12:37 +0200
Message-ID: <25D4919915CCF742A88EE3366D6D913D0D463EFA@mailserver1>

It is all the same, just do re cover database after restore database until cancel and put all the redo logs you have in stock in the DG arch_dest_1. Usually a DG is always done from a hot backup, setting from cold is the exception.

Any way when the log shipping starts, it will request all redo that were generated since the last scn of the backup up to now and roll on, for that reason I prefer to feed the first redo myself perform the roll forward.

Starting from rman it is even more simple : 'Duplicate database for standby database dorecover' whitout mention of any time/scn/archive and the rman will sync the DB.

B. Polarski

-----Original Message-----

From: Syed Jaffar Hussain [mailto:sjaffarhussain_at_gmail.com] Sent: Monday, 11 September, 2006 10:58 AM To: _oracle_L_list
Subject: Do anyone implemented Physical Standby using primary db hot backups?

Hello List,

I earlier, created standby database using cold backup and it is running without any issues.
However, now, I have task to created another standby database for one of the critical database, using previous hot backups.

I am just a little bit confused about this.

Do anyone from the list has implemented this kind?

Any refernece or steps would greatly helpful to me.

--

Best Regards,
Syed Jaffar Hussain
8i,9i & 10g OCP DBA

I blog at :http://jaffardba.blogspot.com/

http://www.oracle.com/technology/community/oracle_ace/ace1.html#hussain




"Winners don't do different things. They do things differently."
--

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

--

http://www.freelists.org/webpage/oracle-l Received on Mon Sep 11 2006 - 04:12:37 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US