RE: Recover a table from cold backup-noarchivelog
- From: "Mark W. Farnham" <mwf@xxxxxxxx>
- To: <oracle-l@xxxxxxxxxxxxx>
- Date: Tue, 31 Aug 2004 10:25:41 -0400
If you have a test machine, just load up the whole database there, export
the table you need, transfer the file to the production machine, and import
the table (or use sqlplus copy being sure to set LONG long enough).
If you don't have a test machine, after you finish spanking whoever is
responsible for that situation, carefully get a new cold backup, preferably
in duplicate on independent media (how much is this database worth?) Then
load up SYSTEM, the tablespace files holding the table you need, the cold
backup online redo logs, and the cold backup control file. Start up but do
not open, alter all the other datafiles off line, open, export the table you
need, shut down, put production back in place, open up, and import the
table. IF you really did a cold backup correctly, that should work. If you
did a shutdown non-normal without a startup restrict shutdown normal before
copying the files you may have various problems and it may be simpler to
reload the entire cold backup. If you're confused about the offline stuff it
may be easier to do the full restore anyway.
Good luck. Why in the world are you rock climbing without belaying? Do you
understand that recovery within the week end points is limited absolutely as
soon as you wrap the online logs? Do you have a re-runnable source of all
the transactions between the cold backups outside of Oracle?
Good luck.
mwf
-----Original Message-----
From: oracle-l-bounce@xxxxxxxxxxxxx
[mailto:oracle-l-bounce@xxxxxxxxxxxxx]On Behalf Of Srinivasa Medam
Sent: Tuesday, August 31, 2004 10: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:
