可以看到所谓的冗余策略不管是天数还是副本数量,保证的都是你冗余时间或者副本最早的那一个FULL BACKUP DATABASE(FULL BACK 或者LEVEL 0增量备份)是能够恢复的,而早于这个FULL BACKUP以前的增量备份和归档日志或者其他备份都是失效的。简单的说delete obsolete会删除已经没有用的不用于恢复的归档日志。 根据以上内容,我...
数据文件:RMAN>backup datafile n; (n:详细的数据文件编号select file_name,file_id,tablespace_name from dba_data_files;) 控制文件:RMAN>backup current controlfile; 或者RMAN>backup database include current controlfile; 日志文件:RMAN>backup archivelog all; 或者RMAN>backup database plus archivelog; 參数...
backup as backupset incremental level 0 section size 32g database plus archivelog section size 32g DELETE ALL INPUT;While on another server with same OS and RDBMS version and similar hardwares (even less CPUs), RMAN backup takes 6 hours to complete. Part of sample script:...
6: 配置catalog数据库,并且把源库注册到catalog管理库上,并且通过catalog库的RMAN来备份源库:backup full database ;备份好后,用scp命令复制到辅助实例的机器上。 7:开始复制命令DUPLICATE TARGET DATABASE TO SGPMDB nofilenamecheck; 以下是详细的步骤: 计划把172.19.201.240上的SGPMDB复制到172.19.4.1服务器,目录结...
最小天数的理解:假设我们设置为7天,那如果我有10天前(甚至更早)的datafile backup和controlfile backup+至今的全部日志,就不能完全恢复了嘛?这是否定的,因为rman元数据保留在控制文件可重用区,如果7天内的备份记录没有把可重用区装满,就算过了7天你的备份记录还是存在的,可以正常完全恢复。如果7天内可重用区被装满...
format '/backup/archlog/arch_%d_%T_%s'; } exit 1. 2. 3. 4. 5. 6. 7. 8. 9. 10. 如果归档日志需要备份两份,在RMAN中可以直接设置进行修改。需要在备份集中用%c的命令格式能备份成功。示例如下: %c Copy number for multiple copies in a duplexed backup 备份片的多个copy的序号 ...
Rman> backup database; 此命令执行后,将对目标数据库中的所有数据库文件进行备份,由于,没有显式指定format参数,rman会自动为每个备份片命令,并保存在Oracle_home/database目录下。只要数据库的数据量不是很大,整个过程执行速度非常快。 如果需要备份到指定目录,则执行一下命令: ...
RMAN> backup full database; Starting backup at 09-OCT-06 allocated channel: ORA_DISK_1 channel ORA_DISK_1: sid=527 devtype=DISK file 4 is excluded from whole database backup channel ORA_DISK_1: starting full datafile backupset channel ORA_DISK_1: specifying datafile(s) in backupset ...
[dmdba@localhost ~]$ /soft/dsc/dmdbms/bin/dmrman use_ap=2 dcr_ini=/soft/dsc/config/dmdcr.inidmrman V8RMAN> BACKUP DATABASE '/soft/dsc/config/dsc0_config/dm.ini' FULL BACKUPSET '/soft/dsc/bak/BACKUP_FILE';BACKUP DATABASE '/soft/dsc/config/dsc0_config/dm.ini' FULL BACKUPSET '...
backup tag t_SPFILE spfile format '/u01/app/dbbackup/%d_%T_%s_%p_SPFILE'; backup AS COMPRESSED BACKUPSET full database tag t_FULL format '/u01/app/dbbackup/%d_%T_%s_%p_FULL' ; sql 'alter system archive log current'; backup tag t_ARCHIVE AS COMPRESSED BACKUPSET archivelog all format...