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

Home -> Community -> Usenet -> c.d.o.server -> Managed Standby Database Again

Managed Standby Database Again

From: bgt0990 <btighe_at_neometrics.com>
Date: Fri, 6 Dec 2002 10:44:43 -0500
Message-ID: <3df0c2e9$1_1@corp-goliath.newsgroups.com>


I'm setting up Managed standby database between 2 win 2k Version 8.1.7 servers. it all seems to be working well, however I was under the impression that the primary server would write a copy of the redo logs into the destination pointed to by the log_archive_dest_2. I never see the logs in the standby directory though the logs are applied and changes are seen if I stop recovery and bring up the standby DB in read only mode. The service "test2" is valid.

The other question would be, how do I bring the database from "open read only" back to "recover standby database" without having to shutdown the DB? If I try "alter database close" it says I can't do that while I am connected.

Thanks
Barry

Primary init.ora

 log_archive_start = true
 log_archive_format = %%ORACLE_SID%%%S.001
 log_archive_dest_1 = "LOCATION=D:\oracle\oradata\test1\archive"
 log_archive_dest_2 = "SERVICE=test2 OPTIONAL REOPEN=60"


Standby init.ora
log_archive_dest_1 = "location=C:\oracle\oradata\test1\archive" log_archive_format = TEST1%S.001

-----------== Posted via Newsfeed.Com - Uncensored Usenet News ==----------

   http://www.newsfeed.com The #1 Newsgroup Service in the World! -----= Over 100,000 Newsgroups - Unlimited Fast Downloads - 19 Servers =----- Received on Fri Dec 06 2002 - 09:44:43 CST

Original text of this message

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