RMAN-06059: expected archived log not found

By -
Issue:

RMAN-03002: failure of backup command at 06/22/2017 20:01:47
RMAN-06059: expected archived log not found, loss of archived log compromises recoverability
ORA-19625: error identifying file +SID_ARCH/sid/archivelog/2017_06_17/thread_2_seq_316.11811.946933225
ORA-17503: ksfdopn:2 Failed to open file +SID_ARCH/sid/archivelog/2017_06_17/thread_2_seq_316.11811.946933225
ORA-15012: ASM file '+SID_ARCH/sid/archivelog/2017_06_17/thread_2_seq_316.11811.946933225' does not exist

Cause:

Here during backup of archive logs via RMAN, RMAN try to backup the archive log with sequence 316 thread 2, but actually RMAN can not backup it as this log file does not exist physically there.

So whenever RMAN tries to back it up, it fails hence backup of archive log via RMAN stucks.

Solution:

Go to RMAN:

rman target /

crosscheck archivelog all;

This will mark physically not present file as expired in control file .
Now try to backup the archive log, it will run smoothly.

Best Wishes,
Nikhil Kumar.

Comments

Post a Comment

Popular posts from this blog

How to set the root password after creating instance on oracle cloud

By -
How to set the root password after creating instance on oracle cloud? since you have created instance on oracle cloud, it requires you private .ppk key file to login from putty you can login on your instance by directly providing that private key. and on Linux/Unix defult user is "opc". since during creation of instance it  will not ask you for  root password. You dont need any password to connect to root. to connect to root type below command as opc user. [opc@sts ~]$ sudo su [root@sts opc]# by this you will login as root. Now change your password [root@sts opc]# passwd Changing password for user root. New password: Retype new password: passwd: all authentication tokens updated successfully. [root@sts opc]# All done. Thanks & Regards Nikhil Kumar.
Read more

chmod: changing permissions of extjobO

By -
OPatch found the word "error" in the stderr of the make command. Please look at this stderr. You can re-run this make command. Stderr output: chmod: changing permissions of ‘/testing/app/oracle/product/12.2.0/testing_1/bin/extjobO’: Operation not permitted make: [iextjob] Error 1 (ignored) Statement: This warning is ignorable, as files in bin directory ending with "O" are backups that are created when (re-)linking and it is owned by root hence, changing permission could not be performed. [oracle@Testing02 30593149]$ ll /testing/app/oracle/product/12.2.0/testing_1/bin/extjobO -rwsr-x--- 1 root oinstall 2241432 Nov 18 04:58 /testing/app/oracle/product/12.2.0/testing_1/bin/extjobO
Read more

ORA-39083 ORA-02298 ORA-02374 ORA-1289 parent keys not found and value too large for column DESCRIPTION

By -
Issue: While importing from 11.2.0.4 to 12.2.0.1 DB: ORA-39083: Object type REF_CONSTRAINT:"TEST"."TK_COD_TYPE" failed to create with error: ORA-02298: cannot validate (TEST.TK_COD_TYPE) - parent keys not found Failing sql is: ALTER TABLE "TEST"."CODE" ADD CONSTRAINT "TK_COD_TYPE" FOREIGN KEY ("TYPE") REFERENCES "TEST"."CODEAREA" ("CODEAREA") ENABLE ORA-39083: Object type REF_CONSTRAINT:"TEST"."TK_PDE_RPP_ID" failed to create with error: ORA-02298: cannot validate (TEST.TK_PDE_RPP_ID) - parent keys not found Failing sql is: ALTER TABLE "TEST"."PDE_RPP_RPT_PARAM" ADD CONSTRAINT "TK_PDE_RPP_ID" FOREIGN KEY ("RPT_ID") REFERENCES "TEST"."RPT_REPORT" ("RPT_ID") ENABLE ORA-39083: Object type REF_CONSTRAINT:"TEST"."TK_COD_TYPE" failed to create with error: ORA-02298: cannot vali...
Read more