Home » Server Options » Data Guard » What is the best way will I choose for DG solution? (Linux x86_64, Oracle 10.2.0.5)
What is the best way will I choose for DG solution? [message #557198] Sun, 10 June 2012 22:48 Go to next message
trantuananh24hg
Messages: 744
Registered: January 2007
Location: Ha Noi, Viet Nam
Senior Member
Hi every one!

I've got one case in my system. I do a brief:

Info: Primary, Standby: Linux x86_64, Oracle 10g, ASM

Problem describe: The DG lost much archivelog from Primary, 32 days. The reason was mistake from another one sysadmin who earsed all of archivelog in primary when he detect full-disk. So, the DG told me:
Mon Jun 11 10:45:12 ICT 2012
Completed: ALTER DATABASE RECOVER MANAGED STANDBY DATABASE disconnect from session
Mon Jun 11 10:45:41 ICT 2012
FAL[client]: Failed to request gap sequence
 GAP - thread 1 sequence 2091-2190
 DBID 306304140 branch 736614991
FAL[client]: All defined FAL servers have been attempted.
-------------------------------------------------------------
Check that the CONTROL_FILE_RECORD_KEEP_TIME initialization
parameter is defined to a value that is sufficiently large
enough to maintain adequate log switch information to resolve
archivelog gaps.
-------------------------------------------------------------
Mon Jun 11 10:47:03 ICT 2012
Redo Shipping Client Connected as PUBLIC
-- Connected User is Valid
RFS[1]: Assigned to RFS process 28267
RFS[1]: Identified database type as 'physical standby'
Mon Jun 11 10:47:03 ICT 2012
RFS LogMiner: Client disabled from further notification


I re-check the most daily created in both of DB, I see there are
! ls -lrt /cloudarc
total 22502160
drwx------ 2 oracle dba          16384 Dec  1  2010 lost+found
-rw-r----- 1 oracle oinstall 192987648 May 11 18:49 cloudgpo_1_3369_736614991.arc


This is the oldest archivelog in both of DB. And the last is today, 11/06/2012.

So, may you give me a best resolution?
1- Try to repair the problem (I've not got a really solution for it)
2- Re-create physical standby?

And, if I described not enough, please ask me for more information.

Thank you!
Re: What is the best way will I choose for DG solution? [message #557199 is a reply to message #557198] Sun, 10 June 2012 22:58 Go to previous messageGo to next message
babuknb
Messages: 1736
Registered: December 2005
Location: NJ
Senior Member

Go by #2 [ Rebuild the DR by using latest production copy ]

- Babu
Re: What is the best way will I choose for DG solution? [message #557200 is a reply to message #557199] Sun, 10 June 2012 23:03 Go to previous messageGo to next message
BlackSwan
Messages: 26766
Registered: January 2009
Location: SoCal
Senior Member
babuknb wrote on Sun, 10 June 2012 20:58
Go by #2 [ Rebuild the DR by using latest production copy ]


+1
Re: What is the best way will I choose for DG solution? [message #557201 is a reply to message #557200] Sun, 10 June 2012 23:12 Go to previous messageGo to next message
trantuananh24hg
Messages: 744
Registered: January 2007
Location: Ha Noi, Viet Nam
Senior Member
Thank for advice!
Re: What is the best way will I choose for DG solution? [message #557209 is a reply to message #557198] Mon, 11 June 2012 00:49 Go to previous message
John Watson
Messages: 8922
Registered: January 2010
Location: Global Village
Senior Member
Repair your standby, that should be much faster than re-creating. Right now, you are unprotected: this must be fixed immediately. Like, NOW.
Previous Topic: ORA-16146
Next Topic: Testing Data Guard
Goto Forum:
  


Current Time: Thu Mar 28 05:36:19 CDT 2024