AnyBackup-Oracle backup fails with Oracle error code ORA-01565 and ORA-27037

2019-06-26

Keywords

ORA-01565、ORA-27037

 

Applied Products

· AnyBackup 6.0.x


Symptoms

Oracle backup fails with the following errors at once:

ORA-01565: error in identifying file ‘?dbs/spfile@.ora’

ORA-27037: unable to obtain file status linux-x86_64

Error: 2: No such file or directory Additional information

 

Impact

AnyBackup Oracle backup fails.

 

Cause

AnyBackup failed to create the parameter file (PFILE), because server parameter file (SPFILE) does not exit in ORACLE_HOME/dbs directory.

 

Resolution

Manually create parameter file (PFILE)  by using the server parameter file (SPFILE).

Note: Below is an example of Oracle 11G, you might follow similar steps in other versions of Oracle.

1.Open  alert_ora.log  under the path $ORACLE_BASE/diag/rdbms/DB_NAME/ORACLE_SID/trace/

  vi alert_dorcl.log

2. Locate the parameter file (PFILE), which is /oracle/product/11.2.0/db_1/dbs/initdorcl.ora

Starting up:

Oracle Database 11g Enterprise Edition Release 11.2.0.3.0 - 64bit Production

With the Partitioning, OLAP, Data Mining and Real Application Testing options.

ORACLE_HOME = /oracle/product/11.2.0/db_1

System name:    Linux

Node name:      doracle

Release:        2.6.32-431.el6.x86_64

Version:        #1 SMP Sun Nov 10 22:19:54 EST 2013

Machine:        x86_64

VM name:        VMWare Version: 6

Using parameter settings in server-side pfile /oracle/product/11.2.0/db_1/dbs/initdorcl.ora

3. Create SPFILE with the PFILE.

#su - oracle

$sqlplus / as sysdba

SQL>create spfile from pfile='/oracle/product/11.2.0/db_1/dbs/initdorcl.ora

4. Run the Oracle backup job again.

 

More information

For more information of  parameter file (PFILE) and server parameter file (SPFILE), please refer to Oracle article: Specifying Initialization Parameters.

 

Sales Hotline

+852-3956 4277

Advisory Email

globalsupport@eisoo.com

EISOO FACEBOOK