RAC环境中非归档改为归档模式

最新推荐文章于 2019-03-13 10:43:03 发布

sky850623

最新推荐文章于 2019-03-13 10:43:03 发布

阅读量351

点赞数

分类专栏： RAC

本文链接：https://blog.csdn.net/lovejava5/article/details/49077553

版权

RAC 专栏收录该内容

1 篇文章

订阅专栏

1.数据库启动到mount状态

[oracle@rac1 orafra]$ crs_stat -t -v

Name Type R/RA F/FT Target State Host

----------------------------------------------------------------------

ora....C1.lsnr application 0/5 0/0 ONLINE ONLINE rac1

ora.rac1.gsd application 0/5 0/0 ONLINE ONLINE rac1

ora.rac1.ons application 0/3 0/0 ONLINE ONLINE rac1

ora.rac1.vip application 0/0 0/0 ONLINE ONLINE rac1

ora....C2.lsnr application 0/5 0/0 ONLINE ONLINE rac2

ora.rac2.gsd application 0/5 0/0 ONLINE ONLINE rac2

ora.rac2.ons application 0/3 0/0 ONLINE ONLINE rac2

ora.rac2.vip application 0/0 0/0 ONLINE ONLINE rac2

ora.racdb.db application 0/1 0/1 ONLINE ONLINE rac2

ora....b1.inst application 0/5 0/0 ONLINE ONLINE rac1

ora....b2.inst application 0/5 0/0 ONLINE ONLINE rac2

[oracle@rac1 orafra]$ srvctl stop database -d racdb --关闭数据库

[oracle@rac1 orafra]$ crs_stat -t -v

Name Type R/RA F/FT Target State Host

----------------------------------------------------------------------

ora....C1.lsnr application 0/5 0/0 ONLINE ONLINE rac1

ora.rac1.gsd application 0/5 0/0 ONLINE ONLINE rac1

ora.rac1.ons application 0/3 0/0 ONLINE ONLINE rac1

ora.rac1.vip application 0/0 0/0 ONLINE ONLINE rac1

ora....C2.lsnr application 0/5 0/0 ONLINE ONLINE rac2

ora.rac2.gsd application 0/5 0/0 ONLINE ONLINE rac2

ora.rac2.ons application 0/3 0/0 ONLINE ONLINE rac2

ora.rac2.vip application 0/0 0/0 ONLINE ONLINE rac2

ora.racdb.db application 0/1 0/1 OFFLINE OFFLINE

ora....b1.inst application 0/5 0/0 OFFLINE OFFLINE

ora....b2.inst application 0/5 0/0 OFFLINE OFFLINE

[oracle@rac1 orafra]$ srvctl start instance -d racdb -i racdb1 -o mount --实例1启动到mount状态

[oracle@rac1 orafra]$ crs_stat -t -v

Name Type R/RA F/FT Target State Host

----------------------------------------------------------------------

ora....C1.lsnr application 0/5 0/0 ONLINE ONLINE rac1

ora.rac1.gsd application 0/5 0/0 ONLINE ONLINE rac1

ora.rac1.ons application 0/3 0/0 ONLINE ONLINE rac1

ora.rac1.vip application 0/0 0/0 ONLINE ONLINE rac1

ora....C2.lsnr application 0/5 0/0 ONLINE ONLINE rac2

ora.rac2.gsd application 0/5 0/0 ONLINE ONLINE rac2

ora.rac2.ons application 0/3 0/0 ONLINE ONLINE rac2

ora.rac2.vip application 0/0 0/0 ONLINE ONLINE rac2

ora.racdb.db application 0/1 0/1 OFFLINE OFFLINE

ora....b1.inst application 0/5 0/0 ONLINE ONLINE rac1

ora....b2.inst application 0/5 0/0 OFFLINE OFFLINE

2.连接到实例1

SQL> select instance_name from v$instance;

INSTANCE_NAME

----------------

racdb1

SQL> select status from v$instance; --mount状态

STATUS

------------

MOUNTED

SQL> alter database archivelog; --改为归档模式

Database altered.

3.打开数据库

[oracle@rac1 orafra]$ srvctl stop instance -d racdb -i racdb1 --关闭节点1

[oracle@rac1 orafra]$ crs_stat -t -v

Name Type R/RA F/FT Target State Host

----------------------------------------------------------------------

ora....C1.lsnr application 0/5 0/0 ONLINE ONLINE rac1

ora.rac1.gsd application 0/5 0/0 ONLINE ONLINE rac1

ora.rac1.ons application 0/3 0/0 ONLINE ONLINE rac1

ora.rac1.vip application 0/0 0/0 ONLINE ONLINE rac1

ora....C2.lsnr application 0/5 0/0 ONLINE ONLINE rac2

ora.rac2.gsd application 0/5 0/0 ONLINE ONLINE rac2

ora.rac2.ons application 0/3 0/0 ONLINE ONLINE rac2

ora.rac2.vip application 0/0 0/0 ONLINE ONLINE rac2

ora.racdb.db application 0/1 0/1 OFFLINE OFFLINE

ora....b1.inst application 0/5 0/0 OFFLINE OFFLINE

ora....b2.inst application 0/5 0/0 OFFLINE OFFLINE

[oracle@rac1 orafra]$ srvctl start database -d racdb --打开数据库

实例2也改为了归档模式

4.查看归档情况

SQL> archive log list

Database log mode Archive Mode

Automatic archival Enabled

Archive destination USE_DB_RECOVERY_FILE_DEST

Oldest online log sequence 23

Next log sequence to archive 24

Current log sequence 24

SQL> show parameter db_re

NAME TYPE VALUE

------------------------------------ ----------- ------------------------------

db_recovery_file_dest string /u02/orafra

db_recovery_file_dest_size big integer 2G

[oracle@rac1 orafra]$ ll --现在还没有归档文件

total 4

drwxrwxr-x 2 oracle oinstall 4096 Sep 23 05:03 lost+found

--切换下归档文件

SQL> alter system switch logfile;

System altered.

--再查看下

[oracle@rac1 orafra]$ ll

total 8

drwxrwxr-x 2 oracle oinstall 4096 Sep 23 05:03 lost+found

drwxrwx--- 3 oracle oinstall 4096 Sep 26 10:21 RACDB

[oracle@rac1 2015_09_26]$ ll

total 35914

-rw-rw---- 1 oracle oinstall 36775936 Sep 26 10:21 o1_mf_1_24_c0d09vdk_.arc --产生了日志文件

在实例2上也切换下日志文件

SQL> select instance_name from v$instance;

INSTANCE_NAME

----------------

racdb2

SQL> alter system switch logfile;

System altered.

[oracle@rac1 2015_09_26]$ ll

total 39563

-rw-rw---- 1 oracle oinstall 36775936 Sep 26 10:21 o1_mf_1_24_c0d09vdk_.arc

-rw-rw---- 1 oracle oinstall 3736064 Sep 26 10:23 o1_mf_2_3_c0d0f5vb_.arc

实例2的归档文件也产生了.