Home » RDBMS Server » Server Administration » Failed to create standby database, how do I resovle it?
Failed to create standby database, how do I resovle it? [message #252990] Sat, 21 July 2007 03:30 Go to next message
trantuananh24hg
Messages: 668
Registered: January 2007
Location: Ha Noi, Viet Nam
Senior Member
Dear all!

When I attempted to create a standby database from the primary database following these steps before error occurred:

1/ Check list of control file of primary database
2/ Shutdown and made all copies of these control file
3/ Startup and created control file of standby database. By this step, I found those errors:

Quote:

SQL> alter database create standby controlfile as
2 'c:\oracle\oradata\test\standby\testctl1.ctl';
alter database create standby controlfile as
*
ERROR at line 1:
ORA-01580: error creating control backup file c:\oracle\oradata\t
tctl1.ctl
ORA-27040: skgfrcre: create error, unable to create file
OSD-04002: unable to open file
O/S-Error: (OS 3) The system cannot find the path specified.



Checked with ORA-01580, ORA-27040 errors which got informations:

Quote:

ORA-01580 error creating control backup file string

Cause: An operating system error occurred while attempting to create a control file backup.

Action: Check the error stack for more detailed information.




Quote:

ORA-27040 skgfrcre: create error, unable to create file

Cause: Create system call returned an error, unable to create file.

Action: Verify the file name and permissions.



But I affirmed my below path was not wrong, and I connected to the Primary Database as sysdba, OS with administrator authenticated with sufficiency privileges.

My Test Database is already in Archive mode.
Quote:

SQL> archive log list
Database log mode Archive Mode
Automatic archival Enabled
Archive destination D:\DBArchive\Test
Oldest online log sequence 9
Next log sequence to archive 11
Current log sequence 11



Additional informations:
- My OS is Windows XP services pack 2
- My Database is 9.2.0.1
- Primary Database named as Test using an OID - Oracle Internet Directory.

How do I solve it?

Thank you!

[Updated on: Sat, 21 July 2007 04:18]

Report message to a moderator

Re: Failed to create standby database, how do I resovle it? [message #253028 is a reply to message #252990] Sat, 21 July 2007 10:29 Go to previous message
Michel Cadot
Messages: 64152
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
1/ Are you sure of your directory name? It does not appear in your error message.
2/ Check if oracle owner has the privilege to write into it.

You have to trust Oracle and your OS, if it says "The system cannot find the path specified" then it is true.

Regards
Michel
Previous Topic: Problem In Permission
Next Topic: how to clone oracle10g database
Goto Forum:
  


Current Time: Sat Dec 10 06:38:33 CST 2016

Total time taken to generate the page: 0.16669 seconds