| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
 |
 | |||
| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
|
| |||
Home -> Community -> Usenet -> c.d.o.server -> Re: no rollback...
On Mon, 14 Apr 1997 09:39:47 +0100, Steve Phelan <stevep_at_pmcgettigan.demon.co.uk> wrote:
>Thomas Kyte wrote:
>
>> On Sun, 13 Apr 1997 13:53:40 GMT, mjr_at_netcom.com (Mark Rosenbaum)
>> wrote:
>>
>> >In article <334BC3A7.75EB_at_medicalert.org>,
>> >Tim Witort <trw_at_medicalert.org> wrote:
[snip]
>
> This very subject - disabling rollback and/or redo has been discussed
>here before. As I put in my original reply to the original poster - I
>wouldn't recommnded him disabling either. From what was discussed
>previously on this subject there IS and Oracle '_xxxx' underscore style
>parameter than can disable redo logging database wide. However, it's not
>Oracle recommnded or supported hence should not be used.
>
>Steve Phelan.
>
Warning: if you use the undocumented, unsupported, un-talked about setting you will lose your database very quickly.
disableing redo (which this lets you do) will make it so that if you database is shutdown in any manner OTHER then "shutdown" or "shutdown immediate", it will never startup again. If you "shutdown abort" or lose power to the machine or the instance otherwise shutdowns, it will not be able to perform crash recovery, it will not start again.
Thomas Kyte
tkyte_at_us.oracle.com
Oracle Government
Bethesda MD
http://govt.us.oracle.com/ -- downloadable utilities
 |
 |