将一个数据库修改成归档状态如下操作
在initSID.ora中加如下面的内容
log_archive_dest='/archivelog'
log_archive_max_processes=8
log_archive_start=TRUE
log_buffer=4000000
db1@root[/oracle>]sqlplus '/as sysdba'
SQL*Plus: Release 9.2.0.6.0 - Production on Tue May 27 20:19:44 2008
Copyright (c) 1982, 2002, Oracle Corporation. All rights reserved.
Connected to:
Oracle9i Enterprise Edition Release 9.2.0.6.0 - 64bit Production
With the Partitioning, OLAP and Oracle Data Mining options
JServer Release 9.2.0.6.0 - Production
SQL> shutdown immediate
Database closed.
Database dismounted.
ORACLE instance shut down.
SQL> startup mount
ORACLE instance started.
Total System Global Area 3830225408 bytes
Fixed Size 748032 bytes
Variable Size 671088640 bytes
Database Buffers 3154116608 bytes
Redo Buffers 4272128 bytes
Database mounted.
SQL> archive log list
Database log mode No Archive Mode
Automatic archival Enabled
Archive destination /archivelog
Oldest online log sequence 12058
Current log sequence 12063
SQL> alter database archivelog;
Database altered.
SQL> alter database open;
Database altered.
SQL> alter system switch logfile;
System altered.
阅读(1105) | 评论(0) | 转发(0) |