Re: URGENT : database down at 01-APR-96 10:32:00
From: Vincent J. Rossetti <vjr_at_chelsea.ios.com>
Date: 1996/04/02
Message-ID: <3161CF52.3C5_at_chelsea.ios.com>#1/1
Kevin Johnson Serco DPE/IO wrote:
>
> Dear All,
>
> This morning I found I could not start one of our databases :
>
> - ora-01116 error in opening datafile
>
> Indeed, I had a look and found that the file was missing.
>
> I asked one of my colleagues if he had seen it anywhere,
> but he had been busily purging his old EMAILs and so
> hadn't noticed it.
>
> Anyway , as luck would have it, he told me that he had a
> spare data file on one of his databases, and that I could have it,
> on condition that if he ever needed it in future I would return it.
>
> Better than nothing I thought, so I put the file onto my machine
> in the correct directory with the correct name.
>
> Still the database refused to start :
> - ora-01159 - file is not from same database - wrong database id
>
> So edited the file and changed the bit where Oracle records
> the ID.
>
> Next I got :
> - 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 Tue Apr 02 1996 - 00:00:00 CEST
Date: 1996/04/02
Message-ID: <3161CF52.3C5_at_chelsea.ios.com>#1/1
Kevin,
The database (or datafile) was out of sync with the rest of the database. This is why you can't just backup the datafiles you need the control files and redo log files. But you had it! If you did recover you would have recovered the database. It would have sync-ed the database to whatever info was in the redo logs, and if you have ARCHIVELOG on, you could roll to whatever time was desired. Let us know what happens...
Vin Rossetti
Kevin Johnson Serco DPE/IO wrote:
>
> Dear All,
>
> This morning I found I could not start one of our databases :
>
> - ora-01116 error in opening datafile
>
> Indeed, I had a look and found that the file was missing.
>
> I asked one of my colleagues if he had seen it anywhere,
> but he had been busily purging his old EMAILs and so
> hadn't noticed it.
>
> Anyway , as luck would have it, he told me that he had a
> spare data file on one of his databases, and that I could have it,
> on condition that if he ever needed it in future I would return it.
>
> Better than nothing I thought, so I put the file onto my machine
> in the correct directory with the correct name.
>
> Still the database refused to start :
> - ora-01159 - file is not from same database - wrong database id
>
> So edited the file and changed the bit where Oracle records
> the ID.
>
> Next I got :
> - 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 Tue Apr 02 1996 - 00:00:00 CEST