Re: Managed Standby Database Again

"bgt0990" <btighe_at_neometrics.com> wrote in message news:3df0c2e9$1_1_at_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.

Do you have something in place that deletes the ALs once applied? Are you sure you are connecting to the standby when querying for the changes?

>
> 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.

AFAIK you have to shut it down first before you can mount it as a standby database. Received on Fri Dec 06 2002 - 14:41:33 CST