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. 1. Setup your LISTENER.ORA and TNSNAMES.ORA FILES 2. 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. 3. Mount the database and rename files (so that controfile will register the new location). ALTER DATABASE RENAME FILE 'old_location' TO 'new_location'; 4. 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: 1. Shutdown your database. 2. Rename your CONTROLFILES (Keep this controlfiles in case you need to go back). 3. Copy your CONTROLFILES from your PRODUCTION database (which has latest information). 4. Mount the database and rename files again(because this controlfile is from PRODUCTION). 5. 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'; 6. copy your archived log files to 'log_archive_dest' location. 7. 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'; 8. 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 [EMAIL PROTECTED] 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: [EMAIL PROTECTED] 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: [EMAIL PROTECTED] (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: [EMAIL PROTECTED] 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: [EMAIL PROTECTED] (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: [EMAIL PROTECTED] 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: [EMAIL PROTECTED] (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).