Its been a strange experience for me.This is the first time i set up dataguard configuration on Oracle 10G. Its so straighforward but its too annoying.
I was stuck with this error almost 100 times and i realy dont know why
ORA-16072: a minimum of one standby database destination is required
This is what i did.
1.Forced the Primary to forced logging mode
2.Create pfile2 from spfile
3.Create stdby controlfile
Copied the data,Redolog files, Renamed the controlfile as per init,ora file
Primary:
Added Log_archive_dest_2='Service=STDBY LGWR Sync affirm'
Support Singapore
Subscribe to:
Post Comments (Atom)
1 comment:
For an easy to use graphical alternative to Data Guard,
try the Standby Wizard for Oracle. The Standby Wizard automates
standby database creation, maintenance, and switchover functions needed for
any Oracle disaster-recovery or continuity planning senerio.
Free downloads are available at:
www.relationalwizards.com
The Standby Wizard has been serving Oracle customers since 2001.
Post a Comment