| rollback tablespace and logging [message #51155] |
Fri, 03 May 2002 10:12  |
John Bruinsma
Messages: 11
Registered: April 2002
|
Junior Member |
|
|
Greetings,
I have a 8i 8.1.7 database in production and running in archive mode. When I look in dba_tablespaces, all
tablespaces are logging mode. But what about my rollback segment RBS? Should this not be in nologging mode ?
Any response is highly appreciated.
Thanks!!
|
|
|
|
| Re: rollback tablespace and logging [message #51208 is a reply to message #51155] |
Tue, 07 May 2002 06:35  |
Kishore
Messages: 45
Registered: September 2000
|
Member |
|
|
Hi,
Rollback segments does produce redo information. Any changes to the 'rollback segment blocks' will produce 'redo'. Therefore the tablespace/s in which rollback segs resides should be in 'LOGGING' mode. Oracle need this information to rollback uncommited transactions in the case of recovery. I hope this helps you. Thanks.
Kishore
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
