- Community Home
- >
- Servers and Operating Systems
- >
- Operating Systems
- >
- Operating System - HP-UX
- >
- Data Guard
Operating System - HP-UX
1753440
Members
4692
Online
108794
Solutions
Forums
Categories
Company
Local Language
юдл
back
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
юдл
back
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
Blogs
Information
Community
Resources
Community Language
Language
Forums
Blogs
Go to solution
Topic Options
- 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
тАО10-05-2006 04:15 AM
тАО10-05-2006 04:15 AM
Hi,
I have an issue still thaat the Standby Database Does Not Receive Redo Data from the Primary Database.
I have issued the following :
STARTUP NOMOUNT;
ALTER DATABASE MOUNT STANDBY DATABASE;
RECOVER MANAGED STANDBY DATABASE;
But the archive sequence appears to be out. Once I look at the O/P from "select process, status from v$managed_standby;" from the standby.
The alert log just says that the archive number is still trying.
Any ideas how to get around this issue.
SQL> SELECT DEST_ID "ID",
2> STATUS "DB_status",
3> DESTINATION "Archive_dest",
4> ERROR "Error"
5> FROM V$ARCHIVE_DEST WHERE DEST_ID <=5;
ID DB_status Archive_dest Error
-- --------- ------------------------------ ------------------------------------
1 VALID /u01/app/oracle/UATS/arc_dest/arc
2 ERROR standby1 ORA-16012: Archivelog standby database identifier mismatch
3 INACTIVE
4 INACTIVE
5 INACTIVE
5 rows selected.
Regards,
Angus
I have an issue still thaat the Standby Database Does Not Receive Redo Data from the Primary Database.
I have issued the following :
STARTUP NOMOUNT;
ALTER DATABASE MOUNT STANDBY DATABASE;
RECOVER MANAGED STANDBY DATABASE;
But the archive sequence appears to be out. Once I look at the O/P from "select process, status from v$managed_standby;" from the standby.
The alert log just says that the archive number is still trying.
Any ideas how to get around this issue.
SQL> SELECT DEST_ID "ID",
2> STATUS "DB_status",
3> DESTINATION "Archive_dest",
4> ERROR "Error"
5> FROM V$ARCHIVE_DEST WHERE DEST_ID <=5;
ID DB_status Archive_dest Error
-- --------- ------------------------------ ------------------------------------
1 VALID /u01/app/oracle/UATS/arc_dest/arc
2 ERROR standby1 ORA-16012: Archivelog standby database identifier mismatch
3 INACTIVE
4 INACTIVE
5 INACTIVE
5 rows selected.
Regards,
Angus
Solved! Go to Solution.
3 REPLIES 3
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО10-05-2006 07:40 AM
тАО10-05-2006 07:40 AM
Re: Data Guard
If any of the following conditions exist, the primary database will fail to archive to the standby site:
* The service name for the standby instance is not configured correctly in the tnsnames.ora file at the primary site.
* The service name listed in the LOG_ARCHIVE_DEST_n parameter of the primary initialization parameter file is incorrect.
* The LOG_ARCHIVE_DEST_STATE_n parameter specifying the state of the standby archiving destination has the value DEFER.
* The listener.ora file has not been configured correctly at the standby site.
* The listener is not started.
* The standby instance is not started.
* You have added a standby archiving destination to the primary initialization parameter file, but have not yet enabled the change.
* You used an invalid backup as the basis for the standby database
* The service name for the standby instance is not configured correctly in the tnsnames.ora file at the primary site.
* The service name listed in the LOG_ARCHIVE_DEST_n parameter of the primary initialization parameter file is incorrect.
* The LOG_ARCHIVE_DEST_STATE_n parameter specifying the state of the standby archiving destination has the value DEFER.
* The listener.ora file has not been configured correctly at the standby site.
* The listener is not started.
* The standby instance is not started.
* You have added a standby archiving destination to the primary initialization parameter file, but have not yet enabled the change.
* You used an invalid backup as the basis for the standby database
Live life everyday
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО10-05-2006 03:53 PM
тАО10-05-2006 03:53 PM
Solution
hi Angus,
Verify at the Primary database level if the archived log are being properly shipped.
You may check in the alert.log
hope this helps!
kind regards
yogeeraj
Verify at the Primary database level if the archived log are being properly shipped.
You may check in the alert.log
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)
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО10-05-2006 09:31 PM
тАО10-05-2006 09:31 PM
Re: Data Guard
Thanks for the help the listener.ora file had been changed.
Thanks,
Angus
Thanks,
Angus
The opinions expressed above are the personal opinions of the authors, not of Hewlett Packard Enterprise. By using this site, you accept the Terms of Use and Rules of Participation.
News and Events
Support
© Copyright 2024 Hewlett Packard Enterprise Development LP