rman backup遇到ORA-19811

在对数据库进行备份的时候,使用了backup的 keep 选项,遇到了一个错误 ORA-19811.
Recovery Manager: Release 11.2.0.4.0 - Production on Tue Dec 24 13:39:49 2013
Copyright (c) 1982, 2011, Oracle and/or its affiliates.  All rights reserved.
connected to target database: ANDREA

run {
2> allocate channel ch1 device type disk;
3>  allocate channel ch2 device type disk;
4>  backup as backupset tag 'full-base-line'
5>  keep forever restore point 'full' database plus archivelog;
6> delete backupset 94;
7> delete backupset 95;
8> crosscheck backupset;
9> release channel ch1;
10> release channel ch2;
11> }

Starting backup at 24-DEC-13
current log archived
backup will never be obsolete
archived logs required to recover from this backup will be backed up
channel ch1: starting archived log backup set
channel ch1: specifying archived log(s) in backup set
input archived log thread=1 sequence=17 RECID=13 STAMP=835019297
channel ch1: starting piece 1 at 24-DEC-13
released channel: ch1
released channel: ch2
RMAN-00571: ===========================================================
RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
RMAN-00571: ===========================================================
RMAN-03002: failure of backup plus archivelog command at 12/24/2013 13:48:20
ORA-19811: cannot have files in DB_RECOVERY_FILE_DEST with keep attributes。

[oracle12@andrew1 Desktop]$ oerr ora 19811
19811, 00000, "cannot have files in DB_RECOVERY_FILE_DEST with keep attributes"
// *Cause: An attempt was made to
//         1) Create a backup piece or image copy in the recovery area with
//            KEEP option.
//         2) Update the KEEP attributes of an existing backup piece or
//            image copy in the recovery area.
// *Action: Reissue RMAN command without KEEP options.
也可以参考Oracle? Database Backup and Recovery Reference上的有关keep的说明:
Specifies the backup as an archival backup, which is a self-contained backup that is exempt from the configured retention policy.

An archival backup is self-contained because is contains all files
necessary to restore the backup and recover it to a consistent state. If
the database is open during the backup, then RMAN automatically
generates and backs up the archived redo log files needed to make the
database backup consistent (see Example 2-25).

RMAN does not consider backup pieces with the KEEP option when computing the retention policy. If available, RMAN uses
these backups for disaster recovery restore operations, but their
purpose is to produce a snapshot of the database that can be restored on
another system for testing or historical usage.

Note: You cannot use KEEP to override the retention policy for files stored in the fast recovery area. If you specify KEEP when backing up to the recovery area, then RMAN issues an error.

When KEEP is specified, RMAN creates multiple backup
sets. RMAN backs up data files, archived redo log files, the control
file, and the server parameter file with the options specified in the
first backupOperand. Since a backup of the control file is created, an autobackup of the control file is not created. RMAN uses the FORMAT, POOL, and TAG parameters for all the backups. For this reason, the FORMAT string must allow for the creation of multiple backup pieces. Specifying %U is the easiest way to meet this requirement.

See Also: CONFIGURE and Oracle Database Backup and Recovery User's Guide to learn more about autobackup of the control file.

When KEEP is specified with INCREMENTAL LEVEL, the parent backup must be a KEEP backup and have the same TAG string. Unless both these criteria are met, the backup cannot be
created. Backups that meet these criteria do not interfere with other
nightly or archival backup tasks.

Note: A recovery catalog is only required for KEEP FOREVER. No other KEEP options require a catalog.
根据上述提示,可以修改备份文件的存储位置可以解决这个问题
run {
allocate channel ch1 device type disk;
allocate channel ch2 device type disk;
backup as backupset tag 'full-base-line'
format '/oracle/dbbackup/whole-%s-%t-%u'
keep forever restore point 'full' database plus archivelog;
crosscheck backupset;
release channel ch1;
release channel ch2;
 }

时间: 2024-07-28 16:08:47

rman backup遇到ORA-19811的相关文章

RMAN backup validate database on databases in noarchivelog mode

从11g开始oracle rman允许在非归档模式下备份数据库 sys@rac1>archive log list 数据库日志模式             非存档模式 自动存档             禁用 存档终点            d:\oracle\archive 最早的联机日志序列     42 当前日志序列           44 sys@rac1>host Microsoft Windows [版本 6.1.7600] 版权所有 (c) 2009 Microsoft Corp

Oracle 通过odu验证rman backup对于truncate对象备份处理

通过odu挖rman备份前和备份后的数据文件,得知rman backup备份的过程,对绝大多数truncate的表的原始数据未正常备份(为什么是绝大多数,我无法给出解释),这里也可以看出rman backup并非是真正意义上的完全物理上复制(和rman copy还是有区别,copy不能完全被取代) 创建模拟环境  代码如下 复制代码 SQL> select * from v$version;    BANNER ------------------------------------------

[20171121]rman backup as copy.txt

[20171121]rman backup as copy.txt --//上个星期做数据文件块头恢复时,提到使用rman备份数据文件时,文件头数据库信息是最后写入备份集文件的,在filesperset=1的情况 --//下写入备份集文件中的倒数第2块就是文件头的备份.参考链接: http://blog.itpub.net/267265/viewspace-2147297/=>[20171115]恢复数据文件块头4补充.txt --//而且我最后还做了测试证明如果resotre数据文件,实际上文

[20171121]rman backup as copy 2.txt

[20171121]rman backup as copy 2.txt --//昨天测试backup as copy ,备份时备份文件的文件头什么时候更新.是最后完成后还是顺序写入备份文件. --//我测试的数据文件使用数据文件2(表空间sysaux),也许是文件不够大,应该减慢备份速度来测试看看. 1.环境: SCOTT@book> @ &r/ver1 PORT_STRING                    VERSION        BANNER ----------------

[20171122]rman backup as copy的备份问题

[20171122]rman backup as copy的备份问题.txt --//以前曾经写过一篇[20160524]rman备份与检查点4.txt=>链接:http://blog.itpub.net/267265/viewspace-2106087/ --//里面提到加入备份时间很长,这样可能会出现数据块里面的scn号大于文件头scn号.我提到视图v$backup_datafile --//的ABSOLUTE_FUZZY_CHANGE#字段记录了备份时块最大的scn号.查询视图: sele

zt:Different type of RMAN backup compression in 11G

http://www.itpub.net/viewthread.php?tid=829560&pid=10201894&page=1&extra=#pid10201894 主题: Different type of RMAN backup compression in 11G 文档 ID: 注释:427581.1 类型: REFERENCE 上次修订日期: 31-JUL-2007 状态: REVIEWEDIn this Document Purpose Different type

RMAN-03002, RMAN-06059, ORA-19625 and ORA-27037 When Running RMAN Backup of Archivelogs

RMAN备份数据库时,出现下面错误错误信息: Starting backup at 25-MAY-15 current log archived allocated channel: ORA_DISK_1 channel ORA_DISK_1: sid=953 devtype=DISK RMAN-00571: =========================================================== RMAN-00569: =============== ERROR

使用rman复制数据库

数据|数据库 -------------------------------------------- 实验环境:windows + oracle 10.1.0.2.0 原数据库:ning[归档模式]  复制数据库:test Author:NinGoo    2005-3-27 -------------------------------------------   在同一台server上使用rman的Duplicate Database创建复制数据库.   1.    创建新的instanc

Oracle中如何使用Rman克隆数据库

源库RHEL4.5:192.168.137.199 GLOBAL_NAME=WENDING.LK ORACLE_SID=WENDING 克隆库RHEL4.5:192.168.137.200 GLOBAL_NAME=STRM.LK ORACLE_SID=STRM 1. 全备份源库 $ sqlplus '/as sysdba' 记下备份前的SCN,规复的时间就规复到这个点. SQL> select DBMS_FLASHBACK.GET_SYSTEM_CHANGE_NUMBER from dual;