cancel
Showing results for 
Search instead for 
Did you mean: 

Data Guard Issue

SOLVED
Go to solution
Angus John-Phillips
Occasional Advisor

Data Guard Issue

Dear All,

I have a problem with Data Guard. My archive log files are not applied to my physical Standby db.

Thanks,
Angus
8 REPLIES
Steven E. Protter
Exalted Contributor
Solution

Re: Data Guard Issue

Shalom Angus,

At this point, based on what you posted, it could be anything.

I'd run through a little checklist to try and narrow it down.

1) Is the network between the two machines up?
2) Are the archive logs on the standby system and unapplied or are they absent.
3) Check the log files for Data Guard
4) Check the run status of both databases with sqlplus
5) What do the log files for Data Guard say?
6) Is tnsping working between the relavent databases.

An error message would do wonders to cut this problem down to a reasonable size.

SEP
Steven E Protter
Owner of ISN Corporation
http://isnamerica.com
http://hpuxconsulting.com
Sponsor: http://hpux.ws
Twitter: http://twitter.com/hpuxlinux
Founder http://newdatacloud.com
Yogeeraj_1
Honored Contributor

Re: Data Guard Issue

hi Angus,

You must also verify that the archived logs are being properly generated and sent to the standby!

You may wish to check your alert.log on both sides.

did you find any error messages?

hope this helps!

kind regards
yogeeraj
No person was ever honoured for what he received. Honour has been the reward for what he gave (clavin coolidge)
Angus John-Phillips
Occasional Advisor

Re: Data Guard Issue

Shalom Steve,

There was a network issue and at this point the archiving stopped.The archive logs on the standby system are not unapplied so they are they absent.

Sorry I can't o/p the entries from the alert log but system is down for another 1 hour while the generated is being resolved.

How would I apply this logs from the primary to the stndby database. I beleive all i need to do is as followed but not 100 % sure and need clarification.

1.% rcp /u01/oracle/dbs/r_1_90.arc STBYHOST:/u01/oracle/stdby/stdby_1_90.arc
2.On the standby database issue 'RECOVER STANDBY DATABASE;'

Thanks,
Angus
Angus John-Phillips
Occasional Advisor

Re: Data Guard Issue

Sorry that should say that the following :

There was a network issue and at this point the archiving stopped.The archive logs on the standby system are now unapplied so they are they absent.

Sorry I can't o/p the entries from the alert log but system is down for another 1 hour while the generated is being resolved.

How would I apply this logs from the primary to the stndby database. I beleive all i need to do is as followed but not 100 % sure and need clarification.

1.% rcp /u01/oracle/dbs/r_1_90.arc STBYHOST:/u01/oracle/stdby/stdby_1_90.arc
2.On the standby database issue 'RECOVER STANDBY DATABASE;'

Thanks,
Angus
mghosalk
Advisor

Re: Data Guard Issue

i assume you are using 8.1.5
manual recovery mode:
STARTUP NOMOUNT;
ALTER DATABASE MOUNT STANDBY DATABASE;
RECOVER STANDBY DATABASE ;

managed(automatic) recovery mode:
STARTUP NOMOUNT;
ALTER DATABASE MOUNT STANDBY DATABASE;
RECOVER MANAGED STANDBY DATABASE;

-Mandar
Yogeeraj_1
Honored Contributor

Re: Data Guard Issue

hi Angus,

if your primary database has stopped archiving the logs, you can reactivate by issueing the following command:

sql> archive log start

Note that you can query your archiver status using the following command:

sql> archive log list

You need to verify that your archiver is operating properly.

kind regards
yogeeraj
No person was ever honoured for what he received. Honour has been the reward for what he gave (clavin coolidge)
Angus John-Phillips
Occasional Advisor

Re: Data Guard Issue

Thanks Mandar,
That worked.
Angus John-Phillips
Occasional Advisor

Re: Data Guard Issue

Thanks