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).
