iSelfSchooling.com  Since 1999     References  |  Search more  | Oracle Syntax  | Free Online Oracle Problem Solver

    .Home      .Subscribe     .Login      .Start Learning      .Certification      .Cancel      .Password Reminder      .Password Change     .Sign out

 

. Online Accounting        .Copyright & User Agreement   |
    .Vision      .Biography     .Acknowledgement

.Contact Us      .Comments/Suggestions       .Email2aFriend    |

 

Oracle 11g New Features

Online Oracle Training

 

Checklist to create a Dataguard database ...



ON PRIMARY: 
Create pfile from spfile on the primary database: 
SQL> Create pfile from spfile;
Then make/add following settings in the initPrimary.ora file on the PRIMARY Machine. 
db_unique_name='schoolp'
FAL_Client='to_schoolp'
FAL_Server='to_schools1'
Log_archive_config='DG_CONFIG=(primary,standby)'
Log_archive_dest_1='Location=/recovery
VALID_FOR=(ALL_LOGFILES,ALL_ROLES)
db_unique_name=schoolp'
Log_archive_dest_2='Service=to_standby lgwr async
VALID_FOR=(ONLINE_LOGFILES,PRIMARY_ROLE)
db_unique_name=schools1'
Log_archive_dest_state_1=ENABLE
Log_archive_dest_state_2=ENABLE
Service_names='schoolp'
Standby_File_Management='AUTO'

dg_broker_start=TRUE

Create password file, force logging, and archivelog.
C:\> orapwd file=orapwSchoolp.ora password=xx entries=5 force=y
Make sure database is in archivelog and logging except temp file online redo log is enabled.
SQL> startup mount;
SQL> Alter database ArchiveLog;
SQL> Alter database Force Logging;

SQL> alter database open;
SQL> Alter database add standby logfile ('.../xx') size 50m;

LISTENER and TNSNAMES
Add standby entries to TNSNAMES.ORA or use netmgr to add and register the database.

Copy all the tnsnames.ora file to standby server and change it.
ON PHYSICAL STANDBY: 
PFILE needs to be changed:
db_unique_name='schools1'
FAL_Client='to_schools1'
FAL_Server='to_schoolp'
Log_archive_config='DG_CONFIG=(primary,standby)'
Log_archive_dest_1='Location=/recovery VALID_FOR=(ALL_LOGFILES,ALL_ROLES) db_unique_name=schools1'
Log_archive_dest_2='Service=to_schoolp VALID_FOR=(ONLINE_LOGFILES,PRIMARY_ROLE) db_unique_name=primary'
Log_archive_dest_state_1=ENABLE
Log_archive_dest_state_2=ENABLE
Service_names='schools1'
Standby_File_Management='AUTO'

dg_broker_start=TRUE


On the standby follow the following link to create a standby database.

iSelfSchooling - How to create a standby database

 

 

Good Luck!

 

Google
 
Web web site