RE: Recover a table from cold backup-noarchivelog
- From: "GUPTA, DEEPENDER" <DGUPTA@xxxxxxxxxxx>
- To: "'oracle-l@xxxxxxxxxxxxx'" <oracle-l@xxxxxxxxxxxxx>
- Date: Tue, 31 Aug 2004 11:13:21 -0500
If we know the default tablespace of the table then can't we just restore
the associated datafiles, system datafile, temp datafile and control files
and then startup mount the database.
Then "offline drop" all other datafiles apart from the above mentioned files
and then open the database and take the export of the table.
-----Original Message-----
From: Daniel Fink [mailto:Daniel.Fink@xxxxxxx]
Sent: Tuesday, August 31, 2004 9: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:
