data recovery

[Ademir Viana de Freitas]

Hello,
I am a newbee DBA and have a little problem.
My online database lost 2 days of data because of an error in our backup-to-disk routine. I already have recovered the database files (.rdb, .rbf, .snp, .rda, .aij) from Tape into one directory in a separate disk... Now I need to read that database in order to select only those 2 days of data and upload them into the online database.

I have a Alpha1000 Server, Oracle 7.0, OpenVMS.

Thanks for help and attention.
Ademir

[Robert Gezelter]

Ademir,

Has the system been returned to service yet?

- Bob Gezelter, http://www.rlgsc.com

[Ademir Viana de Freitas]

yes, the database is on service, ok. but if we search for june 28th, 29th no data there. The thing is we have a delete_old_data_routine that ran that day, with the backup_to_disk routine faulting...

thanks

[Ian Miller.]

Is this Oracle RDB V7.0 ?

You may be able to use the RMU/UNLOAD facilty to extract the required rows from the restored database and insert them into the live DB. You may be able to do something with the .AIJ files.

An other place for RDB questions are the
RDB Managers list
http://www.jcc.com/jccs_oracle_list_servers.htm

[Robert Gezelter]

Ademir,

Extreme caution is advised here.

If the database is a log of transactions, then extracting them and re-inserting them MAY be ok (however, you do need to verify that there are no other data items in other tables that were updated in the interim).

For example, if the log records refer to another table by index, you may have created overlapping index assignments. For example, suppose the log records refer to the Index (Row Number) of the AccountName in a different table:

Old Database New Database
019 Smith 019 Smith
020 Jones 020 Bartton
021 Appleby 021 Julius

If you attempt to restore the log records from such a database, you will have a problem.

You need to verify that there are no problems caused by ther consistency of the information that you wish to restore.

Also, check with your Audit department if any paperwork must be completed to legally document what you are doing.

- Bob Gezelter, http://www.rlgsc.com

[Ademir Viana de Freitas]

Thank you, Mr. Gezelter,
I have this concern as well.
The online database doesNOT have this data there, no trace of them. So, no worries about updating.
I have these data only on disk6 (recovered from tape).

I tried defining a new logical for the recovered database (disk6) but the .rdb file has directions to the online DB (disk1). I need to change the references here (I think)
First, in order to have the logical working, I have to change the disk6.rdb to be linked to disk6.snp...rda... and not to DISK1.rda,snp....Perhaps I am on the wrong way...

thank you for the kind attention.
Ademir