rman catalog 维护rman备份元数据

注册备份到元数据.
使用catalog 命令维护rman元数据
catalog datafilecopy
catalog archivelog
catalog backuppiece
catalog start with(可以完成一个目录下所有文件的注册)

RMAN> backup tablespace lfn_nfs format '/u01/flash/lfn_nfs%s.bak';

Starting backup at 13-OCT-18
using channel ORA_DISK_1
channel ORA_DISK_1: starting full datafile backup set
channel ORA_DISK_1: specifying datafile(s) in backup set
input datafile file number=00006 name=/u01/app/oranfs/lfn_nfs.dbf
channel ORA_DISK_1: starting piece 1 at 13-OCT-18
channel ORA_DISK_1: finished piece 1 at 13-OCT-18
piece handle=/u01/flash/lfn_nfs16.bak tag=TAG20181013T201808 comment=NONE
channel ORA_DISK_1: backup set complete, elapsed time: 00:00:01
Finished backup at 13-OCT-18

Starting Control File and SPFILE Autobackup at 13-OCT-18
piece handle=/u01/flash/c-297073326-20181013-04 comment=NONE
Finished Control File and SPFILE Autobackup at 13-OCT-18


 mv lfn_nfs16.bak lfn_nfs16.bak.bad

 [oracle@oracle flash]$ ll
total 10976
-rw-r----- 1 oracle oinstall 10125312 Oct 13 20:18 c-297073326-20181013-04
-rw-r----- 1 oracle oinstall  1089536 Oct 13 20:19 lfn_nfs16.bak.bad
drwxr-x--- 4 oracle oinstall     4096 Oct 13 19:39 PROD


RMAN> crosscheck backup;

using channel ORA_DISK_1
crosschecked backup piece: found to be 'EXPIRED'
backup piece handle=/u01/flash/lfn_nfs16.bak RECID=11 STAMP=989439488
crosschecked backup piece: found to be 'AVAILABLE'
backup piece handle=/u01/flash/c-297073326-20181013-04 RECID=12 STAMP=989439489
Crosschecked 2 objects


RMAN> list expired backup;


List of Backup Sets
===================


BS Key  Type LV Size       Device Type Elapsed Time Completion Time
------- ---- -- ---------- ----------- ------------ ---------------
11      Full    1.03M      DISK        00:00:00     13-OCT-18      
        BP Key: 11   Status: EXPIRED  Compressed: NO  Tag: TAG20181013T201808
        Piece Name: /u01/flash/lfn_nfs16.bak
  List of Datafiles in backup set 11
  File LV Type Ckp SCN    Ckp Time  Name
  ---- -- ---- ---------- --------- ----
  6       Full 979501     11-OCT-18 /u01/app/oranfs/lfn_nfs.dbf


  RMAN> delete noprompt expired backup;

using channel ORA_DISK_1

List of Backup Pieces
BP Key  BS Key  Pc# Cp# Status      Device Type Piece Name
------- ------- --- --- ----------- ----------- ----------
11      11      1   1   EXPIRED     DISK        /u01/flash/lfn_nfs16.bak
deleted backup piece
backup piece handle=/u01/flash/lfn_nfs16.bak RECID=11 STAMP=989439488
Deleted 1 EXPIRED objects


RMAN> list expired backup;

specification does not match any backup in the repository


RMAN> catalog backuppiece '/u01/flash/lfn_nfs16.bak.bad';

cataloged backup piece
backup piece handle=/u01/flash/lfn_nfs16.bak.bad RECID=13 STAMP=989439777

RMAN> list backup of tablespace lfn_nfs;


List of Backup Sets
===================


BS Key  Type LV Size       Device Type Elapsed Time Completion Time
------- ---- -- ---------- ----------- ------------ ---------------
13      Full    1.03M      DISK        00:00:00     13-OCT-18      
        BP Key: 13   Status: AVAILABLE  Compressed: NO  Tag: TAG20181013T201808
        Piece Name: /u01/flash/lfn_nfs16.bak.bad
  List of Datafiles in backup set 13
  File LV Type Ckp SCN    Ckp Time  Name
  ---- -- ---- ---------- --------- ----
  6       Full 979501     11-OCT-18 /u01/app/oranfs/lfn_nfs.dbf

 

  • 0
    点赞
  • 0
    收藏
    觉得还不错? 一键收藏
  • 0
    评论

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

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

请填写红包祝福语或标题

红包个数最小为10个

红包金额最低5元

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

抵扣说明:

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

余额充值