Fulll database backup problem

[Former Member]

Dear Team ,

During Full Online backup . I am facing the problem . The BRBACKUP Detail Log is

BR0051I BRBACKUP 7.00 (18)

BR0055I Start of database backup: bdzbskui.fnt 2008-10-21 09.42.40

BR0477I Oracle pfile /oracle/PRD/102_64/dbs/initPRD.ora created from spfile /oracle/PRD/102_64/dbs/spfilePRD.ora

BR0280I BRBACKUP time stamp: 2008-10-21 09.42.41

BR0301E SQL error -1587 at location BrCtlCopy-1, SQL statement:

'/* BRBACKUP */ ALTER DATABASE BACKUP CONTROLFILE TO '/oracle/PRD/sapbackup/cntrlPRD.dbf''

ORA-01587: error during control file backup file copy

ORA-27091: unable to queue I/O

ORA-27072: File I/O error

HPUX-ia64 Error: 2: No such file or directory

Additional information: 4

Additional information: 195

Additional information: 417792

BR0320E Copying of control file to /oracle/PRD/sapbackup/cntrlPRD.dbf failed

BR0314E Collection of information on database files failed

BR0056I End of database backup: bdzbskui.fnt 2008-10-21 09.42.41

BR0280I BRBACKUP time stamp: 2008-10-21 09.42.41

BR0054I BRBACKUP terminated with errors

please help

manu

[Former Member · Accepted solution]

The log clearly says you are missing a copy of coltol file. Pls copy it

[Former Member · Accepted solution]

from where i will copy the control file and witch location past thsi file.

thanks for your help

manu

[Former Member · Accepted solution]

give output of show pramater control_files;

[Former Member · Accepted solution]

Thanks for your repply,

How I show pramater control_files; IF I lose or corrept Control Files . is my databse will run ?

Because everything is working file. only backup giving the problem.

Thanks

manu

[Former Member · Accepted solution]

Database has three control files by default.

you can get the details by executing sqlplus command show parameter control_files;

copy one of the control file from above location (sqlplus result) to /oracle/PRD/sapbackup/cntrlPRD.dbf' (Make sure you execute correct command while copying)

Regards,

-Sunil

[Former Member · Accepted solution]

Note 491160 - Restore scenarios for lost files of oracle databases

is my databse will run ?

if your dispatcher is connecting to DB with any issues DB must be running fine.

If control files are corrupted Database will never mount.

to make sure

login as SIDADM to O/S

Go to-cmd prompt - sqlplus / as sydba

SQL>startup

If any errors that must be displayed in the above process.

Whats DB & O/S.

Whats ur backup device.

Have u set the initialization files.

Note 13550 - Using BRBACKUP and BRARCHIVE

[Former Member · Accepted solution]

Thanks for your repply.

Sunil this is my Production server.Can I do online copy and past in given location /oracle/PRD/sapbackup/cntrlPRD.dbf' . Because my Redolog backup working perfectelly . But problem only when I am doing " Full Online database backup "Its giving immediate error.

Thanks

Manu

[Former Member · Accepted solution]

one active control file is enough for database to run, you can do copy/paste on line, but make sure that what you do. make sure that all the control files are in same in size.

i suggest you make a copy of existing control file and then perform copy.

For example the control files details:

SQL> show parameter control_files;

NAME TYPE VALUE

-

---

-

---

-

---

control_files string /oracle/PRD/sapdata1/cntrl/cntrlPRD.dbf,

/oracle/PRD/sapdata2/cntrl/cntrlPRD.dbf,

/oracle/PRD/saparch/cntrl/cntrlPRD.dbf

cheers,

-Sunil

[Former Member · Accepted solution]

Thanks for sunil your help. One of my saparch was 100% .I have just delete some file from this .

Now its working fine.

Thanks

manu

[Former Member · Accepted solution]

why you delete the production archive files instead taking backup to tape or other filesyetms?

schedule daily archive log backup, these files require if your database crashes and want to restore your database from your last online/offline backup to restore until time to avoid data loss.

cheers,

-Sunil

[Former Member]

Dear Manu

why dont you upgrade your BRTOOLS

regards

George

[Former Member]

ORA-27091: unable to queue I/O

Note 914177 - File system reiserfs Oracle parameter filesystemio_options

Before editing files in take a backup of files

pls set the parameter in intisid.ora file.

FILESYSTEMIO_OPTIONS = ASYNCH