How to Resolve ORA-00308: cannot open archived log

  • by

ORA-00308

Found ORA-00308: cannot open archived log during performing a database point-in-time recovery (DBPITR) by RMAN.

ORA-00308: cannot open archived log '/oradata/ORCL/ARCH/ORCL_1_294150.arc'
ORA-27037: unable to obtain file status
IBM AIX RISC System/6000 Error: 2: No such file or directory
Additional information: 3

ORA-00308 means that the archived log really does not exist, or the archived log does exist, but it cannot be opened for some reason.

Solutions

If the file is existing, please make sure the owner and permission set are correct. For example:

$ ls -l /oradata/ORCL/ARCH/ORCL_1_294150.arc
-rw-r-----   1 root     system   1073741312 Mar 12 20:16 /oradata/ORCL/ARCH/ORCL_1_294150.arc

As you can see, the file belongs to root, not oracle. Possibly the archived log was copied or transferred by root.

So we'd better change the owner back to oracle for further database recovery.

Leave a Reply

Your email address will not be published. Required fields are marked *