oracle开启/关闭archlog

.管理员身份连接数据库

SQL> archive log list;

Database log mode No Archive Mode

Automatic archival Disabled

Archive destination USE_DB_RECOVERY_FILE_DEST

Oldest online log sequence 228

Current log sequence 230

3.关闭数据库

SQL> shutdown immediate;

Database closed.

Database dismounted.

ORACLE instance shut down

启动数据库到mount状态

SQL> startup mount;

ORACLE instance started.

Total System Global Area 3423965184 bytes

Fixed Size 2180544 bytes

Variable Size 2013268544 bytes

Database Buffers 1392508928 bytes

Redo Buffers 16007168 bytes

Database mounted.

5.启动归档模式

SQL> alter database archivelog;

Database altered.

SQL> archive log list;

Database log mode Archive Mode

Automatic archival Enabled

Archive destination USE_DB_RECOVERY_FILE_DEST

Oldest online log sequence 228

Next log sequence to archive 230

Current log sequence

6.启动数据库

SQL> alter database open;

Database altered

.关闭归档模式

SQL> shutdown immediate;

Database closed.

Database dismounted.

ORACLE instance shut down.

SQL> startup mount;

ORACLE instance started.

Total System Global Area 3423965184 bytes

Fixed Size 2180544 bytes

Variable Size 2013268544 bytes

Database Buffers 1392508928 bytes

Redo Buffers 16007168 bytes

Database mounted.

SQL> alter database noarchivelog;

Database altered.

SQL> archive log list;

Database log mode No Archive Mode

Automatic archival Disabled

Archive destination USE_DB_RECOVERY_FILE_DEST

Oldest online log sequence 228

Current log sequence 230

SQL>

（编辑：李大同）

【声明】本站内容均来自网络，其相关言论仅代表作者个人观点，不代表本站立场。若无意侵犯到您的权利，请及时与联系站长删除相关内容!