Gajendra mourya

• Jun 27th, 2015

 

Hello friends,

Data guard is very important concept for disaster recovery, in data guard we have one primary database or one or more up to nine standby database for our database safety, now first we have to start from basic of database it means start from check your db is in archive mode or not, add parameter in pFile, which is create by spFile & its location is in /u01/app/oracle/admin/primary(database name)/pfile/initprimary.ora, and then we add its data guard paramters in our pfile, open by vi editor, then add

db_unique_name=primary db name
log_archive_config=dg_config(primary database name, standby db name)
fal_client=standby db
fal_server=primary db
log_archive_dest_1=location=/u01/app/oracle/oradata/primary/arch valid_for=(all_logfiles,all_roles) db_unique_name=primary
log_archive_dest_2=service= standby asyn valid_for=(online_logfiles,primary_roles) db_unique_name=standby
log_archive_dest_state_1=enable
log_archive_dest_state_2=enable

log_file_name_convert=/u01/app/....../standby/arch,/u01/app/..../primary/arch
db_file_name_convert=/u01/app/....../standby/arch,/u01/app/..../primary/arch
standby_file_management=auto

Main parameters are added into pfile, now you have to force logging your database.

You have to added some standby log group one more than primary side and then check your listener and tnsnames setting for both database, create one orapwd file in primary & send it by SCP to standby side and that pFile also, now you have to send your all data file & redolog file& control file by SCP command.

Now on stand by database you have to change some parameter and then start your database as export ORACLE_SID=standby sqlplus / as sysdba, then you have all the info then startup nomount from pFile set your location of pFile, then you create spFile from pFile, then automatically your all info startup mount control file read then your all archive are done.