Oracle数据库归档模式的查询和开启以及关闭
SQL> startup
ORACLE instance started.
Total System Global Area 776646656 bytes
Fixed Size 2257272 bytes
Variable Size 511708808 bytes
Database Buffers 255852544 bytes
Redo Buffers 6828032 bytes
Database mounted.
Database opened.
SQL> archive log list; -----查询是否归档模式
Database log mode No Archive Mode
Automatic archival Disabled
Archive destination USE_DB_RECOVERY_FILE_DEST
Oldest online log sequence 7
Current log sequence 9
SQL> select name,log_mode from v$database; -----查询是否归档模式
NAME LOG_MODE
------------------------------------------------------------ ------------
DB01 NOARCHIVELOG
Elapsed: 00:00:00.01
SQL> shutdown immediate -------关闭数据库
Database closed.
Database dismounted.
ORACLE instance shut down.
SQL> startup mount ---------启动到mount状态
ORACLE instance started.
Total System Global Area 776646656 bytes
Fixed Size 2257272 bytes
Variable Size 511708808 bytes
Database Buffers 255852544 bytes
Redo Buffers 6828032 bytes
Database mounted.
SQL> alter database archivelog; ---------打开归档
Database altered.
Elapsed: 00:00:00.01
SQL> alter database open; -------打开数据库
Database altered.
Elapsed: 00:00:01.84
SQL> archive log list; ---------查询归档状态
Database log mode Archive Mode
Automatic archival Enabled
Archive destination USE_DB_RECOVERY_FILE_DEST
Oldest online log sequence 7
Next log sequence to archive 9
Current log sequence 9
SQL> select name,log_mode from v$database; ---------查询归档状态
NAME LOG_MODE
------------------------------------------------------------ ------------
DB01 ARCHIVELOG
Elapsed: 00:00:00.01
SQL> shutdown immediate ------关闭数据库
Database closed.
Database dismounted.
ORACLE instance shut down.
SQL> startup mount; ------启动到mount状态
ORACLE instance started.
Total System Global Area 776646656 bytes
Fixed Size 2257272 bytes
Variable Size 511708808 bytes
Database Buffers 255852544 bytes
Redo Buffers 6828032 bytes
Database mounted.
SQL> alter database noarchivelog; --------关闭归档模式
Database altered.
Elapsed: 00:00:00.00
SQL> alter database open; ------打开数据库
Database altered.
Elapsed: 00:00:00.82
SQL> archive log list; ----归档模式确认
Database log mode No Archive Mode
Automatic archival Disabled
Archive destination USE_DB_RECOVERY_FILE_DEST
Oldest online log sequence 7
Current log sequence 9
SQL>
沙发空闲中,快来抢!