启用ORACLE9I数据库的归档模式（ARCHIVELOG）

 

启用ORACLE9I数据库的归档模式（ARCHIVELOG）

# su - oracle
$ sqlplus '/as sysdba'

SQL*Plus: Release 9.2.0.4.0 - Production on Tue Jun 16 21:52:06 2010

Copyright (c) 1982, 2002, Oracle Corporation.  All rights reserved.

Connected to:
Oracle9i Enterprise Edition Release 9.2.0.4.0 - 64bit Production
With the Partitioning, OLAP and Oracle Data Mining options
JServer Release 9.2.0.4.0 - Production

SQL> archive log list;
Database log mode              No Archive Mode
Automatic archival             Disabled
Archive destination            /home/oracle/app/oracle/product/920/dbs/arch
Oldest online log sequence     10980
Current log sequence           10982
SQL> shutdown immediate
Database closed.
Database dismounted.
ORACLE instance shut down.
SQL> startup mount;
ORACLE instance started.

Total System Global Area 2099220552 bytes
Fixed Size                   745544 bytes
Variable Size            1560281088 bytes
Database Buffers          536870912 bytes
Redo Buffers                1323008 bytes
Database mounted.
SQL> alter database archivelog;

Database altered.

SQL> show parameter spfile;

NAME                                 TYPE        VALUE
------------------------------------ ----------- ------------------------------
spfile                               string      /u01/oradata/admin/dbs/spfileo
                                                 racle8.ora
SQL> show parameter log_archive_start;

NAME                                 TYPE        VALUE
------------------------------------ ----------- ------------------------------
log_archive_start                    boolean     FALSE
SQL> alter system set log_archive_start=true scope=spfile;

System altered.

SQL> show parameter log_archive_start;

NAME                                 TYPE        VALUE
------------------------------------ ----------- ------------------------------
log_archive_start                    boolean     FALSE
SQL> alter database open;

Database altered.

SQL> show parameter log_archive_start;

NAME                                 TYPE        VALUE
------------------------------------ ----------- ------------------------------
log_archive_start                    boolean     FALSE
SQL> shutdown immediate
Database closed.
Database dismounted.
ORACLE instance shut down.
SQL> startup
ORACLE instance started.

Total System Global Area 2099220552 bytes
Fixed Size                   745544 bytes
Variable Size            1560281088 bytes
Database Buffers          536870912 bytes
Redo Buffers                1323008 bytes
Database mounted.
Database opened.
SQL> show parameter log_archive_start;

NAME                                 TYPE        VALUE
------------------------------------ ----------- ------------------------------
log_archive_start                    boolean     TRUE
SQL> archive log list;
Database log mode              Archive Mode
Automatic archival             Enabled
Archive destination            /home/oracle/app/oracle/product/920/dbs/arch
Oldest online log sequence     10980
Next log sequence to archive   10982
Current log sequence           10982

 

来自 “ ITPUB博客 ” ，链接：http://blog.itpub.net/8183550/viewspace-663792/，如需转载，请注明出处，否则将追究法律责任。

转载于:http://blog.itpub.net/8183550/viewspace-663792/