Oracle 9i 非归档模式到归档模式设置一例
Oracle 9i 非归档模式到归档模式设置一例
创建归档目录:
[Oracle@ORA9ISERV arch]$ mkdir -p /u01/app/oracle/oradata/orcl/arch
设置log_archive_dest_1参数:
SQL> alter system set log_archive_dest_1='LOCATION=/u01/app/oracle/oradata/orcl/arch' scope=both;
System altered.
查看log_archive_dest_1设置:
SQL> show parameter log_archive_dest_1
NAME TYPE VALUE
------------------------------------ ---------------------- -------
log_archive_dest_1 string LOCATION=/u01/app/oracle/orada
ta/orcl/arch
SQL> show parameter log_archive_dest_state_1
NAME TYPE VALUE
------------------------------------ ---------------------- -------
log_archive_dest_state_1 string enable
切换日志:
SQL> alter system switch logfile;
System altered.
SQL> select sequence#,dest_id,archived,applied,deleted, status,first_time from v$archived_log order by sequence#;
no rows selected
观察并没有产生归档。
查看数据库归档模式:
SQL> archive log list
Database log mode Archive Mode
Automatic archival Disabled --不解
Archive destination /u01/app/oracle/oradata/orcl/arch
Oldest online log sequence 4
Next log sequence to archive 4
Current log sequence 6
Google:修改pfile参数文件,设置log_archive_start='TRUE'
SQL> create pfile from spfile;
File created.
添加:log_archive_start='TRUE'
*.log_archive_dest_1='LOCATION=/u01/app/oracle/oradata/orcl/arch'
log_archive_start='TRUE'
SQL> create spfile from pfile;
File created.
重启数据库:
SQL> startup
ORACLE instance started.
Total System Global Area 738793148 bytes
Fixed Size 452284 bytes
Variable Size 335544320 bytes
Database Buffers 402653184 bytes
Redo Buffers 143360 bytes
Database mounted.
Database opened.
查看数据库归档模式:
SQL> archive log list
Database log mode Archive Mode
Automatic archival Enabled
Archive destination /u01/app/oracle/oradata/orcl/arch
Oldest online log sequence 4
Next log sequence to archive 6
Current log sequence 6
切换日志:
SQL> alter system switch logfile;
System altered.
SQL> select sequence#,dest_id,archived,applied,deleted, status,first_time from v$archived_log order by sequence#;
SEQUENCE# DEST_ID ARCHIV APPLIE DELETE ST FIRST_TIM
---------- ---------- ------ ------ ------ -- ---------
4 1 YES NO NO A 19-APR-11
5 1 YES NO NO A 19-APR-11
6 1 YES NO NO A 19-APR-11
7 1 YES NO NO A 19-APR-11
归档已经产生。
查看归档目录是否有归档文件产生:
[oracle@ORA9ISERV arch]$ pwd
/u01/app/oracle/oradata/orcl/arch
[oracle@ORA9ISERV arch]$ ls -l
total 1124
-rw-r----- 1 oracle oinstall 278528 Apr 19 13:37 1_4.dbf
-rw-r----- 1 oracle oinstall 31232 Apr 19 13:37 1_5.dbf
-rw-r----- 1 oracle oinstall 585728 Apr 19 13:38 1_6.dbf
-rw-r----- 1 oracle oinstall 225280 Apr 19 13:42 1_7.dbf
一切正常,完毕。
评论暂时关闭