Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Managed Standby Database Again
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