The only thing you can do is to shutdown the database and restore all the
files from the backupset. You cannot a partial restore or a point-in-time
recovery without archivelogs.
HTH,
Ruth
-----Original Message-----
From: oracle-l-bounce_at_freelists.org
[mailto:oracle-l-bounce_at_freelists.org]On Behalf Of Srinivasa Medam
Sent: Tuesday, August 31, 2004 10:05 AM
To: oracle-l_at_freelists.org
Subject: Recover a table from cold backup-noarchivelog
Hi, I have a database running in noarchivelog mode.
Scenario:
I have a test database running in noarchivelog mode. Database is 8i. Cold
backup is performed weekly. It is a filecopy, NOT RMAN backup. Just all
datafiles, control files, init files are copied to backup location. Users
dropped a table and wanted it to be recovered as of the last cold backup.
Can someone please help me with this process.
thanks in advance.
Srinivas
Do You Yahoo!?
Tired of spam? Yahoo! Mail has the best spam protection around
http://mail.yahoo.com
Please see the official ORACLE-L FAQ:
http://www.orafaq.com
To unsubscribe send email to: oracle-l-request_at_freelists.org
put 'unsubscribe' in the subject line.
--
Archives are at
http://www.freelists.org/archives/oracle-l/
FAQ is at
http://www.freelists.org/help/fom-serve/cache/1.html
Please see the official ORACLE-L FAQ:
http://www.orafaq.com
To unsubscribe send email to: oracle-l-request_at_freelists.org
put 'unsubscribe' in the subject line.
--
Archives are at
http://www.freelists.org/archives/oracle-l/
FAQ is at
http://www.freelists.org/help/fom-serve/cache/1.html
Received on Tue Aug 31 2004 - 09:11:24 CDT