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

最新推荐文章于 2018-11-06 21:48:50 发布

cjllyl654321

最新推荐文章于 2018-11-06 21:48:50 发布

阅读量108

点赞数

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的归档文件也产生了.

来自 “ ITPUB博客 ” ，链接：http://blog.itpub.net/26937943/viewspace-1810125/，如需转载，请注明出处，否则将追究法律责任。

转载于:http://blog.itpub.net/26937943/viewspace-1810125/