Oracle GoldenGate - Version 12.1.2.0.0 and later: BACKUP ARCHIVELOG NOT BACKED UP 1 TIMES DELETE INPUT does not delete logs even if capture does not need it
说明:上述SQL中找到相关条件 :B1 IS NULL OR FIRST_TIME <= :B1,即first_time <= 'sysdate-7';所以until time的time指的是archivelog的first_time,即归档日志中low scn对应的时间戳,其意思是找出所有low scn timestamp小于指定的时间变量的归档日志. 2.2、delete archivelog all completed before 'sysdate-7' ...
backup archivelog all delete input format 'ZHSVR044_%d_set=%s_piece=%p_date=%T.ARC.rmn'; } 1. 2. 3. 4. 5. 6. 7. 8. 都知道在controlfile中记录着每一个archivelog的相关信息,当然们在OS下把这些物理文件delete掉后,在我们的 controlfile中仍然记录着这些archivelog的信息,在oracle的OEM管理器中...
备份默认目录下所有归档日志,并且删除这个目录下所有归档日志 backup archivelog all delete all input 备份默认目录下所有归档日志,并且删除几个备份目录下所有归档日志
RMAN> backup archivelog all; 3.2 检查以下废弃的备份及文件 RMAN> report obsolete; RMAN retention policy will be applied to the command RMAN retention policy is set to redundancy 1 Report of obsolete backups and copies Type Key Completion Time Filename/Handle ...
RMAN> DELETE ARCHIVELOG ALL; allocated channel: ORA_DISK_1 channel ORA_DISK_1: SID=84 device type=DISK List of Archived Log Copies for database with db_unique_name PROD === Key Thrd Seq S Low Time --- --- --- - --- 107 1 4 A 12-FEB-13 Name: /orcva/PROD/...
archive log filename=+REV/gobo4/archivelog/arch_795194241_1_141.arc recid=216 stamp=797450308 ... piece handle=/install_source/rman_bak/arch_GOBO4_1hnrhli2_1_1 tag=TAG20121129T162806 comment=NONE channel ORA_DISK_1: backup set complete, elapsed time:00:00:09 channel ...
channel ORA_DISK_1: backup set complete, elapsed time: 00:02:15 channel ORA_DISK_1: deleting archive log(s) archive log filename=+REV/gobo4/archivelog/arch_795194241_1_139.arc recid=214 stamp=797450261 archive log filename=+REV/gobo4/archivelog/arch_795194241_1_140.arc recid=215 stamp=...
小结a、delete archivelog all将会毫无保留的删除所有的归档日志(在控制文件中有相应记录的) b、归档日志的信息被记录在控制文件之中,其生存期和可保留的总数也受到控制文件创建初以及参数control_file_record_keep_time限制 c、对于那些已经在控制文件中被覆盖的归档日志,该方式不起作用,使用backup archivelog all dele...
Examine the RMAN configuration parameters:A.it creates image copies of the database files.B.it creates image copies of thearchivelogs.C.it creates abackupsetof archive log filesD.it fails because the DELETE INPUT option can be used only with the BACKUP ASBACKUPSET command.E.it fails because ...