|Failed to create standby database, how do I resovle it? [message #252990]
||Sat, 21 July 2007 03:30
Registered: January 2007
Location: Ha Noi, Viet Nam
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:
SQL> alter database create standby controlfile as
alter database create standby controlfile as
ERROR at line 1:
ORA-01580: error creating control backup file c:\oracle\oradata\t
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:
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.
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.
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
- My OS is Windows XP services pack 2
- My Database is 184.108.40.206
- Primary Database named as Test using an OID - Oracle Internet Directory.
How do I solve it?
[Updated on: Sat, 21 July 2007 04:18]
Report message to a moderator