Oracle 10G RAC Cross-Instance Archivelog delete steps
来源:互联网 发布:淘宝网企业店铺靠谱吗 编辑:程序博客网 时间:2024/06/05 19:21
当RAC的归档日志是交叉归档在各个节点的本地磁盘,此时在单独一个节点上删除RAC的归档日志,另外一个节点上的日志不会被删除.
RMAN>run{
allocate channel c1 device type disk format '/u02/backup/%U' connect sys/manager@rac1;
allocate channel c2 device type disk format '/u02/backup/%U' connect sys/manager@rac2;
delete noprompt archivelog all;或者delete archivelog until time 'sysdate-5';
}
保证两个节点上的归档日志全部删除.
RMAN> connect target *
2> run
3> {
4> BACKUP DATABASE TAG Full_bk;
5> sql 'alter system archive log current';
6> RESTORE DATABASE VALIDATE;
7> CROSSCHECK BACKUP OF DATABASE;
8> REPORT OBSOLETE;
9> DELETE NOPROMPT OBSOLETE;
10> }
11> LIST BACKUP SUMMARY;
12> DELETE NOPROMPT ARCHIVELOG ALL COMPLETED BEFORE 'SYSDATE-8';
- Oracle 10G RAC Cross-Instance Archivelog delete steps
- Oracle 10G RAC Cross-Instance Archive - 配置问题
- Oracle 10G RAC Cross-Instance Archive - 某节点出现宕机后的问题
- Oracle 10g RAC add/delete votedisk
- Oracle 10g RAC ASM instance uninstall guide
- Oracle 10g RAC ASM Instance Conenction ORA-12528
- oracle rac archivelog mode
- Convert a Single Instance Database to Oracle RAC 10g on RHEL3
- Convert Oracle 9i Single-Instance database to 10g RAC .
- Oracle 10g RAC sqlplus / as sysdba Connected to an idle instance
- 10g Manual Database Creation in Oracle (Single Instance and RAC) (文档 ID 240052.1)
- Oracle 11g RAC 故障之--Instance 启动失败
- Convert 10g Single-Instance database to 10g RAC
- Oracle 10g RAC 简介
- Oracle 10g RAC架构
- Upgrade Oracle 9i RAC to Oracle 10g RAC
- Delete an oracle instance manually
- How to Convert 10g Single-Instance database to 10g RAC using Manual Conversion procedure
- Oracle Grid Control
- Oracle index view
- android Theme使用总结
- 《C++Primer Plus》学习笔记(一)
- Linux下/proc目录简介
- Oracle 10G RAC Cross-Instance Archivelog delete steps
- 选择排序
- 《C++Primer Plus》学习笔记(二)
- Oracle Audit & FGA
- 《C++Primer Plus》学习笔记(三)
- Oracle Migrate AUDIT & FGA Tablespace
- 你知道哪些表面优惠其实稳赚的销售手段
- CentOS 5.6创建NFS文件共享服务器
- 《C++Primer Plus》学习笔记(四)