Re: Simple archive question

From: Anthony Hogan <ahoganXX_at_inerza.com>
Date: Thu, 10 Mar 2005 16:42:10 -0000
Message-ID: <d0ptd4$o7r$1@nsnmpen2-gest.nuria.telefonica-data.net>

"Arun Mathur" <themathurs_at_gmail.com> escribió en el mensaje news:1110472492.329321.301470_at_z14g2000cwz.googlegroups.com...
> Hello,
>
> " After stopping the db server by using shutdown immediate , i copy all
> the data file ,redo log files , control files etc to my backup
> location" --> you're performing a cold backup
>
>
> "Then at this point , i want to
> return to my previous backup and recover the dbserver up to the latest
> point in order to see which operations are really logged and recovered
> : "
>
> Your previous backup is a cold backup, which means you cannot recover
> to a point in time. You'll need to do hot backups, or better yet,
> review the Backup and Recovery Concepts Guide,
>

http://otn.oracle.com/pls/db92/db92.drilldown?levelnum=2&toplevel=a96519&method=FULL&chapters=0&book=&wildcards=1&preference=&expand_all=&verb=&word=Backup+and+Recovery#a96519
>
> Regards,
> Arun
>

Beg to differ Arun. If the database is in archive mode you certainly can do a pit (and complete) recovery from a cold backup.

Anthony Hogan Received on Thu Mar 10 2005 - 10:42:10 CST