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

Rollback segment corruption on oracle 7.3

November 30

We have an oracle 7.3 database on solaris(sparc) 2.6. In the midddle of the transactions, the following error message occured: ORA 1578 Data block corrupted(file #2, block#8274) ORA-1110 Datafile 2:'/user1/oradb/rbstbl.dbf' (this datafile corresponds

View All Replies

ROLLBACK SEGMENT VERSION 7.3

November 30

We have an oracle 7.3 database on solaris(sparc) 2.6. In the midddle of the transactions, the following error message occured: ORA 1578 Data block corrupted(file #2, block#8274) ORA-1110 Datafile 2:'/user1/oradb/rbstbl.dbf' (this datafile corresponds

View All Replies

Transaction table in rollback segments

November 30

hi guys, I have read the following, but am still having a little difficulty conceptualising. Would someone be kind enough to give me a very brief example? thanks For each rollback segment, Oracle maintains a transaction table--a list of all transacti

View All Replies

Oracle9i How to convert from undo tables to rollback segments

November 30

Hi, Anyone try before converting from UNDO management to using rollback segment....What are the procedures for the conversion... Thank You...Hi, Follow these steps to convert from Auto UNDO to Rollback Segs.... 1. With the database opened, create a r

View All Replies

Rollback segment  problem during import

October 11

Hello experts, please help. I have the following error when importing table data to my Oracle 8.1.7 database. IMP-00058: ORACLE error 1562 encountered ORA-01562: failed to extend rollback segment number 16 ORA-01237: cannot extend datafile 3 kind reg

View All Replies

ORA-01534 rollback segment 'R1' does not exist

November 30

Greetings HELP!! We are using oracle 8.0.5 ... The database will not open because it says the system rollback segment does not exist. The database mounts but won't open. from the file system checks, the dbf file that contains the system rollback segm

View All Replies

Convert from Rollback segment(RBS)  to undotablespace

November 30

i have a database 9i and it using rollback segment and i would like to convert to undotablespace. question is there is anyway i can find it out what size undo i need to created base on the database right now i have it. the database is very critical i

View All Replies

Is "SET TRANSACTION USE ROLLBACK SEGMENT" only a hint

October 11

I have two users, one makes some inserts in a table. The other makes a select which visits many rows. I have a big rollback-segment. To ensure, both users use this rollback-segment I created a logon-trigger: CREATE OR REPLACE TRIGGER a_logon AFTER LO

View All Replies

Trying to understand rollback segments - offline tblspaces for backup

October 11

Using Oracle 8i, on Windows platform - The question - receive an error ORA-01556 when performing a sql "ALTER TABLESPACE MY_TBS_LT OFFLINE IMMEDIATE"; ============================================= First off I created a tablespace and table on an

View All Replies

CRM Target Groups and Product Segments - BW and BPS settings

November 30

Hi gurus, I have some questions regarding the CRM Target Groups and Product Segments as it relates to BW and BPS planning layouts. 1. When a target group is created in CRM, is it supposed to also be create master data entry for the object 0TGGRP_ID i

View All Replies

What is relationship between ping and tcp in BGP ?

November 30

Dear All, As we know, BGP peer relation needs reachability  of tcp 179. But usually if the two peer neighbors can ping each other, we can consider the tcp 179 is working well. So what is relationship between ping and tcp in BGP in this situation ? Th

View All Replies

Pb with rollback segment

October 11

Hi guys. Am using oracle 8i and am having problems with rollbackup segment. My rbs tablespace is 35GB and will like to shrink it! Its a production db, so my question is shoudl I fire the below query? alter rollback segment SYSTEM shrink; alter rollba

View All Replies

Error rollback segment - urgent

November 30

hi i have created locally managed tablesspace and in init.ora file i have sent unto management as manual as our application needs to specify rollback segments when i created rollback segments and attached to a locally managed tablespace i am getting

View All Replies

Can rollback segments span one datafile like data segments

November 30

1.Can rollback segments span one datafile like data segments? For e.g we have undo tablespace with 2 data files We have one active transaction in rbs01,now when rollback segment grows and extents are allocated to it ,if all the extents will be alloca

View All Replies

Rollback segments - database logging

November 30

Got a problem... We are trying to move data from one database to another using: INSERT INTO table1 (SELECT a,b,c FROM [email protected]). The problem we are having is that the amount of data being moved with this in sert command is too great - we are gettin

View All Replies

Rollback Segments

October 11

Hello all, I am hoping someone can help me. I have a dev and prod instance, with identical rollback segment specs. The problem I have is that I am running out of space on one of my instances (dev). The prod instances rbs's are all the same size while

View All Replies

Oracle 9i - Rollback Segment Needs Recovery

November 30

I have been noticing for a few days that my UNDO tablespace has been growing in size for no apparent reason. My datafiles have only increased by 400 Meg over last 4 days, but UNDO tablespace has grown from 100 Meg - 5.6 Gig.... I decided to create a

View All Replies

Forcing a specific rollback segment on a transaction does not seem to work

October 11

Hi! We're using Oracle 9.2.0.5.0 on Sun Solaris and we're still configured to use Rollback Segments. We have an issue with Snapshot too old due to RBS too small on a long query I attach below for reference: set heading off set pagesize 0 set feedback

View All Replies

Oracle error: Ora-01555 : snapshot too old: rollback segment number 1......

November 30

System Error: Unknown Database error (type qqdb_ResourceException) on WMS_WH1: Execute failed for SQL statement ............... error from database is: ORA-01555: snapshot too old: rollback segment number 1 with name "_SYSSMU1$" too small... Any

View All Replies

Tags:

  1. j2ee batch file Pgm
  2. sony kdl 42w805a netflix problem
  3. breakpoint reached on Lenovo G 50
  4. Nokia 6120c midp certificate download
  5. mass confirm vendor
  6. hold invoice bapi
  7. f110 RFFOEDI1
  8. download BSP application
  9. UFE3
  10. ULT4
Copyrights 2019 Fcffair BigData Resource, All rights reserved