Home » RDBMS Server » Server Utilities » Problem with hot backup script
Problem with hot backup script [message #70471] Tue, 18 June 2002 04:30 Go to next message
krishna
Messages: 141
Registered: October 1998
Senior Member
I wanted to take a hot backup of my database. I ran the script for doing so. The backup stops after the datafiles have been backed up.
The errors in the log file are as follows:

alter database backup controlfile to 'D:hotbackupkriscontrol01.ctl'
*
ERROR at line 1:
ORA-01580: error creating control backup file D:hotbackupkriscontrol01.ctl
ORA-27040: skgfrcre: create error, unable to create file
OSD-04002: unable to open file
O/S-Error: (OS 5) Access is denied.

alter database backup controlfile to 'D:hotbackupkriscontrol02.ctl'
*
ERROR at line 1:
ORA-01580: error creating control backup file D:hotbackupkriscontrol02.ctl
ORA-27040: skgfrcre: create error, unable to create file
OSD-04002: unable to open file
O/S-Error: (OS 5) Access is denied.

alter database backup controlfile to 'D:hotbackupkriscontrol03.ctl'
*
ERROR at line 1:
ORA-01580: error creating control backup file D:hotbackupkriscontrol03.ctl
ORA-27040: skgfrcre: create error, unable to create file
OSD-04002: unable to open file
O/S-Error: (OS 5) Access is denied.

1 NOT ACTIVE 18-06-2002 16:48
2 NOT ACTIVE 18-06-2002 16:48
3 NOT ACTIVE 18-06-2002 16:47
4 NOT ACTIVE 18-06-2002 16:48
5 NOT ACTIVE 18-06-2002 16:47
6 NOT ACTIVE 18-06-2002 16:48
7 NOT ACTIVE 18-06-2002 16:47
8 NOT ACTIVE 18-06-2002 16:52
9 NOT ACTIVE 18-06-2002 16:52

Can u tell me what i should do to set this right?
Re: Problem with hot backup script [message #70472 is a reply to message #70471] Tue, 18 June 2002 06:23 Go to previous message
Grant
Messages: 578
Registered: January 2002
Senior Member
Are you running this as a system job? Does this work interactively? If so you need to put the user running the job in the Admin group and grant access to the D drive. If you do not want the system user to be in the admin group you will need to create a user and put them in the admin group and run the job under that user after you have granted access to the D drive.
Previous Topic: SQL Loader
Next Topic: Returning Sqlldr Error messages in VB
Goto Forum:
  


Current Time: Mon Apr 29 09:56:59 CDT 2024