We have standalone database with physical standby configured for version 12.1.0.2. We are able to delete archive log from production side using RMAN configuration "CONFIGURE ARCHIVELOG DELETION POLICY TO APPLIED ON ALL STANDBY BACKED UP 1 TIMES TO 'SBT_TAPE'; And we have set RMAN policy on s...
crosscheck archivelog all; delete noprompt archivelog all completed before 'sysdate - 1/2' BACKED UP 1 TIMES TO DEVICE TYPE SBT; delete noprompt archivelog all backed up 1 times to DEVICE TYPE SBT completed before 'sysdate-1/2'; backup archivelog all not backed up 1 times; --- # 不备份...
Name: /orcva/PROD/archivelog/2013_02_13/o1_mf_1_15_2x42f0gj_.arc Do you really want to delete the above objects (enter YES or NO)? 例2-78 バックアップ・セットの強制削除 次の例では、タグweekly_bkupを持つバックアップ・セットのコピーを削除します。 RMAN> DELETE NOPROMPT BA...
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
CONFIGURE ARCHIVELOG DELETION POLICY TO BACKED UP 2 TIMES TO DISK; new RMAN configuration parameters are successfully stored 3 验证delete obsolete命令 3.1 备份归档日志 RMAN> backup archivelog all; 3.2 检查以下废弃的备份及文件 RMAN> report obsolete; ...
DELETE NOPROMPT BACKUP BACKED UP 2 TIMES TO DEVICE TYPE sbt;DELETE NOPROMPT COPY BACKED UP 2 TIMES TO DEVICE TYPE sbt; Forcing the Deletion of a Backup Set: Example The following example attempts to delete the backup set copy with tagweekly_bkup: ...
As the redundancy is set to 1, archive log deletion policy for two times will not work. I have used below script which is working fine- run{ allocate channel ch1 type Disk maxpiecesize = 1024M; crosscheck archivelog all; delete noprompt archivelog until time 'SYSDATE-2'; ...
CONFIGURE DEFAULT DEVICE TYPE TO sbt; CONFIGURE ARCHIVELOG DELETION POLICY TO BACKED UP 2 TIMES TO DEVICE TYPE sbt; 次のDELETEコマンドは、構成済の削除方針(ログはテープに2回バックアップする必要がある)を満たす必要がない、ディスク上のすべてのアーカイブREDOログ・ファイルを削除しま...
CONFIGURE DEFAULT DEVICE TYPE TO sbt; CONFIGURE ARCHIVELOG DELETION POLICY TO BACKED UP 2 TIMES TO DEVICE TYPE sbt; 次のDELETEコマンドは、構成済の削除方針(ログはテープに2回バックアップする必要がある)を満たす必要がない、ディスク上のすべてのアーカイブREDOログ・ファイルを削除しま...
CONFIGURE DEFAULT DEVICE TYPE TO sbt; CONFIGURE ARCHIVELOG DELETION POLICY TO BACKED UP 2 TIMES TO DEVICE TYPE sbt; 次のDELETEコマンドは、構成済の削除方針(ログはテープに2回バックアップする必要がある)を満たす必要がない、ディスク上のすべてのアーカイブREDOログ・ファイルを削除しま...