SQL> SELECT log_mode
2 FROM V$DATABASE;
LOG_MODE
------------
NOARCHIVELOG
SQL> SHUTDOWN IMMEDIATE;
Database closed.
Database dismounted.
ORACLE instance shut down.
SQL> STARTUP MOUNT;
ORACLE instance started.
Total System Global Area 598437888 bytes
Fixed Size 1338140 bytes
Variable Size 360711396 bytes
Database Buffers 230686720 bytes
Redo Buffers 5701632 bytes
Database mounted.
SQL> ALTER DATABASE ARCHIVELOG;
Database altered.
SQL> ALTER DATABASE OPEN;
Database altered.
SQL> SELECT log_mode
2 FROM V$DATABASE;
LOG_MODE
------------
ARCHIVELOG
来自 “ ITPUB博客 ” ,链接:http://blog.itpub.net/28212711/viewspace-767809/,如需转载,请注明出处,否则将追究法律责任。
转载于:http://blog.itpub.net/28212711/viewspace-767809/