Oracle-L: FW: Urgent!!Data lost

From: Muqthar Ahmed <Muqthar.Ahmed_at_decoratetoday.com>
Date: Thu, 20 Jun 2002 09:49:04 -0800
Message-ID: <F001.00482FD6.20020620094904@fatcity.com>

Hi,

Let me make your task little easy...the procedure is as follows:

Assuming your database name is PROD database. Restore the database in development server with the SAME database name.

Setup your LISTENER.ORA and TNSNAMES.ORA FILES
Restore ALL PROD datafiles to a location. Since production and devlopment servers file structure is not same, you have to restore in a different file structure.
Mount the database and rename files (so that controfile will register the new location). ALTER DATABASE RENAME FILE 'old_location' TO 'new_location';
Open the database

Now comes the tricky part. Your month old CONTROLFILE do not know about new ARCHIVED FILES. So you can not apply archived files. When you try to apply log files, it will you that there is nothing to apply.

To apply new archived files:

Shutdown your database.
Rename your CONTROLFILES (Keep this controlfiles in case you need to go back).
Copy your CONTROLFILES from your PRODUCTION database (which has latest information).
Mount the database and rename files again(because this controlfile is from PRODUCTION).
Run the following queries to check the latest log sequence number: sql > select * from v$log; sql > select max(name) name from v$archived_log; sql > select name, value from v$parameter where name = 'log_archive_dest';
copy your archived log files to 'log_archive_dest' location.
Now you can apply the archived log files by running the following query sql > recover database using backup controlfile until cancel; or sql > recover database using backup controlfile until time 'JUN 16 2002:02:00:00';
Since you are using BACKUP CONTROLFILE command, it is INCOMPLETE RECOVERY. Whenever you do INCOMPLETE RECOVERY you MUST OPEN the database with RESETLOGS. sql > alter database open resetlogs;

After you OPEN the database, you can export the table and import in PRODUCTION database.

All the best!

Muqthar Ahmed
DBA
-----Original Message-----

Sent: Thursday, June 20, 2002 10:14 AM
To: Multiple recipients of list ORACLE-L

Hi,

If you have to recover ONLY ONE TABLE, you have to create a separate database from your COLD backup and apply archived logs before the table was dropped/corrupted. Export the table and import in production database.

Muqthar Ahmed
DBA
-----Original Message-----

Sent: Thursday, June 20, 2002 9:18 AM
To: Multiple recipients of list ORACLE-L

Hello
we have lost one table data and we need to recover them, urgently. Situation details:

  *We have a cold backup DB one month ago
  *Database in archive log mode
  *We don´t have export files

We know our situation is extremely and it problably would be very difficult to
recover them but we´d want to know if there is any way to do it. Thanks a lot
--

Beatriz Martínez Jiménez Ingeniera Informática Tfno: 983 546646 beamar_at_cidaut.es
Fundación CIDAUT
Centro de Investigación y desarrollo en Automoción Parque Tecnológico de Boecillo, p.209. 47151 Boecillo, Valladolid.

--

Please see the official ORACLE-L FAQ: http://www.orafaq.com
--

Author: Beatriz =?iso-8859-1?Q?Mart=EDnez=20Jim=E9nez?= INET: beamar_at_cidaut.es

Fat City Network Services    -- (858) 538-5051  FAX: (858) 538-5051
San Diego, California        -- Public Internet access / Mailing Lists


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

To REMOVE yourself from this mailing list, send an E-Mail message

to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
--

Please see the official ORACLE-L FAQ: http://www.orafaq.com
--

Author: Muqthar Ahmed
INET: Muqthar.Ahmed_at_decoratetoday.com

Fat City Network Services    -- (858) 538-5051  FAX: (858) 538-5051
San Diego, California        -- Public Internet access / Mailing Lists


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

To REMOVE yourself from this mailing list, send an E-Mail message

Fat City Network Services    -- (858) 538-5051  FAX: (858) 538-5051
San Diego, California        -- Public Internet access / Mailing Lists


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

To REMOVE yourself from this mailing list, send an E-Mail message