| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
 |
 | |||
| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
|
| |||
Home -> Community -> Mailing Lists -> Oracle-L -> RE: Recover a table from cold backup-noarchivelog
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_at_Sun.COM]
Sent: Tuesday, August 31, 2004 9:16 AM
To: oracle-l_at_freelists.org
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_at_freelists.org
> put 'unsubscribe' in the subject line.
> --
> Archives are at http://www.freelists.org/archives/oracle-l/
> FAQ is at http://www.freelists.org/help/fom-serve/cache/1.html
> -----------------------------------------------------------------
-- Archives are at http://www.freelists.org/archives/oracle-l/ FAQ is at http://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_at_freelists.org put 'unsubscribe' in the subject line. -- Archives are at http://www.freelists.org/archives/oracle-l/ FAQ is at http://www.freelists.org/help/fom-serve/cache/1.html -----------------------------------------------------------------Received on Tue Aug 31 2004 - 11:09:13 CDT
 |
 |