【RMAN】REPORT命令

Published May 9, 2020, 5:46 a.m. by zsd

Report命令

report need backup

列出为了与原来备份策略相符,需要备份的数据。如果列表中没有数据,说明,没有文件需要备份。 效果如下:

[oracle@oradb ~]$ ./report_need_backup.sh 

Recovery Manager: Release 11.2.0.4.0 - Production on Sat May 9 13:45:57 2020

Copyright (c) 1982, 2011, Oracle and/or its affiliates.  All rights reserved.

connected to target database: ORADB (DBID=2697310494)

RMAN> 
using target database control file instead of recovery catalog
RMAN retention policy will be applied to the command
RMAN retention policy is set to recovery window of 21 days
Report of files that must be backed up to satisfy 21 days recovery window
File Days  Name
---- ----- -----------------------------------------------------

RMAN> 

report need backup脚本

写出一个脚本,可以批量操作查询。

# $Header: report_need_backup.sh 2020/04/26
. ~/.bash_profile
export NLS_LANG="American_America.zhs16gbk"

CMD_STR="
rman target / <<EOF
report need backup;
EOF
"
bash -c "$CMD_STR"

report unrecoverable

report unrecoverable

同类文章

【RMAN】RMAN验证validate命令

【RMAN】某数据库RMAN异机恢复演练,(RAC异地成单实例)

【RMAN】RMAN的动态视图-查看RMAN的备份情况

【RMAN】在Oracle11gR2下基于RMAN恢复schema的数据

0 次评论

没有任何评论

添加一条评论