Re: Recovery with three days old backup

From: Seth Miller <sethmiller.sm_at_gmail.com>
Date: Sun, 21 Dec 2014 13:13:05 -0600
Message-ID: <CAEueRAX7n1P-a1gD3fshAOE9PXZ82tMbpNLhnaS35mWZ+WM=+w_at_mail.gmail.com>

Become really good at that and you will be both the most loved and hated person in your group.

Seth Miller

On Sunday, December 21, 2014, Tim Gorman <tim_at_evdbt.com> wrote:

> Restoring everything to a new server works even better. :-)
>
> You have now undergone "trial by fire" and recovered a dead database.
> Congratulations!
>
>
>
> On 12/21/14 4:23, Sreejith Nair wrote:
>
> 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
> <javascript:_e(%7B%7D,'cvml','tim_at_evdbt.com');>> wrote:
>
> Sreejith,
>
> First, open an SR with Oracle Support <http://support.oracle.com>, 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
> <http://docs.oracle.com/cd/B19306_01/backup.102/b14192/recov002.htm#sthref532>
> .
>
> 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-l

Received on Sun Dec 21 2014 - 20:13:05 CET