topic Re: data recovery in Operating System - OpenVMS

data recovery

Ademir Viana de Freitas — Wed, 09 Aug 2006 06:09:21 GMT

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

Re: data recovery

Robert Gezelter — Wed, 09 Aug 2006 06:50:55 GMT

Ademir,

Has the system been returned to service yet?

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

Re: data recovery

Ademir Viana de Freitas — Wed, 09 Aug 2006 06:56:04 GMT

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

Re: data recovery

Ian Miller. — Wed, 09 Aug 2006 07:39:27 GMT

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

Re: data recovery

Robert Gezelter — Wed, 09 Aug 2006 07:46:22 GMT

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

Re: data recovery

Ademir Viana de Freitas — Wed, 09 Aug 2006 07:57:12 GMT

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