- Community Home
- >
- Servers and Operating Systems
- >
- Operating Systems
- >
- Operating System - HP-UX
- >
- Data Guard Issue
Categories
Company
Local Language
Forums
Discussions
Forums
- Data Protection and Retention
- Entry Storage Systems
- Legacy
- Midrange and Enterprise Storage
- Storage Networking
- HPE Nimble Storage
Discussions
Discussions
Discussions
Forums
Forums
Discussions
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
- BladeSystem Infrastructure and Application Solutions
- Appliance Servers
- Alpha Servers
- BackOffice Products
- Internet Products
- HPE 9000 and HPE e3000 Servers
- Networking
- Netservers
- Secure OS Software for Linux
- Server Management (Insight Manager 7)
- Windows Server 2003
- Operating System - Tru64 Unix
- ProLiant Deployment and Provisioning
- Linux-Based Community / Regional
- Microsoft System Center Integration
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Community
Resources
Forums
Blogs
- Subscribe to RSS Feed
- Mark Topic as New
- Mark Topic as Read
- Float this Topic for Current User
- Bookmark
- Subscribe
- Printer Friendly Page
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО09-28-2006 11:02 PM
тАО09-28-2006 11:02 PM
I have a problem with Data Guard. My archive log files are not applied to my physical Standby db.
Thanks,
Angus
Solved! Go to Solution.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО09-28-2006 11:27 PM
тАО09-28-2006 11:27 PM
SolutionAt 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
Owner of ISN Corporation
http://isnamerica.com
http://hpuxconsulting.com
Sponsor: http://hpux.ws
Twitter: http://twitter.com/hpuxlinux
Founder http://newdatacloud.com
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО09-28-2006 11:59 PM
тАО09-28-2006 11:59 PM
Re: Data Guard Issue
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
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО09-29-2006 01:00 AM
тАО09-29-2006 01:00 AM
Re: Data Guard Issue
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
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО09-29-2006 01:04 AM
тАО09-29-2006 01:04 AM
Re: Data Guard Issue
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
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО09-29-2006 01:59 PM
тАО09-29-2006 01:59 PM
Re: Data Guard Issue
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
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО10-03-2006 07:37 PM
тАО10-03-2006 07:37 PM
Re: Data Guard Issue
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
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО10-04-2006 08:51 PM
тАО10-04-2006 08:51 PM
Re: Data Guard Issue
That worked.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО10-05-2006 04:07 AM
тАО10-05-2006 04:07 AM