it happened, lost database and recovery catalog. starting distasterrecovery research

#21

neil kodner wrote:

Quote:

On May 14, 8:57 am, Ben <balve... (AT) gmail (DOT) com> wrote:
10.2.0.2 EE, aix5L

had a storm this weekend and power went out to the disk cabinet on our
development machine. I was just informed by our sys admin that we
might be having to recover from disk to get everything back.

Luckily it is just our development machine but we do have critical
data in that database. The recovery catalog was located on the same
machine and filesystem. Now I'm setting forth with the research on how
to get it back. I have documentation of control file backups, the
dbid, and the last hot backup of the database. I don't have a backup
for the recovery catalog that we were using. Correct me if I'm wrong,
but I guess I'll be recovering the control file(s) then recovering the
database from those instead of the catalog. I've practiced recovery in
the past but never without the recovery catalog.

Wish me luck. Any pointers?

Have you tried running an RMAN restore without first connecting to any
catalog? The backup information is also stored in the control files.
We've performed restores while bypassing the recovery catalog.

Which makes sense, as the catalog is no more than
a copy of your control file.

Both of which should be backed up!!!

FvB

#22

Ben wrote:

Quote:

Just curious as to why I would
be better off using a non-recovered control file?

Because it has the latest changes written to it, which
your backed up control file does not. E.g. it knows
it still misses those 13 archived redo log files, due
to log switches *after* the former backup.

FvB

#23

Ben wrote:

Quote:

Just curious as to why I would
be better off using a non-recovered control file?

Because it has the latest changes written to it, which
your backed up control file does not. E.g. it knows
it still misses those 13 archived redo log files, due
to log switches *after* the former backup.

FvB

#24

Ben wrote:

Quote:

Just curious as to why I would
be better off using a non-recovered control file?

Because it has the latest changes written to it, which
your backed up control file does not. E.g. it knows
it still misses those 13 archived redo log files, due
to log switches *after* the former backup.

FvB

#25

Ben wrote:

Quote:

Just curious as to why I would
be better off using a non-recovered control file?

Because it has the latest changes written to it, which
your backed up control file does not. E.g. it knows
it still misses those 13 archived redo log files, due
to log switches *after* the former backup.

FvB

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

it happened, lost database and recovery catalog. starting distasterrecovery research

comp.databases.oracle.misc comp.databases.oracle.misc

Re: it happened, lost database and recovery catalog. starting distasterrecovery research - 05-16-2008 , 03:28 AM

Re: it happened, lost database and recovery catalog. starting distasterrecovery research - 05-16-2008 , 03:31 AM

Re: it happened, lost database and recovery catalog. starting distasterrecovery research - 05-16-2008 , 03:31 AM

Re: it happened, lost database and recovery catalog. starting distasterrecovery research - 05-16-2008 , 03:31 AM

Re: it happened, lost database and recovery catalog. starting distasterrecovery research - 05-16-2008 , 03:31 AM