Home » RDBMS Server » Backup & Recovery » Problem in manual DB Recovery. (Oracle 11g R2)
Problem in manual DB Recovery. [message #564720] Tue, 28 August 2012 01:41 Go to next message
chintan.patel
Messages: 162
Registered: July 2008
Location: Ahmedabad
Senior Member
Hi Friends

I am doing different recovery scenarios on my testing server and i have one problem which is described below.I have two archive destinations one is mandatory and another is optional. at the time of recovery process it finds one archive file is corrupted and the recovery process is canceled even recovery option is auto. as i understand if archival file of the one location is corrupted, then its automatically use the second set of archive file from different location. if my understanding is proper, then in which case the above recovery behavior possible.can any body help me to understand it.

Regards
Chintan
Re: Problem in manual DB Recovery. [message #564721 is a reply to message #564720] Tue, 28 August 2012 01:56 Go to previous messageGo to next message
John Watson
Messages: 8922
Registered: January 2010
Location: Global Village
Senior Member
Failover between multiplexed archivelogs is automatic if you use RMAN, not if you use SQL*Plus.
Re: Problem in manual DB Recovery. [message #564723 is a reply to message #564721] Tue, 28 August 2012 02:16 Go to previous messageGo to next message
chintan.patel
Messages: 162
Registered: July 2008
Location: Ahmedabad
Senior Member
Dear John

Before two days back, i had done the same scenario and its automatically use the second set of archive file and recovery had completed successfully.
Now the same scenario repeats and its not repeat the same behavior so i am confused. yes i m doing the recovery commands using SQL*Plus.
Do you know how can it possible, if yes then i am interest to understand it.

Thanks
Chintan
Re: Problem in manual DB Recovery. [message #564724 is a reply to message #564723] Tue, 28 August 2012 02:24 Go to previous messageGo to next message
John Watson
Messages: 8922
Registered: January 2010
Location: Global Village
Senior Member
Quote:
i had done the same scenario and its automatically use the second set of archive file and recovery had completed successfully.
Not possible. Look in the alert log for that period, and you'll see what happened.
Re: Problem in manual DB Recovery. [message #564726 is a reply to message #564724] Tue, 28 August 2012 02:58 Go to previous messageGo to next message
chintan.patel
Messages: 162
Registered: July 2008
Location: Ahmedabad
Senior Member
Dear John

I am looking into the alert log file. I am sorry to say for "recovery successfully completed". It was not completed because of both the archived files corrupted. but it tired for both of the files. i am paste some lines of my alert log for more clarity.
ALTER DATABASE RECOVER    CONTINUE DEFAULT  
Media Recovery Log /multiplex/archivedata/ARCH_1_4926_749779379.arc
Sun Aug 26 11:44:33 2012
Errors in file /test/odb/diag/rdbms/trace/test_pr00_4253.trc  (incident=109363):
ORA-00353: log corruption near block 74880 change 993710234 time 07/11/2012 13:36:05
ORA-00334: archived log: '/multiplex/archivedata/ARCH_1_4926_749779379.arc'
Incident details in: /test/odb/diag/rdbms/incident/incdir_109363/test_pr00_4253_i109363.trc
Errors with log /multiplex/archivedata/ARCH_1_4926_749779379.arc
Sun Aug 26 11:44:35 2012
Trace dumping is performing id=[cdmp_20120715114435]
Sun Aug 26 11:44:35 2012
Sweep [inc][109363]: completed
Sun Aug 26 11:44:35 2012
Sweep [inc2][109363]: completed
Errors in file /test/odb/diag/rdbms/trace/test_m000_4300.trc  (incident=109435):
ORA-00353: log corruption near block 74880 change 993710234 time 07/11/2012 13:36:05
ORA-00334: archived log: '/test/odb/flash_recovery_area/archivedata/ARCH_1_4926_749779379.arc'
Incident details in: /test/odb/diag/rdbms/incident/incdir_109435/test_m000_4300_i109435.trc
Trace dumping is performing id=[cdmp_20120715114439]
Media Recovery failed with error 354
Errors in file /test/odb/diag/rdbms/trace/test_pr00_4253.trc:
ORA-00283: recovery session canceled due to errors
ORA-00354: corrupt redo log block header
ORA-00353: log corruption near block 74880 change 993710234 time 07/11/2012 13:36:05
ORA-00334: archived log: '/multiplex/archivedata/ARCH_1_4926_749779379.arc'
ORA-283 signalled during: ALTER DATABASE RECOVER    CONTINUE DEFAULT  ...
ALTER DATABASE RECOVER CANCEL 
ORA-1112 signalled during: ALTER DATABASE RECOVER CANCEL ...
Sun Aug 26 11:44:41 2012


As above log what u conclude, please let me know.

Thanks
Chintan
Re: Problem in manual DB Recovery. [message #564841 is a reply to message #564726] Wed, 29 August 2012 00:41 Go to previous messageGo to next message
chintan.patel
Messages: 162
Registered: July 2008
Location: Ahmedabad
Senior Member
Hi Friends

No one can guide me regarding these problem.

Regards
Chintan
Re: Problem in manual DB Recovery. [message #564855 is a reply to message #564841] Wed, 29 August 2012 01:39 Go to previous messageGo to next message
John Watson
Messages: 8922
Registered: January 2010
Location: Global Village
Senior Member
No guidance, because you have not been telling the truth. In your second post, you claimed to have done recovery successfully. But the alert log shows that you didn't. It is hard to advise someone who obfuscates reality.
You had better start again, with a fresh set of tests.
Re: Problem in manual DB Recovery. [message #564872 is a reply to message #564855] Wed, 29 August 2012 04:19 Go to previous message
chintan.patel
Messages: 162
Registered: July 2008
Location: Ahmedabad
Senior Member
Dear John

I apologized for that post. I was paste the alert log for more clarity. I was done recovery for so many times and that is the only reason of some misunderstanding. my aim is not to hide truth. i know that misleading information harm to me only.

Thanks
Chintan
Previous Topic: Move DB to a new server
Next Topic: New to RMAN, looking for tutorials
Goto Forum:
  


Current Time: Fri Mar 29 05:12:01 CDT 2024