topic Re: Data Guard Issue in Operating System - HP-UX

Data Guard Issue

Angus John-Phillips — Fri, 29 Sep 2006 06:02:05 GMT

Dear All,

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

Thanks,
Angus

Re: Data Guard Issue

Steven E. Protter — Fri, 29 Sep 2006 06:27:04 GMT

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

Re: Data Guard Issue

Yogeeraj_1 — Fri, 29 Sep 2006 06:59:13 GMT

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

Re: Data Guard Issue

Angus John-Phillips — Fri, 29 Sep 2006 08:00:16 GMT

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

Re: Data Guard Issue

Angus John-Phillips — Fri, 29 Sep 2006 08:04:06 GMT

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

Re: Data Guard Issue

mghosalk — Fri, 29 Sep 2006 20:59:36 GMT

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

Re: Data Guard Issue

Yogeeraj_1 — Wed, 04 Oct 2006 02:37:44 GMT

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

Re: Data Guard Issue

Angus John-Phillips — Thu, 05 Oct 2006 03:51:11 GMT

Thanks Mandar,
That worked.

Re: Data Guard Issue

Angus John-Phillips — Thu, 05 Oct 2006 11:07:43 GMT

Thanks