RAC数据库当归档文件两个节点都能访问时,就能在一个节点上进行备份及删除
来源:互联网 发布:2017程序员薪资 编辑:程序博客网 时间:2024/05/01 03:58
[oracle@qnsdb1 ~]$ rman target /
Recovery Manager: Release 11.2.0.3.0 - Production on Tue Nov 5 16:43:25 2013
Copyright (c) 1982, 2011, Oracle and/or its affiliates. All rights reserved.
connected to target database: BSQQNS (DBID=4291392101)
RMAN> delete archivelog all;
using target database control file instead of recovery catalog
allocated channel: ORA_DISK_1
channel ORA_DISK_1: SID=8 instance=bsqqns1 device type=DISK
List of Archived Log Copies for database with db_unique_name BSQQNS
=====================================================================
Key Thrd Seq S Low Time
------- ---- ------- - ---------
1 1 9 A 10-OCT-13
Name: +BSQQNS/bsqqns/arch1/1_9_828441637.dbf
3 1 10 A 11-OCT-13
Name: +BSQQNS/bsqqns/arch1/1_10_828441637.dbf
4 1 11 A 17-OCT-13
Name: +BSQQNS/bsqqns/arch1/1_11_828441637.dbf
6 1 12 A 21-OCT-13
Name: +BSQQNS/bsqqns/arch1/1_12_828441637.dbf
7 1 13 A 24-OCT-13
Name: +BSQQNS/bsqqns/arch1/1_13_828441637.dbf
9 1 14 A 26-OCT-13
Name: +BSQQNS/bsqqns/arch1/1_14_828441637.dbf
10 1 15 A 29-OCT-13
Name: +BSQQNS/bsqqns/arch1/1_15_828441637.dbf
12 1 16 A 01-NOV-13
Name: +BSQQNS/bsqqns/arch1/1_16_828441637.dbf
2 2 1 A 10-OCT-13
Name: +BSQQNS/bsqqns/arch2/2_1_828441637.dbf
5 2 2 A 16-OCT-13
Name: +BSQQNS/bsqqns/arch2/2_2_828441637.dbf
8 2 3 A 21-OCT-13
Name: +BSQQNS/bsqqns/arch2/2_3_828441637.dbf
11 2 4 A 27-OCT-13
Name: +BSQQNS/bsqqns/arch2/2_4_828441637.dbf
Do you really want to delete the above objects (enter YES or NO)? YES
deleted archived log
archived log file name=+BSQQNS/bsqqns/arch1/1_9_828441637.dbf RECID=1 STAMP=828561637
deleted archived log
archived log file name=+BSQQNS/bsqqns/arch1/1_10_828441637.dbf RECID=3 STAMP=829008020
deleted archived log
archived log file name=+BSQQNS/bsqqns/arch1/1_11_828441637.dbf RECID=4 STAMP=829354275
deleted archived log
archived log file name=+BSQQNS/bsqqns/arch1/1_12_828441637.dbf RECID=6 STAMP=829613619
deleted archived log
archived log file name=+BSQQNS/bsqqns/arch1/1_13_828441637.dbf RECID=7 STAMP=829846825
deleted archived log
archived log file name=+BSQQNS/bsqqns/arch1/1_14_828441637.dbf RECID=9 STAMP=830045887
deleted archived log
archived log file name=+BSQQNS/bsqqns/arch1/1_15_828441637.dbf RECID=10 STAMP=830305237
deleted archived log
archived log file name=+BSQQNS/bsqqns/arch1/1_16_828441637.dbf RECID=12 STAMP=830564595
deleted archived log
archived log file name=+BSQQNS/bsqqns/arch2/2_1_828441637.dbf RECID=2 STAMP=828936027
deleted archived log
archived log file name=+BSQQNS/bsqqns/arch2/2_2_828441637.dbf RECID=5 STAMP=829411239
deleted archived log
archived log file name=+BSQQNS/bsqqns/arch2/2_3_828441637.dbf RECID=8 STAMP=829936814
deleted archived log
archived log file name=+BSQQNS/bsqqns/arch2/2_4_828441637.dbf RECID=11 STAMP=830440830
- RAC数据库当归档文件两个节点都能访问时,就能在一个节点上进行备份及删除
- 在RAC一个节点上创建数据库时ORA-29702
- rac四个节点 如果把归档放在本地目录,是否其他节点能否访问到归档
- 让两个节点的RAC使用一个SPfile参数文件!
- Oracle 10G RAC - 某个节点上缺失某些归档日志后删除报错问题
- Oracle RAC删除一个节点_3节点的实验
- RAC的节点删除
- Oracle10g RAC删除节点
- RAC删除节点
- 【Oracle】RAC删除节点
- rac删除节点步骤
- 在一个popupwindow上使用spinner,能显示,但当点击spinner时出现异常
- 其它网站都能正常上,就一个网站不能上的解决办法
- RAC结构删除一个节点并删除数据库软件的解决方案
- 告诉大家一个无敌删除命令,任意无法删除的文件都能删除
- 告诉大家一个无敌删除命令,任意无法删除的文件都能删除
- 告诉大家一个无敌删除批处理文件,任意无法删除的文件都能删除
- 给定一个链表和一个值x,对它进行分区,使得小于x的所有节点都在大于或等于x的节点之前.保留两个分区中的每一个节点的原始相对顺序。
- 使用ASP.NET MVC开发混合移动应用
- 金字塔星号图
- 星星图
- android Toast重复提示
- MySQL 创建临时时间表 存储过程
- RAC数据库当归档文件两个节点都能访问时,就能在一个节点上进行备份及删除
- 池建强:如何学习一门编程语言
- Flex 3 与 Flex 4 beta 之间的区别
- 对iOS开发中内存管理的一点总结与理解
- iOS-Overlay页面加载中动画
- json数据不用名称读取 $ each
- SQL 分页语句
- java中的多线程
- linux默认端口范围是多少?