RAC中如何备份归档日志

RAC中如何备份归档日志

一、RMAN管理RAC归档方法如下:
1)归档在本地
run {
ALLOCATE CHANNEL D1 TYPE DISK CONNECT 'SYS/oracle@doudou1';
ALLOCATE CHANNEL D2 TYPE DISK CONNECT 'SYS/oracle@doudou2';
crosscheck archivelog all;
...}
2)归档在共享目录
run {
crosscheck archivelog all;
...}

二、实验
1.RMAN默认配置如下
RMAN> show all;
RMAN configuration parameters for database with db_unique_name DOUDOU are:
CONFIGURE RETENTION POLICY TO REDUNDANCY 1; # default
CONFIGURE BACKUP OPTIMIZATION OFF; # default
CONFIGURE DEFAULT DEVICE TYPE TO DISK; # default
CONFIGURE CONTROLFILE AUTOBACKUP OFF; # default
CONFIGURE CONTROLFILE AUTOBACKUP FORMAT FOR DEVICE TYPE DISK TO '%F'; # default
CONFIGURE DEVICE TYPE DISK PARALLELISM 1 BACKUP TYPE TO BACKUPSET; # default
CONFIGURE DATAFILE BACKUP COPIES FOR DEVICE TYPE DISK TO 1; # default
CONFIGURE ARCHIVELOG BACKUP COPIES FOR DEVICE TYPE DISK TO 1; # default
CONFIGURE MAXSETSIZE TO UNLIMITED; # default
CONFIGURE ENCRYPTION FOR DATABASE OFF; # default
CONFIGURE ENCRYPTION ALGORITHM 'AES128'; # default
CONFIGURE COMPRESSION ALGORITHM 'BASIC' AS OF RELEASE 'DEFAULT' OPTIMIZE FOR LOAD TRUE ; # default
CONFIGURE ARCHIVELOG DELETION POLICY TO NONE; # default
CONFIGURE SNAPSHOT CONTROLFILE NAME TO '/oracle/app/oracle/product/11.2.0/dbhome_1/dbs/snapcf_doudou1.f'; # default
2.归档不同位置备份脚本有所不同
2-1.归档在本地
思路如下:
修改PARALLELISM 1 =》PARALLELISM 2 (我的RAC是2个节点所以是2)
添加CONFIGURE CHANNEL
详细步骤如下:
RMAN> CONFIGURE DEVICE TYPE DISK PARALLELISM 2;
new RMAN configuration parameters:
CONFIGURE DEVICE TYPE DISK PARALLELISM 2 BACKUP TYPE TO BACKUPSET;
new RMAN configuration parameters are successfully stored
RMAN> CONFIGURE CHANNEL 1 DEVICE TYPE DISK connect 'SYS/oracle@doudou1';
new RMAN configuration parameters:
CONFIGURE CHANNEL 1 DEVICE TYPE DISK CONNECT '*';
new RMAN configuration parameters are successfully stored
RMAN> CONFIGURE CHANNEL 2 DEVICE TYPE DISK connect 'SYS/oracle@doudou2';
new RMAN configuration parameters:
CONFIGURE CHANNEL 2 DEVICE TYPE DISK CONNECT '*';
new RMAN configuration parameters are successfully stored
修改后配置如下:
RMAN> show all;
RMAN configuration parameters for database with db_unique_name DOUDOU are:
CONFIGURE RETENTION POLICY TO REDUNDANCY 1; # default
CONFIGURE BACKUP OPTIMIZATION OFF; # default
CONFIGURE DEFAULT DEVICE TYPE TO DISK; # default
CONFIGURE CONTROLFILE AUTOBACKUP OFF; # default
CONFIGURE CONTROLFILE AUTOBACKUP FORMAT FOR DEVICE TYPE DISK TO '%F'; # default
CONFIGURE DEVICE TYPE DISK PARALLELISM 2 BACKUP TYPE TO BACKUPSET;   《=已修改
CONFIGURE DATAFILE BACKUP COPIES FOR DEVICE TYPE DISK TO 1; # default
CONFIGURE ARCHIVELOG BACKUP COPIES FOR DEVICE TYPE DISK TO 1; # default
CONFIGURE CHANNEL 1 DEVICE TYPE DISK CONNECT '*'; 《=新添加
CONFIGURE CHANNEL 2 DEVICE TYPE DISK CONNECT '*'; 《=新添加
CONFIGURE MAXSETSIZE TO UNLIMITED; # default
CONFIGURE ENCRYPTION FOR DATABASE OFF; # default
CONFIGURE ENCRYPTION ALGORITHM 'AES128'; # default
CONFIGURE COMPRESSION ALGORITHM 'BASIC' AS OF RELEASE 'DEFAULT' OPTIMIZE FOR LOAD TRUE ; # default
CONFIGURE ARCHIVELOG DELETION POLICY TO NONE; # default
CONFIGURE SNAPSHOT CONTROLFILE NAME TO '/oracle/app/oracle/product/11.2.0/dbhome_1/dbs/snapcf_doudou1.f'; # default
这个时候就可以使用RMAN管理归档了。

RMAN备份脚本应是如下:
RMAN>  run {
2>  ALLOCATE CHANNEL D1 TYPE DISK CONNECT 'SYS/oracle@doudou1';
3>  ALLOCATE CHANNEL D2 TYPE DISK CONNECT 'SYS/oracle@doudou2';
4> crosscheck archivelog all;
5> delete archivelog all;
6>  }
allocated channel: D1
channel D1: SID=84 instance=doudou1 device type=DISK
allocated channel: D2
channel D2: SID=63 instance=doudou2 device type=DISK
validation succeeded for archived log
archived log file name=/home/oracle/arch_rac1/1_441_852991268.dbf RECID=773 STAMP=858426701
Crosschecked 1 objects
validation succeeded for archived log
archived log file name=/home/oracle/arch_rac2/2_343_852991268.dbf RECID=774 STAMP=858426703
Crosschecked 1 objects

List of Archived Log Copies for database with db_unique_name DOUDOU
=====================================================================
Key     Thrd Seq     S Low Time            
------- ---- ------- - --------------------
773     1    441     A 16-SEP-2014 10:40:13
        Name: /home/oracle/arch_rac1/1_441_852991268.dbf
774     2    343     A 16-SEP-2014 10:40:10
        Name: /home/oracle/arch_rac2/2_343_852991268.dbf

Do you really want to delete the above objects (enter YES or NO)? YES
deleted archived log
archived log file name=/home/oracle/arch_rac1/1_441_852991268.dbf RECID=773 STAMP=858426701
Deleted 1 objects
deleted archived log
archived log file name=/home/oracle/arch_rac2/2_343_852991268.dbf RECID=774 STAMP=858426703
Deleted 1 objects
released channel: D1
released channel: D2

2-2.归档在共享存储上
RMAN>  run {
2> crosscheck archivelog all;
3> delete archivelog all;
4>  }
validation succeeded for archived log
archived log file name=+DATA/doudou/archivelog/2014_09_16/thread_1_seq_442.342.858436879 RECID=776 STAMP=858436882
validation succeeded for archived log
archived log file name=+DATA/doudou/archivelog/2014_09_16/thread_2_seq_344.312.858436877 RECID=775 STAMP=858436877
Crosschecked 2 objects

List of Archived Log Copies for database with db_unique_name DOUDOU
=====================================================================
Key     Thrd Seq     S Low Time            
------- ---- ------- - --------------------
776     1    442     A 16-SEP-2014 11:51:40
        Name: +DATA/doudou/archivelog/2014_09_16/thread_1_seq_442.342.858436879
775     2    344     A 16-SEP-2014 11:51:43
        Name: +DATA/doudou/archivelog/2014_09_16/thread_2_seq_344.312.858436877

Do you really want to delete the above objects (enter YES or NO)? YES
deleted archived log
archived log file name=+DATA/doudou/archivelog/2014_09_16/thread_1_seq_442.342.858436879 RECID=776 STAMP=858436882
deleted archived log
archived log file name=+DATA/doudou/archivelog/2014_09_16/thread_2_seq_344.312.858436877 RECID=775 STAMP=858436877
Deleted 2 objects
- 本文出自BI168大数据社区,更多精彩请点击 原文地址:http://www.bi168.cn/>>http://www.bi168.cn/thread-1388-1-1.html
  • 0
    点赞
  • 0
    收藏
    觉得还不错? 一键收藏
  • 0
    评论
提供的源码资源涵盖了小程序应用等多个领域,每个领域都包含了丰富的实例和项目。这些源码都是基于各自平台的最新技术和标准编写,确保了在对应环境下能够无缝运行。同时,源码配备了详细的注释和文档,帮助用户快速理解代码结构和实现逻辑。 适用人群: 适合毕业设计、课程设计作业。这些源码资源特别适合大学生群体。无论你是计算机相关专业的学生,还是对其他领域编程感兴趣的学生,这些资源都能为你提供宝贵的学习和实践机会。通过学习和运行这些源码,你可以掌握各平台开发的基础知识,提升编程能力和项目实战经验。 使用场景及目标: 在学习阶段,你可以利用这些源码资源进行课程实践、课外项目或毕业设计。通过分析和运行源码,你将深入了解各平台开发的技术细节和最佳实践,逐步培养起自己的项目开发和问题解决能力。此外,在求职或创业过程,具备跨平台开发能力的大学生将更具竞争力。 其他说明: 为了确保源码资源的可运行性和易用性,特别注意了以下几点:首先,每份源码都提供了详细的运行环境和依赖说明,确保用户能够轻松搭建起开发环境;其次,源码的注释和文档都非常完善,方便用户快速上手和理解代码;最后,我会定期更新这些源码资源,以适应各平台技术的最新发展和市场需求。 所有源码均经过严格测试,可以直接运行,可以放心下载使用。有任何使用问题欢迎随时与博主沟通,第一时间进行解答!

“相关推荐”对你有帮助么?

  • 非常没帮助
  • 没帮助
  • 一般
  • 有帮助
  • 非常有帮助
提交
评论
添加红包

请填写红包祝福语或标题

红包个数最小为10个

红包金额最低5元

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

抵扣说明:

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

余额充值