`
logicgate
  • 浏览: 96383 次
  • 性别: Icon_minigender_1
  • 来自: 新力吐皮
社区版块
存档分类
最新评论

behavior of database backup with "plus archivelog"

阅读更多

The RMAN reference document says that when the plus archivelog command is part of a backup script, RMAN will do:

 

1. runs an alter system archive log current statement
2. runs the backup archivelog all command. Note that if backup optimization is enabled, RMAN only backs up logs that have not yet been backed up

3. backs up the files specified in the BACKUP command
4. runs an alter system archive log current statement

5. backs up any remaining archived redo logs

The behavior of "plus archivelog" depends on whether optimization is enabled or disabled in RMAN. If backup optimization is off (which it is by default in RMAN), plus archivelogs will backup all archivelogs. If the archivelog destination is a flash recovery area, your database may keep very old archivelogs. Thus, the backup size will gradually grow and fill up the flash recovery area, since each backup includes all archivelogs in the flash recovery area.

 

To avoid backing up archivelogs that have already been backed up when using plus archivelog in a backup script, make sure you enable RMAN optimization.

分享到:
评论

相关推荐

    Oracle 11g For Dummies.pdf

    If database administration with Oracle is part of your job, you’ll be glad to have Oracle 11g For Dummies in your cubicle. This nuts-and-bolts guide walks you through the mysteries of Oracle and ...

    RMAN测试演练即讲解

    backup database plus archivelog;(我们清空所有备份delete backup后重头来) (2) 手工备份 backup archivelog all; 6、 备份spfile (1) 备份时自动备份spfile CONFIGURE CONTROLFILE AUTOBACKUP ON在备份...

    我的oracle rman应用实践

    我的oracle rman应用实践,nocatalog,也就是仅使用control file...Full Database backup 目标database是Archivelog模式 备份完成后删除所有的数据文件,包括control file, data file, redo logs, rollback files, etc.

    ORA-00257Oracle释放archivelog空间.doc

    ORA-00257Oracle释放archivelog空间 主要分两步处理:第一步删除物理文件,注意删除的是早期日志;第二步释放逻辑空间,登录RAMN,释放逻辑空间。

    CDC异步autolog archivelog模式配置

    CDC异步autolog archivelog模式配置

    delete archivelog all无法清除归档日志解决方法

    最近在因归档日志暴增,使用delete archivelog all貌似无法清除所有的归档日志,究竟是什么原因呢?本文将为您解答,需要的朋友可以参考下

    最全的oracle常用命令大全.txt

    SQL*Plus: Release 9.2.0.1.0 - Production on Fri Oct 31 13:53:53 2003 Copyright (c) 1982, 2002, Oracle Corporation. All rights reserved. SQL> connect / as sysdba Connected to an idle instance. SQL> ...

    rman备份脚本和rman增量备份脚本分享

    一、单独备份1、经典整库备份:backup as compressed backupset database include current controlfile plus archivelog delete all input;2、tablespace:backup tablespace 名字;3、数据文件:backup datafile n; ...

    oracle - answer

    ALTER DATABASE BACKUP CONTROLFILE TO ‘D:\ORACLE\CONTROL.BKP’; (7) ALTER DATABASE ADD LOGFILE GROUP 4 (‘D:\ORACLE\ORADATA\ORCL\redo04a.log’,’D:\ORACLE\ORADATA\ORCL\redo04b.log’)SIZE 5M; (8)...

    oracle自动清理archivelog文件的具体方法

    介绍了oracle自动清理archivelog文件的具体方法,有需要的朋友可以参考一下

    Oracle删除archivelog文件的正确方法

    Oracle在开启了归档模式后,会在指定的archive目录下产生很多的archivelog文件,而且默认是不会定期清除的,时间长久了,该文件夹会占用很大的空间。那么如何定期正确删除archivelog文件呢?今天小编给大家介绍下

    升级和卸载Oracle数据库软件的命令整理

    >backup full database plus archivelog; 升级 ./runInstall 安装升级包 sqlplus / as sysdba >startup upgrade >@$ORACLE_HOME/rdbms/admin/catupgrd.sql >shutdown immediate >startup >@$ORACLE_HOME/rdbms/...

    Oracle DATAGUARD 配置文档详解

    SQL> alter database archivelog; SQL> alter database open; ...... 日常管理及维护: 一、 dataguard 启动关闭顺序 (1)监听 先启从库再起主库 #lsnrctl start (2)启动 先启从库: SQL> conn /as sysdba SQL> ...

    Oracle数据库可以运行在2种模式下归档模式(archivelog)和非归档模式(noarchivelog

    Oracle数据库可以运行在2种模式下归档模式(archivelog)和非归档模式(noarchivelog).doc

    oracle技术资料

    oracle archivelog restore and backup

    Linux下Oracle归档日志自动清理脚本代码(sh)

    /bin/sh export BACK_DATE=`date +%Y%m%d` export BACKUP_PATH=/home/oracle/dbbak echo `mkdir -p ${BACKUP_PATH}/archivelog/${BACK_DATE}` rman msglog=$BACKUP_PATH/archivelog/${BACK_DATE}/arch_0_$BACK_DATE....

    p28412269_112040_WINNT.zip

    ARCHIVELOG DELETION POLICY BACKED UP N TIMES TO 'SBT_TAPE' IGNORED 12747740 NODE JOIN RECONFIGURATION (PCMREPLAY) DOES NOT SCALE WITH MORE LMS'S 12816846 INTERNAL ERROR WHILE UPDATING COLUMN OF ...

    Oracle+Database+11g+RMAN备份与恢复.pdf

    Oracle 数据库物理体系结构 Oracle 操作内核 ARCHIVELOG模式操作与 NOARCHIVELOG 模式操作 Oracle 恢复模式 Oracle 中的手动备份操作 Oracle 中的手动恢复操作

Global site tag (gtag.js) - Google Analytics