Oracle数据库开启关闭归档

数据库开启归档模式
步骤如下：
[oracle@10g admin]$sqlplus / as sysdba
SQL>alter user sys identified by sys; 忘记密码修改密码，
database altered
SQL> conn sys/sys as sysdba
Connected.
SQL> show user
USER is “SYS”

1、查看数据库是否开启归档
SQL> select name,log_mode from v$database;

NAME LOG_MODE

---

ORCL NOARCHIVELOG

SQL> archive log list
Database log mode No Archive Mode
Automatic archival Disabled
Archive destination USE_DB_RECOVERY_FILE_DEST
Oldest online log sequence 29
Current log sequence 31

2、#修改系统的日志存储方式为归档模式：
SQL> alter system set log_archive_start=true scope=spfile;

System 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 29
Current log sequence 31

关闭数据库；
SQL> shutdown immediate;
Database closed.
Database dismounted.
ORACLE instance shut down.

3、Oracle数据库开启归档，需要在mount模式下。
SQL> startup mount;
ORA-32004: obsolete and/or deprecated parameter(s) specified
ORACLE instance started.

Total System Global Area 599785472 bytes
Fixed Size 2022600 bytes
Variable Size 260047672 bytes
Database Buffers 331350016 bytes
Redo Buffers 6365184 bytes
Database mounted.

4、使数据库置于归档模式。
SQL> alter database archivelog;

Database altered.

SQL> archve log list;
SP2-0734: unknown command beginning “archve log…” - rest of line ignored.
SQL> archive log list;
Database log mode Archive Mode
Automatic archival Enabled
Archive destination USE_DB_RECOVERY_FILE_DEST
Oldest online log sequence 29
Next log sequence to archive 31
Current log sequence 31

打开数据库
SQL> alter database open;

Database altered.

SQL> select instance_name,status from v$instance;

INSTANCE_NAME STATUS

---

orcl OPEN

关闭数据库的归档：

SQL> shutdown immediate;
sDatabase closed.
Database dismounted.
ORACLE instance shut down.
SQL> startup mount;
ORA-32004: obsolete and/or deprecated parameter(s) specified
ORACLE instance started.

Total System Global Area 599785472 bytes
Fixed Size 2022600 bytes
Variable Size 260047672 bytes
Database Buffers 331350016 bytes
Redo Buffers 6365184 bytes
Database mounted.
SQL> archive log list;
Database log mode Archive Mode
Automatic archival Enabled
Archive destination USE_DB_RECOVERY_FILE_DEST
Oldest online log sequence 29
Next log sequence to archive 31
Current log sequence 31
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 29
Current log sequence 31
SQL> alter database open;

Database altered.

SQL> select status from v$instance;

STATUS

OPEN

完毕