URGENT : database down at 01-APR-96 10:32:00
Date: 1996/04/01
Message-ID: <315FAC03.51FC_at_mail.esrin.esa.it>#1/1
So edited the file and changed the bit where Oracle records the ID.
- ora-01113 - file needs media recovery.
I complained to my colleague, after all it was a little bit unfair of him
to give me a file that needed recovery.
But after discussion with him, we realised that some outstanding transactions
existed is his database. Since it had taken ages to copy the data file ,
we decided to copy his log files + plus a clever bit of SQL to copy the contents
of his rollback segments into the ones in my database.
It still wouldn't do 'startup normal',
so we finally resorted to to 'startup abort'.
Obviously, we got the thing up, but some previously good programs
are now giving errors like they can't find the tables or indexes
(is this a bug?).
Anyway, back to work ; I am still busily running sql updates against the data dictionary to try and fix some of the errors.
Has anyone else had any similar experiences (today) ?
Kevin
| / _ o _ | _ | _ _ _ _ _ EMAIL : johnson_at_mail.esrin.esa.it || /_|\ /||/ | |/ \|/ ||/ ||_ / \|/ | PHONE : (+39) 6 941 80 633 | \\__ \/ || | \_/\_/| || |__|\_/| | ADDRESS : European Space Agency Via Galileo Galilei Information Administrator Frascati 00044 ITALIA.Received on Mon Apr 01 1996 - 00:00:00 CEST