RE: Restore question

Yes it is.  It's called a point in time recovery, unless you simply want
to roll forward to now.  If the database was always in archivelog mode
it's definitely possible, even using the current control file.  Simply
start the database with "startup mount" from rman then issue a "restore
database" followed by a "recover database" or "recover database until
<date/time>".
 

Dick Goulet 
Senior Oracle DBA 
PAREXEL International 
978.313.3426 
 information transmitted in this communication is intended only for the
person or entity to which it is addressed and may contain confidential
and/or privileged material. Any review, retransmission, dissemination or
other use of, or taking of any action in reliance upon, this information
by persons or entities other than the intended recipient is prohibited.
If you received this in error, please destroy any copies, contact the
sender and delete the material from any computer.


 

________________________________

From: oracle-l-bounce@xxxxxxxxxxxxx
[mailto:oracle-l-bounce@xxxxxxxxxxxxx] On Behalf Of J. Dex
Sent: Wednesday, December 31, 2008 2:51 PM
To: oracle-l@xxxxxxxxxxxxx
Subject: Restore question


Is it possible to restore from a hot backup that was taken prior to a
database being shutdown.  We had an RMAN hot backup running in
archivelog mode.  The database was shutdown and them some files are lost
before it was restarted  Isn't it possible to just point to the oldest
controlfile that was taken during the last hot backup and restore from
that?  
 


________________________________

Send e-mail anywhere. No map, no compass. Get your Hotmail(r) account
now.
<http://windowslive.com/oneline/hotmail?ocid=TXT_TAGLM_WL_hotmail_acq_an
ywhere_122008>

Other related posts: