on 08-12-2006 7:32 AM
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
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
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
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
Ryan,
I seem to have the same BR0253W and BR0252W errors. How did you resolve your "cannot find control file" errors?
Thanks,
Gary Prignon
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
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
User | Count |
---|---|
101 | |
13 | |
13 | |
11 | |
11 | |
7 | |
6 | |
5 | |
4 | |
4 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.