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

原创粉丝点击