ORA27091 error while taking backup through BRtools via DB13

[Former Member]

Hi,

I have installed ECC5.0 on Oracle 10.2.02 with SUSE Linux 10.

When I start the backup of SAP system to disk via DB13 I get the following error.

BR0051I BRBACKUP 7.00 (16)

BR0055I Start of database backup: befppthd.afd 2011-04-08 00.04.53

BR0280I BRBACKUP time stamp: 2011-04-08 00.04.53

BR0301E SQL error -27091 at location BrInitOraCreate-5, SQL statement:

'/* BRBACKUP AT PROF_CONN */ CREATE PFILE = '/oracle/EC5/102_64/dbs/sap.ora' FROM SPFILE = '/oracle/EC5/102_64/dbs/spfileEC5.ora''

ORA-27091: unable to queue I/O

ORA-27072: File I/O error

Linux-x86_64 Error: 22: Invalid argument

Additional information: 4

Additional information: 1

Additional information: -1

BR0303E Determination of Oracle version failed

BR0056I End of database backup: befppthd.afd 2011-04-08 00.04.53

BR0280I BRBACKUP time stamp: 2011-04-08 00.04.54

BR0054I BRBACKUP terminated with errors

Kindly help me resolve the issue.

Thanks,

Haroon.

[Former Member · Accepted solution]

Hi,

prior to the backup have you manually changed the Spfile at all ??

Mark

[Former Member · Accepted solution]

I didn't change the spfile manually.

But I switched to no archivelog mode before backup thru following command.

Sql>shutdown immediate;

startup mount;

Alter database noarchivelog;

Alter database open;

Thanks

Haroon

[Former Member · Accepted solution]

Hi,

Try recreating you Spfile and then try again..

Mark

[Former Member · Accepted solution]

Can you please let me know the procedure to recreate SPfile.

Thanks

Haroon

[Former Member · Accepted solution]

Have a read:

http://www.orafaq.com/node/5

[Former Member · Accepted solution]

Also thinking about it.

To test quickly rename the spfile and start the db with the pfile and try again from db13.

Mark

[Former Member · Accepted solution]

Hi Mark,

I tried created spfile but it is not still working.

I don't knw why it tries to create pfile with "sap.ora"

BR0301E SQL error -27091 at location BrInitOraCreate-5, SQL statement:

'/* BRBACKUP AT PROF_CONN */ CREATE PFILE = '/oracle/EC5/102_64/dbs/sap.ora' FROM SPFILE = '/oracle/EC5/102_64/dbs/spfileEC5.ora''

Thanks,

Haroon.

[Former Member · Accepted solution]

Hi,

have you a init<SID>.ora and SPfile.ora

Mark

[Former Member · Accepted solution]

Yes both init<DBSID>.ora and spfile<DBSID>.ora are there existing in the dbs directory.

Thanks

Haroon

[Former Member · Accepted solution]

Hi,

can you rename the Spfile and restart the database and try again....

Mark

[Haroon · Accepted solution]

Hi Mark,

I works now mark...thanks for your valuable comments and reply.

Now I m able to start the backup.

Thanks,

Haroon.

[Former Member · Accepted solution]

Great, it does look like the spile is corupted....

Mark

[Former Member · Accepted solution]

Mark,

Should I have to again create spfile from pfile after the backup completes...or leave as such.

thanks

Haroon