OraFAQ Forum: Server Administration » adding online redo logs

Home » RDBMS Server » Server Administration » adding online redo logs

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

adding online redo logs [message #253794]

Tue, 24 July 2007 17:50

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

Report message to a moderator

Re: adding online redo logs [message #253796 is a reply to message #253794]

Tue, 24 July 2007 18:09

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.

Report message to a moderator

Re: adding online redo logs [message #253798 is a reply to message #253794]

Tue, 24 July 2007 18:19

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.

Report message to a moderator

Re: adding online redo logs [message #253840 is a reply to message #253794]

Wed, 25 July 2007 01:14

Michel Cadot
Messages: 68686
Registered: March 2007
Location: Nanterre, France, http://...

Senior Member
Account Moderator

Remote drives are not supported by Oracle on Windows.

Regards
Michel

Report message to a moderator

Re: adding online redo logs [message #253898 is a reply to message #253840]

Wed, 25 July 2007 04:57

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).

Report message to a moderator

Re: adding online redo logs [message #254017 is a reply to message #253794]

Wed, 25 July 2007 09:16

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.

Report message to a moderator

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

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Thu Sep 19 23:28:17 CDT 2024