Re: Database Crash...advice needed...

From: <djordan_at_notes.primeco.com>
Date: Wed, 30 Aug 2000 14:41:27 -0500
Message-Id: <10604.115914@fatcity.com>

--0__=ENKHyNMAgyqUqj635pt49P37ruXkEVAQC6KfbROvWb9Yj2qHI3dx2viv
Content-type: text/plain; charset=us-ascii Content-Disposition: inline

I had this message today after moving a database to another server, and was caused by bringing up a database with a missing rollback segment. After removing the entry (segment had been dropped but entry not removed on old server) from the config.ora/init.ora file, just shutting down and restarting brought the database right back up normal (SUN Solaris 7.3.4).

Also, if you have restored the RBS datafile from hotbackup and performed recovery, you might just have a corrupted rollback segment and can get away with just including the bad segment(s) in:

_corrupted_rollback_segments=(r01,r02,r03......r99)

My two cents,
David

prashasta gujrati <gujrati_at_tubes.tatasteel.com> on 08/30/2000 03:03:46 PM

Please respond to ORACLE-L_at_fatcity.com

                                                              
                                                              
                                                              
 To:      Multiple recipients of list ORACLE-L                
          <ORACLE-L_at_fatcity.com>                              
                                                              
 cc:      (bcc: David Jordan/HQ/PCS PrimeCo)                  
                                                              
                                                              
                                                              
 Subject: Database Crash...advice needed...

Hi DBAs,

This is the scenario : Oracle 7.3.3 on AIX 4.3.2

Time Event

0300          Offline backup of the database done successfully.
1523          Hard disk failure on one of the disks(hdisk9) mounted
                 on /database. This FS had  1 system DBF, 2 RBS files,
                 3 application DBFs.

                 These files were taken offline automatically as
reported
                 in alert.log .

1530          Error reported of applications not working and DB having
                 crashed.

1535          Database was shutdown with abort and tried doing a
                 normal startup which failed. Database could only be
                 mounted. It has been brought down since then.

1600         Another FS was created on a different disk (hdisk10)
                and was mounted on the same mount point (/database).

1630         We restored the DBFs from the offline backup which
                were residing on that mount point (/database).

1640         Database startup mount. After that we issued a recover
                database which prompted for the archive files which
                were avilable on another disk and were applied. The Redo

                is also intact.

                What we see here is that it takes us to a point between
1523
                and 1535.

                Now when we try to open the database it says that one of

                the RBS files cannot be read. We tried commenting out
the
                rollback_segments from init.ora and then did startup
mount.
                Thereafter, we made the RBS files offline to see if the
                database will reopen. It fails with an error message :
                  ORA-00704: bootstrap process failure
                  ORA-00604: error occurred at recursive SQL level 1
                  ORA-00955: name is already used by an existing object

After all this now we have planned to restore all the files from offline

backup and use the current controlfile + redo + archives to do a PITR upto 1515 (few minutes before the disk failure) and then open the DB with resetlogs option and then take an offline backup immediately.

If you all can tell me the error we made in this process, it'll help. Also your advice if the second approach we are taking will work or not ?

TIA,
--0__=ENKHyNMAgyqUqj635pt49P37ruXkEVAQC6KfbROvWb9Yj2qHI3dx2viv
Content-type: text/html;

name="att1.htm"

Content-Disposition: attachment; filename="att1.htm"
Content-transfer-encoding: base64
Content-Description: Internet HTML

PCFkb2N0eXBlIGh0bWwgcHVibGljICItLy93M2MvL2R0ZCBodG1sIDQuMCB0cmFuc2l0aW9uYWwv L2VuIj4NCjxodG1sPg0KJm5ic3A7DQo8YnI+SGkgREJBcywNCjxwPlRoaXMgaXMgdGhlIHNjZW5h cmlvIDogT3JhY2xlIDcuMy4zIG9uIEFJWCA0LjMuMg0KPHA+VGltZSZuYnNwOyZuYnNwOyZuYnNw OyZuYnNwOyZuYnNwOyZuYnNwOyZuYnNwOyZuYnNwOyBFdmVudA0KPHA+MDMwMCZuYnNwOyZuYnNw OyZuYnNwOyZuYnNwOyZuYnNwOyZuYnNwOyZuYnNwOyZuYnNwOyZuYnNwOyBPZmZsaW5lIGJhY2t1 cA0Kb2YgdGhlIGRhdGFiYXNlIGRvbmUgc3VjY2Vzc2Z1bGx5Lg0KPGJyPjE1MjMmbmJzcDsmbmJz cDsmbmJzcDsmbmJzcDsmbmJzcDsmbmJzcDsmbmJzcDsmbmJzcDsmbmJzcDsgSGFyZCBkaXNrDQpm YWlsdXJlIG9uIG9uZSBvZiB0aGUgZGlza3MoaGRpc2s5KSBtb3VudGVkDQo8YnI+Jm5ic3A7Jm5i c3A7Jm5ic3A7Jm5ic3A7Jm5ic3A7Jm5ic3A7Jm5ic3A7Jm5ic3A7Jm5ic3A7Jm5ic3A7Jm5ic3A7 Jm5ic3A7Jm5ic3A7Jm5ic3A7Jm5ic3A7Jm5ic3A7DQpvbiAvZGF0YWJhc2UuIFRoaXMgRlMgaGFk Jm5ic3A7IDEgc3lzdGVtIERCRiwgMiBSQlMgZmlsZXMsDQo8YnI+Jm5ic3A7Jm5ic3A7Jm5ic3A7 Jm5ic3A7Jm5ic3A7Jm5ic3A7Jm5ic3A7Jm5ic3A7Jm5ic3A7Jm5ic3A7Jm5ic3A7Jm5ic3A7Jm5i c3A7Jm5ic3A7Jm5ic3A7Jm5ic3A7DQozIGFwcGxpY2F0aW9uIERCRnMuDQo8cD4mbmJzcDsmbmJz cDsmbmJzcDsmbmJzcDsmbmJzcDsmbmJzcDsmbmJzcDsmbmJzcDsmbmJzcDsmbmJzcDsmbmJzcDsm bmJzcDsmbmJzcDsmbmJzcDsmbmJzcDsmbmJzcDsNClRoZXNlIGZpbGVzIHdlcmUgdGFrZW4gb2Zm bGluZSBhdXRvbWF0aWNhbGx5IGFzIHJlcG9ydGVkDQo8YnI+Jm5ic3A7Jm5ic3A7Jm5ic3A7Jm5i c3A7Jm5ic3A7Jm5ic3A7Jm5ic3A7Jm5ic3A7Jm5ic3A7Jm5ic3A7Jm5ic3A7Jm5ic3A7Jm5ic3A7 Jm5ic3A7Jm5ic3A7Jm5ic3A7DQppbiBhbGVydC5sb2cgLg0KPHA+MTUzMCZuYnNwOyZuYnNwOyZu YnNwOyZuYnNwOyZuYnNwOyZuYnNwOyZuYnNwOyZuYnNwOyZuYnNwOyBFcnJvciByZXBvcnRlZA0K b2YgYXBwbGljYXRpb25zIG5vdCB3b3JraW5nIGFuZCBEQiBoYXZpbmcNCjxicj4mbmJzcDsmbmJz cDsmbmJzcDsmbmJzcDsmbmJzcDsmbmJzcDsmbmJzcDsmbmJzcDsmbmJzcDsmbmJzcDsmbmJzcDsm bmJzcDsmbmJzcDsmbmJzcDsmbmJzcDsmbmJzcDsNCmNyYXNoZWQuDQo8cD4xNTM1Jm5ic3A7Jm5i c3A7Jm5ic3A7Jm5ic3A7Jm5ic3A7Jm5ic3A7Jm5ic3A7Jm5ic3A7Jm5ic3A7IERhdGFiYXNlDQp3 YXMgc2h1dGRvd24gd2l0aCBhYm9ydCBhbmQgdHJpZWQgZG9pbmcgYQ0KPGJyPiZuYnNwOyZuYnNw OyZuYnNwOyZuYnNwOyZuYnNwOyZuYnNwOyZuYnNwOyZuYnNwOyZuYnNwOyZuYnNwOyZuYnNwOyZu YnNwOyZuYnNwOyZuYnNwOyZuYnNwOyZuYnNwOw0Kbm9ybWFsIHN0YXJ0dXAgd2hpY2ggZmFpbGVk LiBEYXRhYmFzZSBjb3VsZCBvbmx5IGJlDQo8YnI+Jm5ic3A7Jm5ic3A7Jm5ic3A7Jm5ic3A7Jm5i c3A7Jm5ic3A7Jm5ic3A7Jm5ic3A7Jm5ic3A7Jm5ic3A7Jm5ic3A7Jm5ic3A7Jm5ic3A7Jm5ic3A7 Jm5ic3A7Jm5ic3A7DQptb3VudGVkLiBJdCBoYXMgYmVlbiBicm91Z2h0IGRvd24gc2luY2UgdGhl bi4NCjxwPjE2MDAmbmJzcDsmbmJzcDsmbmJzcDsmbmJzcDsmbmJzcDsmbmJzcDsmbmJzcDsmbmJz cDsgQW5vdGhlciBGUyB3YXMNCmNyZWF0ZWQgb24gYSBkaWZmZXJlbnQgZGlzayAoaGRpc2sxMCkN Cjxicj4mbmJzcDsmbmJzcDsmbmJzcDsmbmJzcDsmbmJzcDsmbmJzcDsmbmJzcDsmbmJzcDsmbmJz cDsmbmJzcDsmbmJzcDsmbmJzcDsmbmJzcDsmbmJzcDsmbmJzcDsNCmFuZCB3YXMgbW91bnRlZCBv biB0aGUgc2FtZSBtb3VudCBwb2ludCAoL2RhdGFiYXNlKS4NCjxwPjE2MzAmbmJzcDsmbmJzcDsm bmJzcDsmbmJzcDsmbmJzcDsmbmJzcDsmbmJzcDsmbmJzcDsgV2UgcmVzdG9yZWQgdGhlDQpEQkZz IGZyb20gdGhlIG9mZmxpbmUgYmFja3VwIHdoaWNoDQo8YnI+Jm5ic3A7Jm5ic3A7Jm5ic3A7Jm5i c3A7Jm5ic3A7Jm5ic3A7Jm5ic3A7Jm5ic3A7Jm5ic3A7Jm5ic3A7Jm5ic3A7Jm5ic3A7Jm5ic3A7 Jm5ic3A7Jm5ic3A7DQp3ZXJlIHJlc2lkaW5nIG9uIHRoYXQgbW91bnQgcG9pbnQgKC9kYXRhYmFz ZSkuDQo8cD4xNjQwJm5ic3A7Jm5ic3A7Jm5ic3A7Jm5ic3A7Jm5ic3A7Jm5ic3A7Jm5ic3A7Jm5i c3A7IERhdGFiYXNlIHN0YXJ0dXANCm1vdW50LiBBZnRlciB0aGF0IHdlIGlzc3VlZCBhIHJlY292 ZXINCjxicj4mbmJzcDsmbmJzcDsmbmJzcDsmbmJzcDsmbmJzcDsmbmJzcDsmbmJzcDsmbmJzcDsm bmJzcDsmbmJzcDsmbmJzcDsmbmJzcDsmbmJzcDsmbmJzcDsmbmJzcDsNCmRhdGFiYXNlIHdoaWNo IHByb21wdGVkIGZvciB0aGUgYXJjaGl2ZSBmaWxlcyB3aGljaA0KPGJyPiZuYnNwOyZuYnNwOyZu YnNwOyZuYnNwOyZuYnNwOyZuYnNwOyZuYnNwOyZuYnNwOyZuYnNwOyZuYnNwOyZuYnNwOyZuYnNw OyZuYnNwOyZuYnNwOyZuYnNwOw0Kd2VyZSBhdmlsYWJsZSBvbiBhbm90aGVyIGRpc2sgYW5kIHdl cmUgYXBwbGllZC4gVGhlIFJlZG8NCjxicj4mbmJzcDsmbmJzcDsmbmJzcDsmbmJzcDsmbmJzcDsm bmJzcDsmbmJzcDsmbmJzcDsmbmJzcDsmbmJzcDsmbmJzcDsmbmJzcDsmbmJzcDsmbmJzcDsmbmJz cDsNCmlzIGFsc28gaW50YWN0Lg0KPHA+Jm5ic3A7Jm5ic3A7Jm5ic3A7Jm5ic3A7Jm5ic3A7Jm5i c3A7Jm5ic3A7Jm5ic3A7Jm5ic3A7Jm5ic3A7Jm5ic3A7Jm5ic3A7Jm5ic3A7Jm5ic3A7Jm5ic3A7 DQpXaGF0IHdlIHNlZSBoZXJlIGlzIHRoYXQgaXQgdGFrZXMgdXMgdG8gYSBwb2ludCBiZXR3ZWVu IDE1MjMNCjxicj4mbmJzcDsmbmJzcDsmbmJzcDsmbmJzcDsmbmJzcDsmbmJzcDsmbmJzcDsmbmJz cDsmbmJzcDsmbmJzcDsmbmJzcDsmbmJzcDsmbmJzcDsmbmJzcDsmbmJzcDsNCmFuZCAxNTM1Lg0K PHA+Jm5ic3A7Jm5ic3A7Jm5ic3A7Jm5ic3A7Jm5ic3A7Jm5ic3A7Jm5ic3A7Jm5ic3A7Jm5ic3A7 Jm5ic3A7Jm5ic3A7Jm5ic3A7Jm5ic3A7Jm5ic3A7Jm5ic3A7DQpOb3cgd2hlbiB3ZSB0cnkgdG8g b3BlbiB0aGUgZGF0YWJhc2UgaXQgc2F5cyB0aGF0IG9uZSBvZg0KPGJyPiZuYnNwOyZuYnNwOyZu YnNwOyZuYnNwOyZuYnNwOyZuYnNwOyZuYnNwOyZuYnNwOyZuYnNwOyZuYnNwOyZuYnNwOyZuYnNw OyZuYnNwOyZuYnNwOyZuYnNwOw0KdGhlIFJCUyBmaWxlcyBjYW5ub3QgYmUgcmVhZC4gV2UgdHJp ZWQgY29tbWVudGluZyBvdXQgdGhlDQo8YnI+Jm5ic3A7Jm5ic3A7Jm5ic3A7Jm5ic3A7Jm5ic3A7 Jm5ic3A7Jm5ic3A7Jm5ic3A7Jm5ic3A7Jm5ic3A7Jm5ic3A7Jm5ic3A7Jm5ic3A7Jm5ic3A7Jm5i c3A7DQpyb2xsYmFja19zZWdtZW50cyBmcm9tIGluaXQub3JhIGFuZCB0aGVuIGRpZCBzdGFydHVw IG1vdW50Lg0KPGJyPiZuYnNwOyZuYnNwOyZuYnNwOyZuYnNwOyZuYnNwOyZuYnNwOyZuYnNwOyZu YnNwOyZuYnNwOyZuYnNwOyZuYnNwOyZuYnNwOyZuYnNwOyZuYnNwOyZuYnNwOw0KVGhlcmVhZnRl ciwgd2UgbWFkZSB0aGUgUkJTIGZpbGVzIG9mZmxpbmUgdG8gc2VlIGlmIHRoZQ0KPGJyPiZuYnNw OyZuYnNwOyZuYnNwOyZuYnNwOyZuYnNwOyZuYnNwOyZuYnNwOyZuYnNwOyZuYnNwOyZuYnNwOyZu YnNwOyZuYnNwOyZuYnNwOyZuYnNwOyZuYnNwOw0KZGF0YWJhc2Ugd2lsbCByZW9wZW4uIEl0IGZh aWxzIHdpdGggYW4gZXJyb3IgbWVzc2FnZSA6DQo8YnI+Jm5ic3A7Jm5ic3A7Jm5ic3A7Jm5ic3A7 Jm5ic3A7Jm5ic3A7Jm5ic3A7Jm5ic3A7Jm5ic3A7Jm5ic3A7Jm5ic3A7Jm5ic3A7Jm5ic3A7Jm5i c3A7Jm5ic3A7Jm5ic3A7Jm5ic3A7DQpPUkEtMDA3MDQ6IGJvb3RzdHJhcCBwcm9jZXNzIGZhaWx1 cmUNCjxicj4mbmJzcDsmbmJzcDsmbmJzcDsmbmJzcDsmbmJzcDsmbmJzcDsmbmJzcDsmbmJzcDsm bmJzcDsmbmJzcDsmbmJzcDsmbmJzcDsmbmJzcDsmbmJzcDsmbmJzcDsmbmJzcDsmbmJzcDsNCk9S QS0wMDYwNDogZXJyb3Igb2NjdXJyZWQgYXQgcmVjdXJzaXZlIFNRTCBsZXZlbCAxDQo8YnI+Jm5i c3A7Jm5ic3A7Jm5ic3A7Jm5ic3A7Jm5ic3A7Jm5ic3A7Jm5ic3A7Jm5ic3A7Jm5ic3A7Jm5ic3A7 Jm5ic3A7Jm5ic3A7Jm5ic3A7Jm5ic3A7Jm5ic3A7Jm5ic3A7Jm5ic3A7DQpPUkEtMDA5NTU6IG5h bWUgaXMgYWxyZWFkeSB1c2VkIGJ5IGFuIGV4aXN0aW5nIG9iamVjdA0KPHA+QWZ0ZXIgYWxsIHRo aXMgbm93IHdlIGhhdmUgcGxhbm5lZCB0byByZXN0b3JlIGFsbCB0aGUgZmlsZXMgZnJvbSBvZmZs aW5lDQo8YnI+YmFja3VwIGFuZCB1c2UgdGhlIGN1cnJlbnQgY29udHJvbGZpbGUgKyByZWRvICsg YXJjaGl2ZXMgdG8gZG8gYSBQSVRSDQo8YnI+dXB0byAxNTE1IChmZXcgbWludXRlcyBiZWZvcmUg dGhlIGRpc2sgZmFpbHVyZSkgYW5kIHRoZW4gb3BlbiB0aGUgREINCjxicj53aXRoIHJlc2V0bG9n cyBvcHRpb24gYW5kIHRoZW4gdGFrZSBhbiBvZmZsaW5lIGJhY2t1cCBpbW1lZGlhdGVseS4NCjxw PjxiPklmIHlvdSBhbGwgY2FuIHRlbGwgbWUgdGhlIGVycm9yIHdlIG1hZGUgaW4gdGhpcyBwcm9j ZXNzLCBpdCdsbCBoZWxwLjwvYj4NCjxicj48Yj5BbHNvIHlvdXIgYWR2aWNlIGlmIHRoZSBzZWNv bmQgYXBwcm9hY2ggd2UgYXJlIHRha2luZyB3aWxsIHdvcms8L2I+DQo8YnI+PGI+b3Igbm90ID88 Received on Wed Aug 30 2000 - 14:41:27 CDT