Skip to content
Home » Oracle » How to Resolve ORA-00308: cannot open archived log

How to Resolve ORA-00308: cannot open archived log

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 ownership 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. Most likely, the archived log was copied or transferred from another place by root.

Further reading: How RMAN Restore Archivelog to Different Location.

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

# chown -R oracle:oinstall /oradata/ORCL/ARCH

Or you can open all permissions.

# chown -R 777 /oradata/ORCL/ARCH

Leave a Reply

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