What is the best way will I choose for DG solution? [message #557198] |
Sun, 10 June 2012 22:48 |
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!
|
|
|
|
|
|
|