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!
|