例如:backup database plus archivelog delete all input;执行此命令是会将所有的归档日志进行备份,并且在备份的同时删除已备份的归档日志。 所以如果在RMAN备份脚本中有plus archivelog 参数就无需在备份归档日志之前执行: sql 'alter system archive log current'; ...
archive log filename=/u01/app/oracle/flash_recovery_area/YTHDB/archivelog/2010_04_28/o1_mf_1_34_5xhvxwgz_.arc recid=7 stamp=717528012 Finished backup at 28-APR-10 命令中的关键字all个人理解有2层含义: 1.表示当前归档日志之前的所有日志。所以我们在备份执行要先加入一句crosscheck archivelog all;...
1.2 RMAN> backup database plus archivelog delete input; //备份全库及控制文件、参数文件与所有归档日志,并删除旧的归档日志 1.3 RMAN> backup database format '/u01/myrman/%s_bak' plus archivelog delete input skip inaccessible; 1.4 RMAN> backup incremental level 0 database; //0级增量备份,省略diff...
RMAN> backup database plus archivelog delete input; (备份全库及控制文件、服务器参数文件与所有归档的重做日志,并删除旧的归档日志) 备份表空间: RMAN> backup tablespace system plus archivelog delete input; (备份指定表空间及归档的重做日志,并删除旧的归档日志)_ 备份归档日志: RMAN> backup archivelog all...
RMAN>LIST BACKUP OF DATABASE; 列出指定表空间的备份信息: RMAN>LIST BACKUP OF TABLESPACE SYSTEM; 列出指定数据文件的备份信息: RMAN>LIST BACKUP OF DATAFILE 4; 列出归档日志的备份信息: RMAN>LIST BACKUP OF ARCHIVELOG ALL; 1.2、删除备份信息
Backup database 或者 Backup as compressed backupset database 将数据库作为压缩的备份集来备份 C:/Users/Administrator.DavidDai>rman target '/@orcl as sysdba'; 恢复管理器: Release 11.2.0.1.0 - Production on 星期一 6月 21 23:24:47 2010 ...
RMAN configuration parameters for database with db_unique_name MAA are: CONFIGURE DEVICE TYPE DISK PARALLELISM 1 BACKUP TYPE TO BACKUPSET; # default – 表示默认为备份集备份 backup其实更正确的命令为backup as backupset。执行该命令的时候数据库必须在MOUNT或是OPEN状态,如果是OPEN状态,那么数据库必须运行于...
I am trying to set up rman scripts to backup oracle 10.2.0.2 database. I can simply use: backup database plus archivelog Can I add: format '/dbbackups_odb/%T_archivelog_%d_%e_%u'; before the PLUS ARCHIVELOG, I also want to set a tag for the archivelog ...
8CONFIGURE ARCHIVELOG BACKUP COPIES FOR DEVICE TYPE DISK TO 1; # default 9CONFIGURE MAXSETSIZE TO UNLIMITED; # default 10CONFIGURE ENCRYPTION FOR DATABASE OFF; # default 11CONFIGURE ENCRYPTION ALGORITHM 'AES128'; # default 12CONFIGURE COMPRESSION ALGORITHM 'BASIC' AS OF RELEASE 'DEFAULT' OPTIMIZE...
在执行备份时,可以使用RMAN命令BACKUP结合FORMAT选项来指定备份集的名称格式,并通过TO DIRECTORY指定多个备份目录。 “`sql BACKUP DATABASE PLUS ARCHIVELOG TO DIRECTORY=’/backup_dir1′ BACKUPSET SERIES INCREAMENTAL LEVEL=0 TAG=’full_backup’ VALID FOR DAYS=7 ...