Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Re: database recover

Re: database recover

From: Ted McCabe <theom_at_gte.net>
Date: 1998/04/04
Message-ID: <6g5eed$e35$1@gte1.gte.net>#1/1

The 'Oracle Backup & Recovery Handbook' by Rama Velpuri explains in good detail what you are asking.
tEd
leil_at_wellsfargo.com wrote in message <6g3r8e$vht$1_at_nnrp1.dejanews.com>...
>Hi,
> I have a question on the backup and recovery. I don't understand one of
 the
>recovery strategies which is 'recover database using backup control file'.
>From the book, it tells that this is because there is a physical structure
>change of the database later. Does someone know the answers on the
 following
>questions:
> If I use strategy of using backup control file to recover database
>(1) Do I still need to restore the old datafiles from backup instead of
>current datafiles? Must the restored datafiles be older than the backup
>controlfile?
>(2) If I use the current datafiles, restore the backup control files from
>backup, and have all archived redo logs available. Is it possible for
 Oracle
>to roll back to the point which the backup control file is.
>
>I need answers for these questions very much. I am constructing a backup
 and
>recovery plan now.
>
>Thanks in advance!
>Ling Lei
>
>-----== Posted via Deja News, The Leader in Internet Discussion ==-----
>http://www.dejanews.com/ Now offering spam-free web-based newsreading
Received on Sat Apr 04 1998 - 00:00:00 CST

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US