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.
分享到:
相关推荐
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 ...
backup database plus archivelog;(我们清空所有备份delete backup后重头来) (2) 手工备份 backup archivelog all; 6、 备份spfile (1) 备份时自动备份spfile CONFIGURE CONTROLFILE AUTOBACKUP ON在备份...
我的oracle rman应用实践,nocatalog,也就是仅使用control file...Full Database backup 目标database是Archivelog模式 备份完成后删除所有的数据文件,包括control file, data file, redo logs, rollback files, etc.
ORA-00257Oracle释放archivelog空间 主要分两步处理:第一步删除物理文件,注意删除的是早期日志;第二步释放逻辑空间,登录RAMN,释放逻辑空间。
CDC异步autolog archivelog模式配置
最近在因归档日志暴增,使用delete archivelog all貌似无法清除所有的归档日志,究竟是什么原因呢?本文将为您解答,需要的朋友可以参考下
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> ...
一、单独备份1、经典整库备份:backup as compressed backupset database include current controlfile plus archivelog delete all input;2、tablespace:backup tablespace 名字;3、数据文件:backup datafile n; ...
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在开启了归档模式后,会在指定的archive目录下产生很多的archivelog文件,而且默认是不会定期清除的,时间长久了,该文件夹会占用很大的空间。那么如何定期正确删除archivelog文件呢?今天小编给大家介绍下
>backup full database plus archivelog; 升级 ./runInstall 安装升级包 sqlplus / as sysdba >startup upgrade >@$ORACLE_HOME/rdbms/admin/catupgrd.sql >shutdown immediate >startup >@$ORACLE_HOME/rdbms/...
SQL> alter database archivelog; SQL> alter database open; ...... 日常管理及维护: 一、 dataguard 启动关闭顺序 (1)监听 先启从库再起主库 #lsnrctl start (2)启动 先启从库: SQL> conn /as sysdba SQL> ...
Oracle数据库可以运行在2种模式下归档模式(archivelog)和非归档模式(noarchivelog).doc
oracle archivelog restore and backup
/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....
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 数据库物理体系结构 Oracle 操作内核 ARCHIVELOG模式操作与 NOARCHIVELOG 模式操作 Oracle 恢复模式 Oracle 中的手动备份操作 Oracle 中的手动恢复操作