Data Guard Issue

[Angus John-Phillips]

Dear All,

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

Thanks,
Angus

[Steven E. Protter · Accepted solution]

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

[Yogeeraj_1]

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

[Angus John-Phillips]

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]

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]

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]

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

[Angus John-Phillips]

Thanks Mandar,
That worked.

[Angus John-Phillips]

Thanks