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'
Wednesday, February 18, 2009
Subscribe to:
Posts (Atom)