-
URGENT: ORA-01092: ORACLE instance terminated. Disconnection forced
HI there Fellow DBS's
This is really urgent.
What I did: I moved my RBS file to another mount point. When I started the move I realised my Database was still up (online).
When the file was done moving, I moved it back to the original directory. I then did a shutdown immediate and it took too long, so i did a shutdown abort. When I tried doing a startup I got the following error:
SVRMGR> startup
ORACLE instance started.
Total System Global Area 802885792 bytes
Fixed Size 73888 bytes
Variable Size 433106944 bytes
Database Buffers 368640000 bytes
Redo Buffers 1064960 bytes
Database mounted.
ORA-01092: ORACLE instance terminated. Disconnection forced
This is my production database. I need to get it back up ASAP.
The only solution I have now is to do a restore from a hot backup and recover to a point in time..... Is there perhaps a easier solution?
Thanks
Charlton
-
In my log file it shows the following error:
ORA-01545: rollback segment 'RBS01' specified not available
-
Comment out the RBSs from the init.ora file and startup the instance.
When the database is open recreate the rollback segments.
Oracle Certified Master
Oracle Certified Professional 6i,8i,9i,10g,11g,12c
email: ocp_9i@yahoo.com
-
How do you recreate the RBS? I never needed to this before so you help will be greatly appreciated.
-
Originally posted by charlton
How do you recreate the RBS? I never needed to this before so you help will be greatly appreciated.
First, after commenting out the RBSs in init.ora, are you able to open the database?
Which version?
Oracle Certified Master
Oracle Certified Professional 6i,8i,9i,10g,11g,12c
email: ocp_9i@yahoo.com
-
Yes it did open after I commented out the entire RBS line in the init.ora file.
The version I am running is 8i.
-
Originally posted by charlton
Yes it did open after I commented out the entire RBS line in the init.ora file.
The version I am running is 8i.
OK, so far so good. Now carefully:
1. Take all rollback segments offline.
2. Take the tablespace offline.
3. Drop the RBS tablespace.
If this succeeds we will recreate the RBS tablespace.
Oracle Certified Master
Oracle Certified Professional 6i,8i,9i,10g,11g,12c
email: ocp_9i@yahoo.com
-
Here is how to recreate the RBSs. After you have dropped all old ones:
1.
SQL> CREATE ROLLBACK SEGMENT rbs_dummy
TABLESPACE system
STORAGE (INITIAL 10k NEXT 10k MINEXTENTS 2);
Rollback segment created.
2.
SQL> ALTER ROLLBACK SEGMENT rbs_dummy ONLINE;
Rollback segment altered.
3.
SQL> CREATE ROLLBACK SEGMENT rbs1
TABLESPACE ts_name_rbs
STORAGE (...);
Rollback segment created.
SQL> ALTER ROLLBACK SEGMENT rbs1 ONLINE;
Rollback segment altered.
4.
Like in 3, create the rest.
5.
SQL> DROP ROLLBACK SEGMENT rbs_dummy;
Oracle Certified Master
Oracle Certified Professional 6i,8i,9i,10g,11g,12c
email: ocp_9i@yahoo.com
-
Julian, I am a bit scared so just confirm if this is correct:
ALTER DATABASE DATAFILE 'rbsxx.dbf' ONLINE;
Which I will do for all 7 rbs datafiles?
alter tablespace RBS offline;
DROP ROLLBACK SEGMENT rbs01.dbf
Is this correct?
-
Please, if you cannot drop a RBS, query first dba_rollback_segements and check that its status is a 'NEEDS RECOVERY' or 'ONLINE'.
Oracle Certified Master
Oracle Certified Professional 6i,8i,9i,10g,11g,12c
email: ocp_9i@yahoo.com
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
Click Here to Expand Forum to Full Width
|