RAC环境下节点归档目的地相互独立的配置和备份要求

最新推荐文章于 2021-04-09 10:53:54 发布
最新推荐文章于 2021-04-09 10:53:54 发布
阅读量202 收藏
点赞数
文章标签： 数据库 操作系统

一.测试环境。
1.Oracle RAC Database版本。

select * from v$version;

BANNER
--------------------------------------------------------------------------------
Oracle Database 10g Enterprise Edition Release 10.2.0.5.0 - 64bi
PL/SQL Release 10.2.0.5.0 - Production
CORE 10.2.0.5.0 Production
TNS for Linux: Version 10.2.0.5.0 - Production
NLSRTL Version 10.2.0.5.0 - Production

2.log_archive_dest_1参数设置。
1).第一个节点：
SQL> show parameter log_archive_dest_1

NAME     TYPE
------------------------------------ ----------------------
VALUE
------------------------------
log_archive_dest_1     string
LOCATION=/arch1
log_archive_dest_10     string


2).第二个节点：
SQL> show parameter log_archive_dest_1

NAME     TYPE
------------------------------------ ----------------------
VALUE
------------------------------
log_archive_dest_1     string
LOCATION=/arch2
log_archive_dest_10     string

3.备份目的地。
1).第一个节点：
[oracle@linux ~]$ cd /
[oracle@linux /]$ ls -ald rmanbak
drwxr-xr-x 2 oracle oinstall 4096 Aug 11 05:07 rmanbak/

2).第二个节点：
[oracle@linux2 ~]$ cd /
[oracle@linux2 /]$ ls -ald rmanbak
ls: rmanbak: No such file or directory

第二个节点不存在/rmanbak备份目的地。

二.测试过程。
1).在节点1执行归档交叉检查。
[oracle@linux /]$ rman target /

Recovery Manager: Release 10.2.0.5.0 - Production on Sun Aug 11 05:14:59 2013

Copyright (c) 1982, 2007, Oracle.  All rights reserved.

connected to target database: ORCL (DBID=1350843573)

RMAN> crosscheck archivelog all;

using target database control file instead of recovery catalog
allocated channel: ORA_DISK_1
channel ORA_DISK_1: sid=128 instance=orcl1 devtype=DISK
validation succeeded for archived log
archive log filename=/arch1/1_7_823148545.dbf recid=26 stamp=823151383
validation succeeded for archived log
archive log filename=/arch1/1_8_823148545.dbf recid=31 stamp=823151395
validation succeeded for archived log
archive log filename=/arch1/1_9_823148545.dbf recid=33 stamp=823151446
validation succeeded for archived log
archive log filename=/arch1/1_10_823148545.dbf recid=34 stamp=823151447
validation succeeded for archived log
archive log filename=/arch1/1_11_823148545.dbf recid=35 stamp=823151453
validation succeeded for archived log
archive log filename=/arch1/1_12_823148545.dbf recid=36 stamp=823151453
validation succeeded for archived log
archive log filename=/arch1/1_13_823148545.dbf recid=38 stamp=823151456
validation failed for archived log
archive log filename=/arch2/2_1_823148545.dbf recid=13 stamp=823150629
validation failed for archived log
archive log filename=/arch2/2_7_823148545.dbf recid=24 stamp=823151368
validation failed for archived log
archive log filename=/arch2/2_8_823148545.dbf recid=25 stamp=823151371
validation failed for archived log
archive log filename=/arch2/2_9_823148545.dbf recid=27 stamp=823151376
validation failed for archived log
archive log filename=/arch2/2_10_823148545.dbf recid=28 stamp=823151376
validation failed for archived log
archive log filename=/arch2/2_11_823148545.dbf recid=29 stamp=823151383
validation failed for archived log
archive log filename=/arch2/2_12_823148545.dbf recid=30 stamp=823151383
validation failed for archived log
archive log filename=/arch2/2_13_823148545.dbf recid=32 stamp=823151387
validation failed for archived log
archive log filename=/arch2/2_14_823148545.dbf recid=37 stamp=823151441
Crosschecked 16 objects

        由于节点1不能访问节点2归档目的地/arch2下的备份文件，所有节点2所有归档交叉检查都失败。

        在这种情况下执行以下的命令备份所有节点的归档，并删除所有目的地的INPUT归档：

RMAN> backup archivelog all delete all input;

Starting backup at 2013-08-11 05:15:40
current log archived
using channel ORA_DISK_1
RMAN-00571: ===========================================================
RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
RMAN-00571: ===========================================================
RMAN-03002: failure of backup command at 08/11/2013 05:15:50
RMAN-06059: expected archived log not found, lost of archived log compromises recoverability
ORA-19625: error identifying file /arch2/2_15_823148545.dbf
ORA-27037: unable to obtain file status
Linux-x86_64 Error: 2: No such file or directory
Additional information: 3

        由于节点1不能访问节点2归档目的地/arch2下的备份文件，所有备份根本无法开始。

尝试为两个节点分配各自的通道：

RMAN> run{
2> allocate channel c1 device type disk format '/rmanbak/%p_%s_%d.BAK' connect 'sys/oracle123@orcl1';
3> allocate channel c2 device type disk format '/rmanbak/%p_%s_%d.BAK' connect 'sys/oracle123@orcl2';
4> backup archivelog all delete all input;
5> release channel c1;
6> release channel c2;}

released channel: ORA_DISK_1
allocated channel: c1
channel c1: sid=131 instance=orcl1 devtype=DISK

allocated channel: c2
channel c2: sid=140 instance=orcl2 devtype=DISK

Starting backup at 2013-08-11 05:17:26
current log archived
channel c1: starting archive log backupset
channel c1: specifying archive log(s) in backup set
input archive log thread=1 sequence=13 recid=38 stamp=823151456
input archive log thread=1 sequence=14 recid=39 stamp=823151740
input archive log thread=1 sequence=15 recid=42 stamp=823151849
channel c1: starting piece 1 at 2013-08-11 05:17:38
channel c2: starting archive log backupset
channel c2: specifying archive log(s) in backup set
input archive log thread=2 sequence=15 recid=40 stamp=823151729
input archive log thread=2 sequence=16 recid=41 stamp=823151835
channel c2: starting piece 1 at 2013-08-11 05:17:26
RMAN-03009: failure of backup command on c2 channel at 08/11/2013 05:17:38
ORA-19504: failed to create file "/rmanbak/1_13_ORCL.BAK"
ORA-27040: file create error, unable to create file
Linux-x86_64 Error: 2: No such file or directory
channel c2 disabled, job failed on it will be run on another channel
channel c1: finished piece 1 at 2013-08-11 05:17:39
piece handle=/rmanbak/1_12_ORCL.BAK tag=TAG20130811T051736 comment=NONE
channel c1: backup set complete, elapsed time: 00:00:02
channel c1: deleting archive log(s)
archive log filename=/arch1/1_13_823148545.dbf recid=38 stamp=823151456
archive log filename=/arch1/1_14_823148545.dbf recid=39 stamp=823151740
archive log filename=/arch1/1_15_823148545.dbf recid=42 stamp=823151849
channel c1: starting archive log backupset
channel c1: specifying archive log(s) in backup set
input archive log thread=1 sequence=7 recid=26 stamp=823151383
input archive log thread=1 sequence=8 recid=31 stamp=823151395
input archive log thread=1 sequence=9 recid=33 stamp=823151446
input archive log thread=1 sequence=10 recid=34 stamp=823151447
input archive log thread=1 sequence=11 recid=35 stamp=823151453
input archive log thread=1 sequence=12 recid=36 stamp=823151453
channel c1: starting piece 1 at 2013-08-11 05:17:40
channel c1: finished piece 1 at 2013-08-11 05:17:41
piece handle=/rmanbak/1_14_ORCL.BAK tag=TAG20130811T051736 comment=NONE
channel c1: backup set complete, elapsed time: 00:00:02
channel c1: deleting archive log(s)
archive log filename=/arch1/1_7_823148545.dbf recid=26 stamp=823151383
archive log filename=/arch1/1_8_823148545.dbf recid=31 stamp=823151395
archive log filename=/arch1/1_9_823148545.dbf recid=33 stamp=823151446
archive log filename=/arch1/1_10_823148545.dbf recid=34 stamp=823151447
archive log filename=/arch1/1_11_823148545.dbf recid=35 stamp=823151453
archive log filename=/arch1/1_12_823148545.dbf recid=36 stamp=823151453
released channel: c1
released channel: c2
RMAN-00571: ===========================================================
RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
RMAN-00571: ===========================================================

RMAN-03009: failure of backup command on c2 channel at 08/11/2013 05:17:38
ORA-19504: failed to create file "/rmanbak/1_13_ORCL.BAK"
ORA-27040: file create error, unable to create file
Linux-x86_64 Error: 2: No such file or directory

        为两个节点分配了各自的通道后，在节点1执行备份能够正常的访问到节点的归档目的地/arch2下的归档文件，但节点2不存在/rmanbak备份目的地，无法创建备份。

RMAN> crosscheck archivelog all;

allocated channel: ORA_DISK_1
channel ORA_DISK_1: sid=128 instance=orcl1 devtype=DISK
validation failed for archived log
archive log filename=/arch2/2_1_823148545.dbf recid=13 stamp=823150629
validation failed for archived log
archive log filename=/arch2/2_7_823148545.dbf recid=24 stamp=823151368
validation failed for archived log
archive log filename=/arch2/2_8_823148545.dbf recid=25 stamp=823151371
validation failed for archived log
archive log filename=/arch2/2_9_823148545.dbf recid=27 stamp=823151376
validation failed for archived log
archive log filename=/arch2/2_10_823148545.dbf recid=28 stamp=823151376
validation failed for archived log
archive log filename=/arch2/2_11_823148545.dbf recid=29 stamp=823151383
validation failed for archived log
archive log filename=/arch2/2_12_823148545.dbf recid=30 stamp=823151383
validation failed for archived log
archive log filename=/arch2/2_13_823148545.dbf recid=32 stamp=823151387
validation failed for archived log
archive log filename=/arch2/2_14_823148545.dbf recid=37 stamp=823151441
validation failed for archived log
archive log filename=/arch2/2_15_823148545.dbf recid=40 stamp=823151729
validation failed for archived log
archive log filename=/arch2/2_16_823148545.dbf recid=41 stamp=823151835
Crosschecked 11 objects

       通过简单的交叉检查可以发现节点1的所有归档成功备份，但节点2的归档未备份。

        在节点2执行以下的步骤创建/rmanbak备份目的地：
[root@linux2 /]# cd /
[root@linux2 /]# mkdir rmanbak
[root@linux2 /]# chown -R oracle:oinstall rmanbak
[root@linux2 /]# ls -ald rmanbak
drwxr-xr-x 2 oracle oinstall 4096 Aug 11 05:18 rmanbak

回到节点1执行交叉检查：

RMAN> run{
2> allocate channel c1 device type disk connect 'sys/oracle123@orcl2';
3> allocate channel c2 device type disk connect 'sys/oracle123@orcl1';
4> crosscheck archivelog all;
5> release channel c1;
6> release channel c2;}

released channel: ORA_DISK_1
allocated channel: c1
channel c1: sid=140 instance=orcl2 devtype=DISK

allocated channel: c2
channel c2: sid=131 instance=orcl1 devtype=DISK

validation succeeded for archived log
archive log filename=/arch2/2_1_823148545.dbf recid=13 stamp=823150629
validation succeeded for archived log
archive log filename=/arch2/2_7_823148545.dbf recid=24 stamp=823151368
validation succeeded for archived log
archive log filename=/arch2/2_8_823148545.dbf recid=25 stamp=823151371
validation succeeded for archived log
archive log filename=/arch2/2_9_823148545.dbf recid=27 stamp=823151376
validation succeeded for archived log
archive log filename=/arch2/2_10_823148545.dbf recid=28 stamp=823151376
validation succeeded for archived log
archive log filename=/arch2/2_11_823148545.dbf recid=29 stamp=823151383
validation succeeded for archived log
archive log filename=/arch2/2_12_823148545.dbf recid=30 stamp=823151383
validation succeeded for archived log
archive log filename=/arch2/2_13_823148545.dbf recid=32 stamp=823151387
validation succeeded for archived log
archive log filename=/arch2/2_14_823148545.dbf recid=37 stamp=823151441
validation succeeded for archived log
archive log filename=/arch2/2_15_823148545.dbf recid=40 stamp=823151729
validation succeeded for archived log
archive log filename=/arch2/2_16_823148545.dbf recid=41 stamp=823151835
Crosschecked 11 objects


released channel: c1

released channel: c2

交叉检查两个节点归档都成功。

执行归档备份操作：

RMAN> run{
2> allocate channel c1 device type disk format '/rmanbak/%p_%s_%d.BAK' connect 'sys/oracle123@orcl1';
3> aloocate channel c2 device type disk format '/rmanbak/%p_%s_%d.BAK' connect 'sys/oracle123@orcl2';
4> backup archivelog all delete all input;
5> release channel c1;
6> release channel c2;}

allocated channel: c1
channel c1: sid=131 instance=orcl1 devtype=DISK

allocated channel: c2
channel c2: sid=140 instance=orcl2 devtype=DISK

Starting backup at 2013-08-11 05:21:50
current log archived
channel c1: starting archive log backupset
channel c1: specifying archive log(s) in backup set
input archive log thread=1 sequence=16 recid=43 stamp=823152110
channel c1: starting piece 1 at 2013-08-11 05:21:54
channel c2: starting archive log backupset
channel c2: specifying archive log(s) in backup set
input archive log thread=2 sequence=13 recid=32 stamp=823151387
input archive log thread=2 sequence=14 recid=37 stamp=823151441
input archive log thread=2 sequence=15 recid=40 stamp=823151729
channel c2: starting piece 1 at 2013-08-11 05:21:42
channel c1: finished piece 1 at 2013-08-11 05:21:55
piece handle=/rmanbak/1_15_ORCL.BAK tag=TAG20130811T052152 comment=NONE
channel c1: backup set complete, elapsed time: 00:00:02
channel c1: deleting archive log(s)
archive log filename=/arch1/1_16_823148545.dbf recid=43 stamp=823152110
channel c2: finished piece 1 at 2013-08-11 05:21:43
piece handle=/rmanbak/1_16_ORCL.BAK tag=TAG20130811T052152 comment=NONE
channel c2: backup set complete, elapsed time: 00:00:02
channel c2: deleting archive log(s)
archive log filename=/arch2/2_13_823148545.dbf recid=32 stamp=823151387
archive log filename=/arch2/2_14_823148545.dbf recid=37 stamp=823151441
archive log filename=/arch2/2_15_823148545.dbf recid=40 stamp=823151729
channel c2: starting archive log backupset
channel c2: specifying archive log(s) in backup set
input archive log thread=2 sequence=1 recid=13 stamp=823150629
input archive log thread=2 sequence=7 recid=24 stamp=823151368
input archive log thread=2 sequence=8 recid=25 stamp=823151371
input archive log thread=2 sequence=9 recid=27 stamp=823151376
input archive log thread=2 sequence=10 recid=28 stamp=823151376
input archive log thread=2 sequence=11 recid=29 stamp=823151383
input archive log thread=2 sequence=12 recid=30 stamp=823151383
channel c2: starting piece 1 at 2013-08-11 05:21:44
channel c2: finished piece 1 at 2013-08-11 05:21:46
piece handle=/rmanbak/1_17_ORCL.BAK tag=TAG20130811T052152 comment=NONE
channel c2: backup set complete, elapsed time: 00:00:03
channel c2: deleting archive log(s)
archive log filename=/arch2/2_1_823148545.dbf recid=13 stamp=823150629
archive log filename=/arch2/2_7_823148545.dbf recid=24 stamp=823151368
archive log filename=/arch2/2_8_823148545.dbf recid=25 stamp=823151371
archive log filename=/arch2/2_9_823148545.dbf recid=27 stamp=823151376
archive log filename=/arch2/2_10_823148545.dbf recid=28 stamp=823151376
archive log filename=/arch2/2_11_823148545.dbf recid=29 stamp=823151383
archive log filename=/arch2/2_12_823148545.dbf recid=30 stamp=823151383
channel c2: starting archive log backupset
channel c2: specifying archive log(s) in backup set
input archive log thread=2 sequence=16 recid=41 stamp=823151835
input archive log thread=2 sequence=17 recid=44 stamp=823152099
channel c2: starting piece 1 at 2013-08-11 05:21:47
channel c2: finished piece 1 at 2013-08-11 05:21:48
piece handle=/rmanbak/1_18_ORCL.BAK tag=TAG20130811T052152 comment=NONE
channel c2: backup set complete, elapsed time: 00:00:02
channel c2: deleting archive log(s)
archive log filename=/arch2/2_16_823148545.dbf recid=41 stamp=823151835
archive log filename=/arch2/2_17_823148545.dbf recid=44 stamp=823152099
Finished backup at 2013-08-11 05:22:00

released channel: c1

released channel: c2

备份操作成功。

在节点2的/rmanbak目录下能看到备份文件。
[root@linux2 /]# cd rmanbak
[root@linux2 rmanbak]# ls
1_16_ORCL.BAK  1_17_ORCL.BAK  1_18_ORCL.BAK
[root@linux2 rmanbak]# ll
total 324
-rw-r----- 1 oracle oinstall 259584 Aug 11 05:21 1_16_ORCL.BAK
-rw-r----- 1 oracle oinstall  53248 Aug 11 05:21 1_17_ORCL.BAK
-rw-r----- 1 oracle oinstall   6656 Aug 11 05:21 1_18_ORCL.BAK

        在这个例子中，两个节点的归档目的地，备份目的地都是相互独立的空间。通过以上的例子，我们可以看到，在RAC环境下，如果每个节点的归档目的地只有自己可见，那么在备份的时候需要为每个节点分配通道，备份目的地在RAC所有节点必须都存在，并可读可写。

        如果RAC所有节点的归档日志放在共享存储上（集群文件系统），或者通过NFS等方式备份节点能够读写所有节点的归档目的地，那么在备份节点的备份操作就不需要为每个节点分配通道，且备份目的地只需要备份节点能读写就可以了。

--end--


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

转载于:http://blog.itpub.net/23135684/viewspace-768349/

congxinlan3332
关注
oracle RAC环境开启归档模式
06-12
### Oracle RAC环境中开启归档模式的详细...遵循上述步骤可以帮助您成功地配置归档模式，从而提高数据库的可靠性和可恢复性。同时，也需要持续监控归档过程并维护正确的备份策略，以确保数据的安全性和系统的高可用性。
oracle RAC集群修改归档日志路径.docx
09-23
在Oracle RAC环境中，正确配置归档日志路径至关重要，因为它涉及到数据保护和集群间的协调。 在Oracle RAC集群中修改归档日志路径通常涉及以下步骤： 1. **创建归档日志存放路径**： 在Oracle RAC中，归档日志...
oracle 11g rac 归档 开启
cuishaobo1694的博客
06-17 130
背景： 数据库建设到现在，一致在做逻辑备份，考虑到后期维护人员现场情况，建议最近就将归档日志打开 过程 因为之前没有在rac开启过归档，现在在虚拟rac下...
RAC开启归档
weixin_34392843的博客
03-11 92
RAC下的归档如果使用的共享存储或放ASM里可以把归档放在一个目录下，也可以放在各自独立的目录下，可以根据需求进行设计下面演示放同一目录的操作：NODE1:alterdiskgrouparchiveadddirectory‘+ARCHIVE/ARCH’;altersystemsetlog_archive_dest_1=’location=+ARCHIVE/A...
oracle11g RAC 启动归档模式
cuandan3585的博客
01-22 139
根据客户要求，需要将归档日志存放在ASM上。因此需要在ASM建归档路径 ASMCMD> mkdir arch ASMCMD> cd arch ASMCMD> pwd ...
RAC开启数据库归档
cmbzwa6940的博客
11-29 220
RAC开启数据库归档： 首先要确定归档存放的路径： 1.切换至grid用户下使用asmcmd命令查看要把归档存放到那个路径下 ...
oracle 10g/11g RAC 启停归档模式
weixin_34061555的博客
06-15 91
 oracle 10g rac 启停归档模式    假设Oracle数据库执行在归档模式，当进行数据库维护时，可能须要暂停数据库的归档，在完毕维护后，再又一次启动归档模式。 通过下面步骤能够从归档模式转换为非归档模式： 下面步骤在一台机器上操作。节点二保持down。在全部的操作完毕后在打开节点二的数据库。 sql>connect SYS/PASSWORD ...
ORACLE 11g RAC开启、修改归档方法
09-26
从输出结果可以看出，归档模式已经成功启用，并且归档目的地也被正确设置。 ##### 7. 检查第二个节点 最后一步是确保第二个节点也完成了同样的配置。可以在另一台主机上重复上述步骤，以确保整个集群都处于一致的...
ORACLE 数据库RAC环境DG主备不同步问题处理.docx
08-23
为了解决这个问题，首先尝试通过`alter system set log_archive_dest_state_2=enable`命令重新启用归档目的地，以便恢复日志传输。然而，由于等待的6392号归档日志已被清理，所以从NBU磁带库恢复失败。在这种情况下...
rac归档在本地的备份和恢复
weixin_33713503的博客
08-12 253
rac归档在本地的备份和恢复 os：Red Hat Enterprise Linux Server release 5.1 (Tikanga) oracle：Oracle Database 10g Enterprise Edition Release 10.2.0.1.0 两个节点rac1 rac2 归档在本地目录： log_archive_dest_1 st...
oracle 10g rac归档模式切换
hayata的专栏
08-19 814
在10grac下，更改归档模式不像单机或主/备模式下那么容易更改，主要是因为cluster_database参数的缘故。通过将 cluster_database参数从true改为false，可以顺利用更改单机归档模式的方式来更改归档设置。更改完毕后，再将 cluster_database参数改回true即可。至于归档日志，可以通过nfs共享来保存两边共有的归档日志，当然也可以用rman直接各自备各
Oracle RAC中使用RMAN管理归档日志
ckml77559的博客
05-18 200
RMAN归档配置的两种方案 1.在Oracle asm和集群文件系统时的归档方案 对于Oracle RAC来说首选是使用Oracle asm作为reocvery区域。可选择的你也可以使用集群文件系统的归档方案...
oracle 换数据空间不足,用rman备份数据集失败，报空间不足 - Oracle数据库管理 - Oracle数据库数据恢复、性能优化来问问AskMaclean - ParnassusData诗檀...
weixin_42499332的博客
04-09 287
刘大，您好：向您请教个问题，我的备份脚本非常简单，晚上执行的时候一直报错，空间不足，但是我白天sh执行脚本的时候又不报错误，晚上执行的时候会产生很多日志，日志内容都是报空间不足，失败。下面是任务列表：* 1 * * * sh/oradata/backup/rman_script/fullbackup.sh下面是磁盘空间容量：[oracle@node1 rman_log]$ df -h文件系统...
channel c3 disabled, job failed on it will be run on another channel
weixin_30590285的博客
08-07 307
今天执行备份时，报错： allocated channel: c3 channel c3: sid=131 instance=orcl2 devtype=DISK RMAN-03009: failure of backup command on c3 channel at 09/22/2010 05:11:10 ORA-19504: failed to create file "/u...
oracle技术之RAC数据库建立STANDBY（六）
weixin_34059951的博客
05-10 145
这篇文章描述为RAC环境创建STANDBY数据库。由于篇幅限制，加上碰到了很多的bug，只能将文章拆分成多篇。由于错误太多，导致一篇文章无法完全记录下来，创建STANDBY数据库问题汇总的第四部分。刚刚在进行RAC环境的DUPLICATE DATABASE的时候，就碰到了很多问题，由于二者命令比较相似，本来认为这次不会碰到太多的问题，没有想到的是，这次碰到的问题居然比DUPL...
RAC RMAN 备份 RMAN-03009 ORA-19504 ORA-27040 RMAN-06012 channel c3 not allocated 错误分析
tianshibaijia
09-30 124
把之前的RMAN单实例的备份脚本修改了一下，用来备份RAC系统。 Linux平台下RMAN全备和增量备份shell脚本 http://blog.csdn.net/xujinyang/article/details/6838002 修改之后的备份Shell脚本如下： ###########################################################...
RAC数据库建立STANDBY（六）
ckawt40802的专栏
05-30 130
这篇文章描述为RAC环境创建STANDBY数据库。 由于篇幅限制，加上碰到了很多的bug，只能将文章拆分成多篇。 由于错误太多，导致一篇文章无法完全记录下来，创建STANDBY数据库问题汇总的第四部分。 RAC数据库建立S...
rman备份rac的总结
fedora
09-08 161
一、归档日志分别存放在本地备份部分：对于建立在裸设备上的RAC环境，由于归档不能存放到裸设备上，因此，所有的归档都必须保存在本地的磁盘上。直接通过RMAN备份会导致错误。首先模仿裸设备的情况，修改原来LOG_ARCHIVE_DEST_1的配置，将每个实例的归档改在本地硬盘：节点一：SQL> ALTER SYSTEM SET LOG_ARCHIVE_DEST_1 = 'LOCATION=/da...
Oracle RAC环境下配置归档日志步骤详解
在RAC1节点上，通过SQL命令更新参数，如`LOG_ARCHIVE_DEST_n`，设置归档目的地为 `/Arch`。 9. **切换归档模式**： 使用 `ALTER DATABASE ARCHIVELOG` 命令将数据库切换到归档模式。 10. **启动数据库到OPEN状态...
评论
添加红包

请填写红包祝福语或标题

个

红包个数最小为10个

元

红包金额最低5元

当前余额3.43元 前往充值 >
需支付：10.00元
成就一亿技术人!
领取后你会自动成为博主和红包主的粉丝 规则
hope_wisdom
发出的红包
实付元
使用余额支付
点击重新获取
扫码支付
钱包余额 0

抵扣说明：

1.余额是钱包充值的虚拟货币，按照1:1的比例进行支付金额的抵扣。
2.余额无法直接购买下载，可以购买VIP、付费专栏及课程。

余额充值