Relationship bet. SPfile and Rollback Segments

Advertisement
November 30

Hi there,
I'm wondering if there are any relationship between the above two. Since I changed SPfile and i don't remember what, the rollback segments status are changed to OFFLINE and i created a new rollback segment name (RB1) and i have to manually change the status to ONLINE everytime i restart the database. I have other segment names such as SYSSMU1$-30$ are OFFLINE. On my test db things are normal as i 1-10 is ONLINE and 10-20 is OFFLINE. Any help is appreciated.
Sam

Advertisement

Replay

The * means 'all instances' - allowing the same SPFILE to configure all instances in a RAC.
You might want to create a pfile and see the contents directly - from sqlplus (as sys or DBA) 'CREATE PFILE FROM SPFILE;'
You can edi the resulting pfile, restart the instance using 'STARTUP PFILE=?/dbs/initorcl.ora' (? is the SQLPlus symbol for ORACLE_HOME, so I'm assuming you have the pfile there.), 'CREATE SPFILE FROM PFILE;' and start up normally.
Especially since you are at 10g, I would encourage you to evaluate using the UNDO capability instead of the ROLLBACK - UNDO is simply system managed rollback instead of dba managed rollback - as there are a number of important new capabilities available with UNDO.

View 4 Replies

Tags:

  1. macbook pro periodic sound
  2. ive-w530 pairing issue blackberry
  3. illustrator cs3 initialization crash
  4. what hv to do after stolen kaptop
  5. FCAREGUL
  6. fk09 mass confirmation of vendors
  7. F990
  8. 7PBZ
  9. highesta4n
  10. within6fx
Copyrights 2019 Fcffair BigData Resource, All rights reserved