Data Guard Configuration for Oracle 11g

Monday, May 25, 2009



Click here for Read

at 8:08 PM
Labels: ,

6 comments:

Anonymous,  September 17, 2009 at 11:22 AM  

Hi Shaheer Badar,

Thank you very much for the instruction, it really helps a lot. I tried to configure my physical standby database following your instruction, everything goes fine except the following, could you please help to advice?

After we setup both primary and standby database, the archive logs are not applied:

On primary database:

SQL> Select Database_role from v$Database;

DATABASE_ROLE
----------------
PRIMARY

SQL> SELECT SEQUENCE#,FIRST_TIME, NEXT_TIME, APPLIED FROM V$ARCHIVED_LOG ORDER BY SEQUENCE#;

SEQUENCE# FIRST_TIME NEXT_TIME APPLIED
---------- -------------------- -------------------- ---------
2 2009-SEP-14 10:41:28 2009-SEP-14 11:40:37 NO
2 2009-SEP-14 10:41:28 2009-SEP-14 11:40:37 NO
3 2009-SEP-14 11:40:37 2009-SEP-14 11:41:56 NO
3 2009-SEP-14 11:40:37 2009-SEP-14 11:41:56 NO
4 2009-SEP-14 11:41:56 2009-SEP-14 12:32:52 NO
4 2009-SEP-14 11:41:56 2009-SEP-14 12:32:52 NO
5 2009-SEP-14 12:32:52 2009-SEP-14 18:49:41 NO
5 2009-SEP-14 12:32:52 2009-SEP-14 18:49:41 NO
6 2009-SEP-14 18:49:41 2009-SEP-15 19:05:42 NO
6 2009-SEP-14 18:49:41 2009-SEP-15 19:05:42 NO
7 2009-SEP-15 19:05:42 2009-SEP-16 02:01:41 NO
8 2009-SEP-16 02:01:41 2009-SEP-17 02:00:31 NO
On physical standby:

SQL> Select Database_role from v$Database;

DATABASE_ROLE
----------------
PHYSICAL STANDBY


SQL> SELECT SEQUENCE#,FIRST_TIME,NEXT_TIME,APPLIED FROM V$ARCHIVED_LOG ORDER BY SEQUENCE#;

SEQUENCE# FIRST_TIME NEXT_TIME APPLIED
---------- -------------------- -------------------- ---------
2 2009-SEP-14 10:41:28 2009-SEP-14 11:40:37 NO
3 2009-SEP-14 11:40:37 2009-SEP-14 11:41:56 NO
4 2009-SEP-14 11:41:56 2009-SEP-14 12:32:52 NO
5 2009-SEP-14 12:32:52 2009-SEP-14 06:49:41 NO
6 2009-SEP-14 06:49:41 2009-SEP-15 07:05:42 NO


Thanks!

Shaheer Badar,  September 24, 2009 at 9:06 PM  

Please check the connectivity between your Primary and Secondary Database. You should log on into Secondary Database from Primary Database and Vise versa. Your OSs and Databases must communicate between each other without password.

Anonymous,  November 13, 2009 at 7:46 PM  

Do we need to install a Database instance through dbca on both machines?

Thanks

Shaheer Badar,  November 14, 2009 at 7:41 AM  

You can create Database through dbca on both Primary and Secondary machines. But you should move or remove database from Secondary machine and copy database from Primary to Secondary machine.

Unknown,  June 3, 2010 at 11:34 AM  

Hello dear,, can u send me Oracle 11g Dataguard administration Ppts...

Thanks,
Subodh Bhale.

Anonymous,  September 7, 2010 at 4:35 PM  

Hi Shahid,

do you have any document a 11gR2 2 node physical standby database from 11gR2 2 node primary RAC. If yes, can you please share it. It will be a great help to your followers.

Regards
Arif

Post a Comment

Post a Comment

Subscribe to: Post Comments (Atom)
Related Posts with Thumbnails

Sponser Links

Followers

Sponser Links

  ©2009-10 | Disclaimer

Back to TOP