Problém:
RMAN-00571: ===========================================================
RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
RMAN-00571: ===========================================================
RMAN-03009: failure of backup command on ORA_DISK_1 channel at 09/02/2017 18:39:47
ORA-19599: blok c. 158800 je poskozen archived log /fra/oratest/test/archivelog/2017_08_25/o1_mf_1_103668_dszxt1n1_.arc
Analýza:
RMAN> validate archivelog all;
List of Archived Logs
=====================
Thrd Seq Status Blocks Failing Blocks Examined Name
---- ------- ------ -------------- --------------- ---------------
1 103664 OK 0 94309 /fra/oratest/test/archivelog/2017_08_25/o1_mf_1_103664_dszps149_.arc
1 103665 OK 0 52240 /fra/oratest/test/archivelog/2017_08_25/o1_mf_1_103665_dszrk8d6_.arc
1 103666 OK 0 68196 /fra/oratest/test/archivelog/2017_08_25/o1_mf_1_103666_dszt9gvx_.arc
1 103667 OK 0 134955 /fra/oratest/test/archivelog/2017_08_25/o1_mf_1_103667_dszw1px9_.arc
1 103668 FAILED 2 185398 /fra/oratest/test/archivelog/2017_08_25/o1_mf_1_103668_dszxt1n1_.arc
1 103669 OK 0 208919 /fra/oratest/test/archivelog/2017_08_25/o1_mf_1_103669_dszzl77t_.arc
Řešení
$ rm /fra/oratest/test/archivelog/2017_08_25/o1_mf_1_103668_dszxt1n1_.arc
!! Dělám denně plnou zálohu, proto mohu archív smazat
RMAN> crosscheck archivelog all;
using target database control file instead of recovery catalog
allocated channel: ORA_DISK_1
RMAN> delete expired archivelog all;
released channel: ORA_DISK_1
allocated channel: ORA_DISK_1
channel ORA_DISK_1: SID=409 device type=DISK
List of Archived Log Copies for database with db_unique_name test
=====================================================================
Key Thrd Seq S Low Time
------- ---- ------- - ---------
103499 1 103668 X 25-AUG-17
Name: /fra/oratest/test/archivelog/2017_08_25/o1_mf_1_103668_dszxt1n1_.arc
Do you really want to delete the above objects (enter YES or NO)? yes
deleted archived log
archived log file name=/fra/oratest/test/archivelog/2017_08_25/o1_mf_1_103668_dszxt1n1_.arc RECID=103499 STAMP=952949345
Deleted 1 EXPIRED objects
RMAN> exit;
Recovery Manager complete.
Normal completion
Removing Lockfile...
Finished Backup at Sun Sep 3 09:35:32 CEST 2017
Komentáře