[Oracle@ORA9ISERV arch]$
SQL>
System altered.
SQL> show parameter log_archive_dest_1
NAME TYPE VALUE
------------------------------------ ---------------------- -------
log_archive_dest_1 string
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>
no rows selected
SQL> archive log list
Database log mode Archive Mode
Automatic archival
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参数文件,设置
SQL> create pfile from spfile;
File created.
*.log_archive_dest_1='LOCATION=/u01/app/oracle/oradata/orcl/arch'
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
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>
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