oracle开启/关闭archlog

前端之家收集整理的这篇文章主要介绍了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>

猜你在找的Oracle相关文章