11g RAC 更改归档模式 ASM
本实验有两个节点bike01,bike02
oracle_sid 分别是 bikes1,bikes2
1.在节点1 bike01上执行
[root@bike01 ~]# su - grid
[grid@bike01 ~]$ sqlplus / as sysasm
SQL> select name from v$asm_diskgroup;
NAME
------------------------------
DATA
OCR
SQL> alter diskgroup data add directory '+DATA/ARC1';
Diskgroup altered.
2.在节点2 bike02上执行
[root@bike01 ~]# su - grid
[grid@bike01 ~]$ sqlplus / as sysasm
SQL> select name from v$asm_diskgroup;
NAME
------------------------------
DATA
OCR
SQL> alter diskgroup data add directory '+DATA/ARC2';
Diskgroup altered.
执行完成后,退出ASM实例
3.在bike01上执行
[grid@bike01 ~]$ su - oracle
[oracle@bike01 ~]$ sqlplus / as sysdba
SQL> SELECT INSTANCE_NAME FROM V$INSTANCE;
INSTANCE_NAME
----------------
bikes1
SQL> ALTER SYSTEM SET LOG_ARCHIVE_DEST_1='LOCATION=+DATA/ARC1' SCOPE=SPFILE SID='bikes1';
System altered.
SQL> ALTER SYSTEM SET LOG_ARCHIVE_DEST_1='LOCATION=+DATA/ARC2' SCOPE=SPFILE SID='bikes2';
System altered.
4.关掉所有节点实例bikes1,bikes2服务
节点bike01上执行
SQL> SHUTDOWN IMMEDIATE
节点bike02上执行
SQL> SHUTDOWN IMMEDIATE
5.更改归档模式
节点bike01上执行
SQL> STARTUP MOUNT
SQL>ALTER DATABASE ARCHIVELOG;
Database altered.
SQL> archive log list
archive log list
Database log mode Archive Mode
Automatic archival Enabled
Archive destination +DATA/arc1
Oldest online log sequence 255
Next log sequence to archive 256
Current log sequence 256
节点bike01已经更改成功
节点bike02上执行
SQL> STARTUP MOUNT
SQL>ALTER DATABASE ARCHIVELOG;
Database altered.
SQL> archive log list
archive log list
Database log mode Archive Mode
Automatic archival Enabled
Archive destination +DATA/arc2
Oldest online log sequence 255
Next log sequence to archive 256
Current log sequence 256
6.打开数据库
节点bike01,bike02上分别执行
SQL> alter database open
7.验证归档文件
节点bike01上执行
SQL> alter system switch logfile;
System altered.
[oracle@bike01 ~]$ su - grid
[grid@bike01 ~]$ asmcmd
ASMCMD> ls
DATA/
OCR/
ASMCMD> cd DATA
ASMCMD> cd arc1
ASMCMD> ls
1_256_784611206.dbf
本实验有两个节点bike01,bike02
oracle_sid 分别是 bikes1,bikes2
1.在节点1 bike01上执行
[root@bike01 ~]# su - grid
[grid@bike01 ~]$ sqlplus / as sysasm
SQL> select name from v$asm_diskgroup;
NAME
------------------------------
DATA
OCR
SQL> alter diskgroup data add directory '+DATA/ARC1';
Diskgroup altered.
2.在节点2 bike02上执行
[root@bike01 ~]# su - grid
[grid@bike01 ~]$ sqlplus / as sysasm
SQL> select name from v$asm_diskgroup;
NAME
------------------------------
DATA
OCR
SQL> alter diskgroup data add directory '+DATA/ARC2';
Diskgroup altered.
执行完成后,退出ASM实例
3.在bike01上执行
[grid@bike01 ~]$ su - oracle
[oracle@bike01 ~]$ sqlplus / as sysdba
SQL> SELECT INSTANCE_NAME FROM V$INSTANCE;
INSTANCE_NAME
----------------
bikes1
SQL> ALTER SYSTEM SET LOG_ARCHIVE_DEST_1='LOCATION=+DATA/ARC1' SCOPE=SPFILE SID='bikes1';
System altered.
SQL> ALTER SYSTEM SET LOG_ARCHIVE_DEST_1='LOCATION=+DATA/ARC2' SCOPE=SPFILE SID='bikes2';
System altered.
4.关掉所有节点实例bikes1,bikes2服务
节点bike01上执行
SQL> SHUTDOWN IMMEDIATE
节点bike02上执行
SQL> SHUTDOWN IMMEDIATE
5.更改归档模式
节点bike01上执行
SQL> STARTUP MOUNT
SQL>ALTER DATABASE ARCHIVELOG;
Database altered.
SQL> archive log list
archive log list
Database log mode Archive Mode
Automatic archival Enabled
Archive destination +DATA/arc1
Oldest online log sequence 255
Next log sequence to archive 256
Current log sequence 256
节点bike01已经更改成功
节点bike02上执行
SQL> STARTUP MOUNT
SQL>ALTER DATABASE ARCHIVELOG;
Database altered.
SQL> archive log list
archive log list
Database log mode Archive Mode
Automatic archival Enabled
Archive destination +DATA/arc2
Oldest online log sequence 255
Next log sequence to archive 256
Current log sequence 256
6.打开数据库
节点bike01,bike02上分别执行
SQL> alter database open
7.验证归档文件
节点bike01上执行
SQL> alter system switch logfile;
System altered.
[oracle@bike01 ~]$ su - grid
[grid@bike01 ~]$ asmcmd
ASMCMD> ls
DATA/
OCR/
ASMCMD> cd DATA
ASMCMD> cd arc1
ASMCMD> ls
1_256_784611206.dbf