| Failed to create standby database, how do I resovle it? [message #252990] |
Sat, 21 July 2007 03:30  |
trantuananh24hg
Messages: 744
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  |
 |
Michel Cadot
Messages: 68686
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
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
