扫一扫
分享文章到微信
扫一扫
关注官方公众号
至顶头条
SQL> select ksppinm,ksppdesc from x$ksppi where ksppinm like '%logging'; KSPPINM KSPPDESC -------------------- ------------------------------ _disable_logging Disable logging |
[oracle@jumper bdump]$ sqlplus "/ as sysdba" SQL*Plus: Release 9.2.0.4.0 - Production on Wed Oct 19 11:01:19 2005 Copyright (c) 1982, 2002, Oracle Corporation. All rights reserved. Connected to: Oracle9i Enterprise Edition Release 9.2.0.4.0 - Production With the Partitioning option JServer Release 9.2.0.4.0 - Production SQL> alter system set "_disable_logging"=true scope=both; System altered. |
SQL> create table t as select * from dba_users; Table created. SQL> select count(*) from t; COUNT(*) ---------- 12 SQL> shutdown abort; ORACLE instance shut down. SQL> startup ORACLE instance started. Total System Global Area 97588504 bytes Fixed Size 451864 bytes Variable Size 33554432 bytes Database Buffers 62914560 bytes Redo Buffers 667648 bytes Database mounted. Database opened. SQL> select count(*) from t; select count(*) from t * ERROR at line 1: ORA-00942: table or view does not exist |
Wed Oct 19 20:38:38 2005 Beginning crash recovery of 1 threads Wed Oct 19 20:38:38 2005 Started first pass scan Wed Oct 19 20:38:39 2005 Completed first pass scan 0 redo blocks read, 0 data blocks need recovery Wed Oct 19 20:38:39 2005 Started recovery at Thread 1: logseq 2, block 201, scn 0.897632464 Recovery of Online Redo Log: Thread 1 Group 1 Seq 2 Reading mem 0 Mem# 0 errs 0: /opt/oracle/oradata/conner/redo01.log Wed Oct 19 20:38:39 2005 Completed redo application Wed Oct 19 20:38:39 2005 Ended recovery at Thread 1: logseq 2, block 201, scn 0.897652465 0 data blocks read, 0 data blocks written, 0 redo blocks read Crash recovery completed successfully |
如果您非常迫切的想了解IT领域最新产品与技术信息,那么订阅至顶网技术邮件将是您的最佳途径之一。
现场直击|2021世界人工智能大会
直击5G创新地带,就在2021MWC上海
5G已至 转型当时——服务提供商如何把握转型的绝佳时机
寻找自己的Flag
华为开发者大会2020(Cloud)- 科技行者