Re: Recovery with three days old backup
From: Sreejith Nair <sreejithsna_at_gmail.com>
Date: Sun, 21 Dec 2014 16:53:03 +0530
Message-Id: <B7A4FA83-C070-46EF-AF26-6ED54BC42A4C_at_gmail.com>
Thank you Tim.
>> On 12/19/14 23:44, Sreejith Nair wrote:
>> Dear List
>>
>> Here is the scenario.
>>
>> I have a 10.2.0.5 database single instance in Oracle Solaris 10 ( no ASM ).
>>
>> We stored data files in mount points and three days back one of the mount point crashed.
>>
>> We have three days old INCREMENTAL LEVEL 0 backup and ARCHIVELOG backups available. But CONTROL FILE AUTOBACKUP was not set to ON and we ended up having a backup with no control file auto backups.
>>
>> We have restored the backup from tape. The database at present can be mounted as the mount point where controlfile is residing is still available.
>>
>> Is it possible to recover the database if I take a control file backup now after changing AUTOBACKUP to ON. Can we use the controlfile backup from today ( after the data files are lost ) to recover the database from three days old data file and ARCHIVELOG backups.
>>
>> Kindly suggest if I have any other recovery strategy available.
>>
>> Regards
>> Sreejith
>>
>> Sent from my iPhone --
>> http://www.freelists.org/webpage/oracle-l
>>
>>
>>
>>
>
Date: Sun, 21 Dec 2014 16:53:03 +0530
Message-Id: <B7A4FA83-C070-46EF-AF26-6ED54BC42A4C_at_gmail.com>
Thank you Tim.
With the assistance from oracle support I have recovered the database.
I have performed following steps.
Copied controlfile to new server
Mounted the database
Restored and recovered the database using set until log sequence number
Opened database in reset logs.
Regards
Sreejith
Sent from my iPhone
> On 21-Dec-2014, at 12:13 am, Tim Gorman <tim_at_evdbt.com> wrote: > > Sreejith, > > First, open an SR with Oracle Support, if you haven't already. > > You don't need to autobackup that remaining controlfile using RMAN; what you have sounds like a current copy of the controlfile and you can recover using that. > > First of all, protect that remaining controlfile as if it were made of virtual gold. Copy it to another directory, copy it to your desktop, copy it to a USB drive. > > Next, once it has been copied, ensure that your PFILE or SPFILE references that single remaining current controlfile (i.e. CONTROL_FILES parameter), and start the instance with MOUNT (to mount that controlfile). Then, within RMAN, use RESTORE DATAFILE to restore the files that are missing, followed by RECOVER DATABASE. Reference your Oracle Support analyst in your SR, and reference the online documentation, such as this online here. > > Good luck! > > -Tim > >
>> On 12/19/14 23:44, Sreejith Nair wrote:
>> Dear List
>>
>> Here is the scenario.
>>
>> I have a 10.2.0.5 database single instance in Oracle Solaris 10 ( no ASM ).
>>
>> We stored data files in mount points and three days back one of the mount point crashed.
>>
>> We have three days old INCREMENTAL LEVEL 0 backup and ARCHIVELOG backups available. But CONTROL FILE AUTOBACKUP was not set to ON and we ended up having a backup with no control file auto backups.
>>
>> We have restored the backup from tape. The database at present can be mounted as the mount point where controlfile is residing is still available.
>>
>> Is it possible to recover the database if I take a control file backup now after changing AUTOBACKUP to ON. Can we use the controlfile backup from today ( after the data files are lost ) to recover the database from three days old data file and ARCHIVELOG backups.
>>
>> Kindly suggest if I have any other recovery strategy available.
>>
>> Regards
>> Sreejith
>>
>> Sent from my iPhone --
>> http://www.freelists.org/webpage/oracle-l
>>
>>
>>
>>
>
-- http://www.freelists.org/webpage/oracle-lReceived on Sun Dec 21 2014 - 12:23:03 CET