Re: Managed Standby Database Again

No, nothing in place to delete them, in fact the ones that I manually moved over to do the synch up "recover standby database" are all still there.

I'm doing a V$log_history on the standby database and it shows me the logs being applied but it won't let me query anything but fixed views so I know I'm in the standby DB. The times I have brought the standby up in read only mode show the changes to the tables.

I'm confused

Barry

"Chuck" <chuckh_at_softhome.net> wrote in message news:asr222$ssrsa$1_at_ID-85580.news.dfncis.de...
>
> "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.
>
>

-----------== 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 - 14:55:49 CST