Home » RDBMS Server » Server Administration » adding online redo logs
adding online redo logs [message #253794] Tue, 24 July 2007 17:50 Go to next message
p_cool
Messages: 2
Registered: June 2007
Junior Member
Hi,

I'm getting an error message when trying to add a 2nd online redo logs to a map drive..

SQL> alter database add logfile member 'Y:\FOLDER\log\R2b_PF.LOG' to group 3;
alter database add logfile member 'Y:\FOLDER\log\R2b_PF.LOG' to group 3
*
ERROR at line 1:
ORA-00301: error in adding logfile 'Y:\FOLDER\log\R2b_PF.LOG' -
file cannot be created
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.


can the online redo log be on a remote drive (e.g. mapped drive)?

THanks
Re: adding online redo logs [message #253796 is a reply to message #253794] Tue, 24 July 2007 18:09 Go to previous messageGo to next message
DreamzZ
Messages: 1666
Registered: May 2007
Location: Dreamzland
Senior Member
Quote:
O/S-Error: (OS 3) The system cannot find the path specified

Double check the path
check permissions.
Re: adding online redo logs [message #253798 is a reply to message #253794] Tue, 24 July 2007 18:19 Go to previous messageGo to next message
ebrian
Messages: 2794
Registered: April 2006
Senior Member
In order to do this on Windows, you have to configure the Windows Oracle Service to start with the oracle user account. However, I would not recommend putting redo logs on mapped drives.
Re: adding online redo logs [message #253840 is a reply to message #253794] Wed, 25 July 2007 01:14 Go to previous messageGo to next message
Michel Cadot
Messages: 64111
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
Remote drives are not supported by Oracle on Windows.

Regards
Michel
Re: adding online redo logs [message #253898 is a reply to message #253840] Wed, 25 July 2007 04:57 Go to previous messageGo to next message
ebrian
Messages: 2794
Registered: April 2006
Senior Member
It's not a matter of it not being supported, just not recommended (Accessing Data Files and Log Files on Remote Computers).
Re: adding online redo logs [message #254017 is a reply to message #253794] Wed, 25 July 2007 09:16 Go to previous message
p_cool
Messages: 2
Registered: June 2007
Junior Member
Thanks for all your reply...

the main reason for doing this is to backup the online redo logs to a standby machine just in-case a failure occurred before it writes to an archive log file.

Previous Topic: ORACLE NOT AVAILABLE
Next Topic: UNDO size increasing at very high speed
Goto Forum:
  


Current Time: Tue Dec 06 00:25:39 CST 2016

Total time taken to generate the page: 0.25187 seconds