log_archive_local_first boolean TRUE
log_archive_max_processes integer 2
log_archive_min_succeed_dest integer 1
log_archive_start boolean TRUE
log_archive_trace integer
SQL> alter database archivelog;
SQL> archive log list;
+ARCHLOG
86
88
88
SQL> alter database open;
SQL> col instance_name a30
SP2-0158: COLUMN "a30"
SQL> col inst_name for a30
SQL> select * from v$active_instances;
INST_NUMBER INST_NAME
----------- ------------------------------
1 node1:MYRAC1
SQL> alter session set nls_language=american;
Session altered.
先把原来的AMSCMD里的删除
SQL> create spfile='+DATA/MyRAC/spfileMYRAC.ora' from pfile;
File created.
SQL> startup
ORA-01565: error in identifying file '+DATA/MYRAC/spfileMYRAC.ora'
ORA-17503: ksfdopn:2 Failed to open file +DATA/MYRAC/spfileMYRAC.ora
ORA-01000: maximum open cursors exceeded
[oracle@node1 oracle]$ cat pfile_01.ora
*.SPFILE='+DATA/MYRAC/spfileMYRAC.ora'
删除SPFILE 重新创建并且修改语言到英文环境 SSH客户端没地方设置
SQL> create spfile='+data/myrac/spfileMYRAC.ora' from pfile='/opt/oracle/database/admin/MYRAC/pfile/myrac1_pfile.ora';
File created.
指定SPFILE目录和指定PFILE
结果节点2成功启动了SPFILE, 反而节点1的SPFILE 定位在本地目录上
SQL> startup nomount
ORACLE instance started.
Total System Global Area 167772160 bytes
Fixed Size 1218316 bytes
Variable Size 100665588 bytes
Database Buffers 62914560 bytes
Redo Buffers 2973696 bytes
SQL> show parameter pfile
NAME TYPE VALUE
------------------------------------ ----------- ------------------------------
spfile string /opt/oracle/database/product/1
0.2.0/db_1/dbs/spfileMYRAC1.or
a
经过几番折腾把本地SPFILE移走到其他目录下终于启动了共享磁盘上的SPFILE文件
[oracle@node1 dbs]$ mv spfileMYRAC1.ora /opt/oracle/database
[oracle@node1 dbs]$ exit
关闭先前的实例
SQL> shutdown immediate;
ORA-01507: database not mounted
ORACLE instance shut down.
启动内存模式
SQL> startup nomount
ORACLE instance started.
Total System Global Area 167772160 bytes
Fixed Size 1218316 bytes
Variable Size 100665588 bytes
Database Buffers 62914560 bytes
Redo Buffers 2973696 bytes
查看spfile路径发现正确用到了共享磁盘上的
SQL> show parameter pfile
NAME TYPE VALUE
------------------------------------ ----------- ------------------------------
spfile string +DATA/myrac/spfilemyrac.ora
加载控制文件
SQL> alter database mount
2 ;
Database altered.
打开数据库
SQL> alter database open;
Database altered.
查看是否归档
SQL> archive log list
Database log mode Archive Mode
Automatic archival Enabled
Archive destination +ARCHLOG
Oldest online log sequence 87
Next log sequence to archive 89
Current log sequence 89
节点1 交换日志
SQL> alter system switch logfile;
System altered
自动生成多级目录
ASMCMD> pwd
+archlog/myrac/archivelog/2012_09_27
ASMCMD> ls
thread_1_seq_88.256.795093263
thread_1_seq_89.257.795108837.
节点直接启动开启数据库模式
并且查看归档
节点2 交换下日志
SQL> alter s