RE: Recover a table from cold backup-noarchivelog
- From: Venkatesh Sadagopan <Venkatesh.Sadagopan@xxxxxxxxxxx>
- To: "'oracle-l@xxxxxxxxxxxxx'" <oracle-l@xxxxxxxxxxxxx>
- Date: Tue, 31 Aug 2004 07:29:02 -0700
Hi Srinivas
One more option to consider,
Take this backup to a diffent system.
Restore system,rbs and the tablespace that contains your table
( preferably all the files of this tablespace )..startup mount and drop all
other datafiles using 'alter database datafile '....' offline drop'. bring
up the database. export the table that you need.. i made lots of assumptions
here .. ( you need relatively a small table to recover and the tablespace
that contains this table is not the only tablespace in the db )
Cheers
S venkatesh
-----Original Message-----
From: oracle-l-bounce@xxxxxxxxxxxxx
[mailto:oracle-l-bounce@xxxxxxxxxxxxx]On Behalf Of Srinivasa Medam
Sent: Tuesday, August 31, 2004 7:05 AM
To: oracle-l@xxxxxxxxxxxxx
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@xxxxxxxxxxxxx
put 'unsubscribe' in the subject line.
--
Archives are at //www.freelists.org/archives/oracle-l/
FAQ is at //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@xxxxxxxxxxxxx
put 'unsubscribe' in the subject line.
--
Archives are at //www.freelists.org/archives/oracle-l/
FAQ is at //www.freelists.org/help/fom-serve/cache/1.html
-----------------------------------------------------------------
Other related posts:
