Re: Rman archive restore problem from prod to test
- From: Jared Still <jkstill@xxxxxxxxx>
- To: nileshkum@xxxxxxxxx
- Date: Tue, 10 Nov 2009 08:38:03 -0800
On Tue, Nov 10, 2009 at 6:23 AM, nilesh kumar <nileshkum@xxxxxxxxx> wrote:
>
> RMAN-03002: failure of restore command at 11/10/2009 07:44:28
>
> ORA-27192: skgfcls: sbtclose2 returned error - failed to close file
>
> ORA-19511: Error received from media manager layer, error text:
>
> Failed to process backup file <ORA_al_3skrvmle_1_1_700439214>
>
>
> We thought the restored archives were good enough for the recovery and
> recoverd till the archive log which threw this error and performed a cancel
> based recovery and reset the logs but while opening the database again we
> got into another issue ie logs have reseted and instance got terminated.
>
I am curious as to why you thought it was OK to proceed when the
archive log restore failed?
It would have been a good idea to retry restoring the archive logs
rather than proceeding with the recovery. But then, hindsight is
often 20/20.
You should examine the logs of your backup software to find why
the restore failed. One hopes that you have more than one backup
of your archive logs.
My advice would be to run the restore again. If it fails, find out why
it failed. The consequences of this problem are more far reaching
than just restoring a database to test.
Jared Still
Certifiable Oracle DBA and Part Time Perl Evangelist
Oracle Blog: http://jkstill.blogspot.com
Home Page: http://jaredstill.com
Other related posts:
