RE: Recover a table from cold backup-noarchivelog
- From: "Ruth Gramolini" <rgramolini@xxxxxxxxxxxxxxx>
- To: <oracle-l@xxxxxxxxxxxxx>
- Date: Tue, 31 Aug 2004 10:40:52 -0400
Dan,
Great post! I never even thought of this, but it should work as advertised.
It is sure worth a try as long as you backup the current version of the DB
first.
Ruth
-----Original Message-----
From: oracle-l-bounce@xxxxxxxxxxxxx
[mailto:oracle-l-bounce@xxxxxxxxxxxxx]On Behalf Of Daniel Fink
Sent: Tuesday, August 31, 2004 10:16 AM
To: oracle-l@xxxxxxxxxxxxx
Subject: Re: Recover a table from cold backup-noarchivelog
Srinivas,
The 'official' answer is that you are not able to recover just that table as
of the cold backup. You must restore the whole database
to that point in time. If you are not running in archivelog mode and
protecting your archive logs, you cannot recover a database,
only restore it.
There is another method to restore just the table. Restore the backup as a
different database (different server is even better to
reduce risks), export the table, then import it into the test database.
*However*, if you have referential integrity constraints,
relationships not enforced in the database, etc. the restored table may be
very inconsistent with the rest of the database.
This is also a great opportunity to address security issues. Most of the
restores/recoveries I have had to perform were related to
security issues (dropping tables, deleting rows, thinking you are in
development when you are in production) and not
hardware/software issues.
Regards,
Daniel Fink
Srinivasa Medam wrote:
> 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
-----------------------------------------------------------------
----------------------------------------------------------------
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:
