Re: Simple archive question

From: Arun Mathur <themathurs_at_gmail.com>
Date: 10 Mar 2005 08:34:52 -0800
Message-ID: <1110472492.329321.301470@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 Received on Thu Mar 10 2005 - 10:34:52 CST