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.

database log mode              archive mode

automatic archival             enabled

next log sequence to archive   230

current log sequence  

6.启动数据库

sql> alter database open;

database altered

.关闭归档模式

oracle instance shut down.

sql> alter database noarchivelog;

sql>