DB13 can not find the correct controlfile.

[Former Member]

My environment is

Win2003

Oracle 10g

Ecc 6.0

When I use DB13 for the full offline backup, I get the following message:

BR0051I BRBACKUP 7.00 (13)

BR0055I Start of database backup: bdtelngh.afd 2006-08-02 21.01.03

BR0252W Function remove() failed for 'D:\oracle\DEV\102\database\sap.ora' at location BrInitOraCreate-1

BR0253W errno 13: Permission denied

BR0252W Function remove() failed for 'D:\oracle\DEV\102\database\sap.ora' at location BrInitOraCopy-7

BR0253W errno 13: Permission denied

BR0166I Parameter 'control_files' not found in file D:\oracle\DEV\102\database\initDEV.ora - default assumed

BR0274W File 'D:\oracle\DEV\102\database\CTL1DEV.ORA' not found

BR0101I Parameters

Name Value

oracle_sid DEV

oracle_home D:\oracle\DEV\102

oracle_profile D:\oracle\DEV\102\database\initDEV.ora

sapdata_home D:\oracle\DEV

sap_profile D:\oracle\DEV\102\database\initDEV.sap

backup_mode ALL

backup_type offline_force

backup_dev_type disk

backup_root_dir D:\oracle\DEV\sapbackup

compress yes

compress_cmd D:\usr\sap\DEV\SYS\exe\nuc\NTI386\mkszip -c $ > $

uncompress_cmd D:\usr\sap\DEV\SYS\exe\nuc\NTI386\uncompress -c $ > $

exec_parallel 0

system_info SAPServiceDEV JXCDEV Windows 5.2 Build 3790 Service Pack 1 Intel

oracle_info DEV 10.2.0.2.0 8192 1870 13112942

sap_info 700 SAPSR3 DEV U0388471103 R3_BASIS 0002894446

make_info NTintel OCI_10103_SHARE Apr 2 2006

command_line brbackup -u / -jid ALGOF20060802210000 -c force -t offline_force -m all -p initDEV.sap -w use_dbv -a -c force -p initDEV.sap -s -w

BR0116I ARCHIVE LOG LIST before backup for database instance DEV

Parameter Value

Database log mode Archive Mode

Automatic archival Enabled

Archive destination D:\oracle\DEV\oraarch\DEVarch

Archive format ARC%S_%R.%T

Oldest online log sequence 1867

Next log sequence to archive 1870

Current log sequence 1870 SCN: 13112942

Database block size 8192 Thread: 1

BR0118I Tablespaces and data files

Tablespace TS-Status F-Status File Size Id. Device Link Type MaxSize IncrSize BlkSize

PSAPSR3 ONLINE* ONLINE+ D:\ORACLE\DEV\SAPDATA1\SR3_1\SR3.DATA1

.......

BR0120I Control files

File Size Id. Device Link Type

D:\oracle\DEV\102\database\CTL1DEV.ORA 8192 0 0 NOLINK FILE

BR0280I BRBACKUP time stamp: 2006-08-02 21.01.09

......

BR0115I Compression rate for all files 5.8422:1

BR0056I End of database backup: bdtelngh.afd 2006-08-03 06.07.57

BR0280I BRBACKUP time stamp: 2006-08-03 06.07.59

BR0053I BRBACKUP completed successfully with warnings

BR0280I BRBACKUP time stamp: 2006-08-03 06.07.59

BR0291I BRARCHIVE will be started with options '-U -jid ALGOF20060802210000 -d disk -c force -p initDEV.sap -s -w'

BR0280I BRBACKUP time stamp: 2006-08-03 06.08.06

BR0292I Execution of BRARCHIVE finished with return code 1

1.It seems the correct control file can not been found.

I have checked the file "initDEV.ora" and spfile.In them the positions of control file are "/origlogA/cntrl","/origlogB/cntrl" and "/sapdata1/cntrl".

So I donot know why the process of DB13 cannot find the correct control file and search the file CTL1DEV.ORA.

Because the correct control file could not been backuped,I can not restore and recover the database.

What causes it?

2.

BR0252W Function remove() failed for 'D:\oracle\DEV\102\database\sap.ora' at location BrInitOraCreate-1

BR0253W errno 13: Permission denied

BR0252W Function remove() failed for 'D:\oracle\DEV\102\database\sap.ora' at location BrInitOraCopy-7

BR0253W errno 13: Permission denied

How can I solve this warning? And why it occurs?

Anyone can help me?

Thanks!

Ryan Fung

[Former Member]

Hi Ryan,

Change the permissions of "D:\oracle\DEV\102" folder, and give full control permissione for the groups

ORA_<SID>_DBA

ORA_<SID>_OPER

ora_dba.

Let me know if this works, we had the same issue and by changing the permissions for the 102, folder solved the issue.

Thanks

Praveen

[Former Member]

Praveen,

I had the same problem as Ryan and Gary on a new XI \ Oracle 10g installation and your suggestion did solve this. It seems that when you run the first BRTOOLS based backup, Oracle tries to create a PFILE from the automatically generated SPFILE, but the DB user doesn't have rights to delete the SAP.ORA file. Once you assign SAP_<SAPSID>_GOBALADMIN full rights to the Oracle folder, an updated INIT<SID>.ORA is generated and the default SAP.ORA is deleted on the next BRTOOLS backup run.

Thanks for the tip.

Rgds,

Andrew

[Former Member]

Ryan,

I seem to have the same BR0253W and BR0252W errors. How did you resolve your "cannot find control file" errors?

Thanks,

Gary Prignon

[Former Member]

Hi Gary,Ryan,

It seems that the backup process is indicating the wrong cntrl file.the path should be like this- <Drive>:\oracle\<SID>\origlogA\cntrl\cntrlER3.dbf','<Drive>\oracle\<SID>\sapdata1\system_1\cntrl\cntrlER3.dbf','<DRIVE>\oracle\<SID>\saparch\cntrl\cntrlER3.dbf'Check your entries in init<SID>.ora in oracle:\ora<version>\database

Let me know if it works or not.

Regards,

Sabita