rac11204开归档

SQL> archive log list
Database log mode              No Archive Mode
Automatic archival             Disabled
Archive destination            /oracle/app/oracle/product/11.2.0/db_1/dbs/arch
Oldest online log sequence     5
Current log sequence           6

SQL> select name from v$datafile;

NAME
--------------------------------------------------------------------------------
+DATA/orcl/system01.dbf
+DATA/orcl/sysaux01.dbf
+DATA/orcl/undotbs01.dbf
+DATA/orcl/users01.dbf
+DATA/orcl/undotbs02.dbf
+DATA/orcl/ant_1.dbf

6 rows selected.

2个节点都mount

SQL> shutdown immediate
Database closed.
Database dismounted.
ORACLE instance shut down.
SQL> alter database archivelog;
alter database archivelog
*
ERROR at line 1:
ORA-01034: ORACLE not available
Process ID: 4902
Session ID: 48 Serial number: 17

SQL> startup mount
ORACLE instance started.

Total System Global Area  521936896 bytes
Fixed Size                  2254824 bytes
Variable Size             406849560 bytes
Database Buffers          109051904 bytes
Redo Buffers                3780608 bytes
Database mounted.
SQL> alter database archivelog;

Database altered.

SQL> startup
ORA-01081: cannot start already-running ORACLE - shut it down first

2个节点改
SQL> alter database open;

Database altered.

SQL> archive log list
Database log mode              Archive Mode
Automatic archival             Enabled
Archive destination            /oracle/app/oracle/product/11.2.0/db_1/dbs/arch
Oldest online log sequence     5
Next log sequence to archive   6
Current log sequence           6


切一下

SQL> alter system archive log current;

System altered.

SQL> /

System altered.

SQL> /

但是
[oracle@rac1 ~]$ cd /oracle/app/oracle/product/11.2.0/db_1/dbs/arch
-bash: cd: /oracle/app/oracle/product/11.2.0/db_1/dbs/arch: No such file or directory

看了一下，在这：
[grid@rac1 ~]$ cd /oracle/app/oracle/product/11.2.0/db_1/dbs/
[grid@rac1 dbs]$ ls -rtl
total 26280
-rw-r--r-- 1 oracle oinstall     2851 May 15  2009 init.ora
-rw-r----- 1 oracle oinstall     1536 Dec 25 16:54 orapworcl1
-rw-r----- 1 oracle oinstall       35 Dec 25 17:07 initorcl1.ora
-rw-rw---- 1 oracle dba          1544 Jan  4 13:56 hc_orcl1.dat
-rw-r----- 1 oracle dba      26867712 Jan  4 13:58 arch1_6_899397846.dbf
-rw-r----- 1 oracle dba          4608 Jan  4 14:01 arch1_7_899397846.dbf
-rw-r----- 1 oracle dba          7168 Jan  4 14:02 arch1_8_899397846.dbf
-rw-r----- 1 oracle dba          2048 Jan  4 14:02 arch1_9_899397846.dbf
-rw-r----- 1 oracle dba          1024 Jan  4 14:02 arch1_10_899397846.dbf
[grid@rac1 dbs]$

敢快布删除脚本吧