RE: Recover a table from cold backup-noarchivelog

From: Mercadante, Thomas F <thomas.mercadante_at_labor.state.ny.us>
Date: Tue, 31 Aug 2004 10:10:26 -0400
Message-ID: <543DF856D23431489D4B8028C300FBAB08AC93F3@exchsen0a1mb>

Srinivasa,

I am assuming that the rest of the current database needs to be kept, that you only need to recover the one table form the prioir weeks backup.

This is what you need to do:

1). Take a new cold backup of the current database - shut it down, and back it up to tape.

2). Restore the old backup from tape - restore everything.

Start the database.
Perform an Oracle Export of the one table that was dropped. Shut the database down.
3). Restore the database from step one.

Start the database
Import the table from step 2.

Go have a beer.

Hope this helps.

Tom Mercadante
Oracle Certified Professional

-----Original Message-----

From: Srinivasa Medam [mailto:sri1003_at_yahoo.com] Sent: Tuesday, August 31, 2004 10:05 AM
To: oracle-l_at_freelists.org
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_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


-----------------------------------------------------------------

----------------------------------------------------------------

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 - 09:06:35 CDT