Recover a table from cold backup-noarchivelog

From: Srinivasa Medam <sri1003_at_yahoo.com>
Date: Tue, 31 Aug 2004 07:04:58 -0700 (PDT)
Message-ID: <20040831140458.40504.qmail@web50602.mail.yahoo.com>

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


-----------------------------------------------------------------

Received on Tue Aug 31 2004 - 09:00:42 CDT