Q

Archive log not updating

I have two databases. One is production and the other is standby on the same host. If I do anything committed in the production database, one archive log is created which is automatically transferred to the standby database. But the archive log is not updating.

I have two databases. One is production and the other is standby on the same host. I do all primary work and if I do anything committed in the production database, one archive log is created which is automatically transferred to the standby database. But the archive log is not updating, even if I shut down the standby database and restart using:
startup nomount pfile=".............../initsid.or"
alter database mount standby database;
recover database managed standby database;
alter database open read only;
I tried all these but the archive log is not updating. Can you please help?
Did you start your standby in managed recovery mode? Try the following in your standby database:
STARTUP NOMOUNT
ALTER DATABASE MOUNT STANDBY DATABASE;
ALTER DATABASE RECOVER MANAGED STANDBY DATABASE DISCONNECT;
I would recommend reading the Data Guard documentation as this is covered in much more detail.
This was first published in June 2006
This Content Component encountered an error

Pro+

Features

Enjoy the benefits of Pro+ membership, learn more and join.

Have a question for an expert?

Please add a title for your question

Get answers from a TechTarget expert on whatever's puzzling you.

You will be able to add details on the next page.

0 comments

Oldest 

Forgot Password?

No problem! Submit your e-mail address below. We'll send you an email containing your password.

Your password has been sent to:

-ADS BY GOOGLE

SearchDataManagement

SearchBusinessAnalytics

SearchSAP

SearchSQLServer

TheServerSide

SearchDataCenter

SearchContentManagement

SearchFinancialApplications

Close