Error:
RMAN-03002: failure of backup command at 01/13/2014 07:02:54
RMAN-06059: expected archived log not found, lost of archived log compromises recoverability
ORA-19625: error identifying file /u01/app/oracle/product/11.1.0/db_1/dbs/arch1_3978_813813738.dbf
ORA-27037: unable to obtain file status
Cause: The archived log was not found. The repository thinks it does exist. If the archived log has in fact been lost and there is no backup, then the database is no longer recoverable across the point in time covered by the archived log. This may occur because the archived log was removed by an outside utility without updating the repository.
Solution: Check that archived log has been removed with an outside utility and the archivelog has already been backed up, then you can run CROSSCHECK ARCHIVELOG ALL. and try to take the backup again. Suggested script given below
backup current controlfile format '/back/rmaback/ORCL_%u_%s_%p_%T.ctl';
sql 'alter system switch logfile';
BACKUP DATABASE FORMAT '/back/rmaback/ORCL_%u_%s_%p_%T.DBF' TAG 'DATAFILE_BACKUP';
backup archivelog all format '/back/rmaback/ORCL_%u_%s_%p_%T.arch';
backup SPFILE FORMAT '/back/rmaback/ORCL_SPFILE_%u_%s_%p_%T.ORA' TAG 'SPFILE_BACKUP' ;
CROSSCHECK BACKUPSET;
CROSSCHECK ARCHIVELOG ALL;
DELETE noprompt OBSOLETE;
delete noprompt archivelog until time 'sysdate-7';
backup format '/back/rmaback/ORCL_%s_%t_%T_%p.ctl' current controlfile;
Cheers....
RMAN-03002: failure of backup command at 01/13/2014 07:02:54
RMAN-06059: expected archived log not found, lost of archived log compromises recoverability
ORA-19625: error identifying file /u01/app/oracle/product/11.1.0/db_1/dbs/arch1_3978_813813738.dbf
ORA-27037: unable to obtain file status
Cause: The archived log was not found. The repository thinks it does exist. If the archived log has in fact been lost and there is no backup, then the database is no longer recoverable across the point in time covered by the archived log. This may occur because the archived log was removed by an outside utility without updating the repository.
Solution: Check that archived log has been removed with an outside utility and the archivelog has already been backed up, then you can run CROSSCHECK ARCHIVELOG ALL. and try to take the backup again. Suggested script given below
backup current controlfile format '/back/rmaback/ORCL_%u_%s_%p_%T.ctl';
sql 'alter system switch logfile';
BACKUP DATABASE FORMAT '/back/rmaback/ORCL_%u_%s_%p_%T.DBF' TAG 'DATAFILE_BACKUP';
backup archivelog all format '/back/rmaback/ORCL_%u_%s_%p_%T.arch';
backup SPFILE FORMAT '/back/rmaback/ORCL_SPFILE_%u_%s_%p_%T.ORA' TAG 'SPFILE_BACKUP' ;
CROSSCHECK BACKUPSET;
CROSSCHECK ARCHIVELOG ALL;
DELETE noprompt OBSOLETE;
delete noprompt archivelog until time 'sysdate-7';
backup format '/back/rmaback/ORCL_%s_%t_%T_%p.ctl' current controlfile;
Cheers....
Jadwal Resmi Laga Ayam SV388 14 Maret 2019 - Kamis, 14 Maret 2019 – Pada Hari Tersebut Akan Di Laksanakan Berbagai Pertandingan Sabung Ayam Secara Live di Arena Sabung Ayam Thailand.
ReplyDeleteSitus Judi Sabung Ayam Online SV388 Merupakan Situs Judi Asal Thailand Yang Sangat Terkenal Dengan Permainan Sabung Ayam Yang Fair dan Menghibur Para Penonton Judi Sabung Ayam.
Untuk Info Lebih Lanjut Bisa Hub kami Di :
wechat : bolavita
line : cs_bolavita
whatsapp : +628122222995
BBM: BOLAVITA