Re: Recover a table from cold backup-noarchivelog
- From: Daniel Fink <Daniel.Fink@xxxxxxx>
- To: oracle-l@xxxxxxxxxxxxx
- Date: Tue, 31 Aug 2004 08:16:06 -0600
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
-----------------------------------------------------------------
Other related posts:
