Home » RDBMS Server » Server Administration » adding online redo logfile group (9i)
adding online redo logfile group [message #302165] Sun, 24 February 2008 06:25 Go to next message
mandygrewalindia
Messages: 14
Registered: February 2008
Location: india
Junior Member
my database has three redolog groups 1,2,3
i want to create fourth group n gave this command:

alter database add logfile group 4
('oracle\oradata\admin\redo04.log')
size 1M;
it gives following errors:
ora 00301:erro in adding lof file(path) file cant be created
ora-27040 skgfrcre :create error, unable to create file
osd-04002 unable to open file
o/s error<os 3> the system cant find the path specified

please help
the path i gave is for new log group.




Re: adding online redo logfile group [message #302166 is a reply to message #302165] Sun, 24 February 2008 07:34 Go to previous messageGo to next message
Mahesh Rajendran
Messages: 10672
Registered: March 2002
Location: oracleDocoVille
Senior Member
Account Moderator
Quote:
o/s error<os 3> the system cant find the path specified

Explains it all in simple language.
Quote
('oracle\oradata\admin\redo04.log')


you are missing the the drive name in the full path.
c:\oracle\...
or
Whatever
Re: adding online redo logfile group [message #302167 is a reply to message #302166] Sun, 24 February 2008 07:39 Go to previous messageGo to next message
mandygrewalindia
Messages: 14
Registered: February 2008
Location: india
Junior Member
thank u so much
it worked
Re: adding online redo logfile group [message #302172 is a reply to message #302166] Sun, 24 February 2008 08:18 Go to previous messageGo to next message
mandygrewalindia
Messages: 14
Registered: February 2008
Location: india
Junior Member
k this worked
i hav to rename online redolog files
redo01.log, redo02.log, redo03.log
cmd is
alter database rename file
'D:\oracle\oradata\admin\redo01.log'
to
'D:\oracle\oradata\admin\redo001.log';
it says invalid file name
n if i have to rename more than one redo log file how do i do?
Re: adding online redo logfile group [message #302174 is a reply to message #302172] Sun, 24 February 2008 09:27 Go to previous message
Mahesh Rajendran
Messages: 10672
Registered: March 2002
Location: oracleDocoVille
Senior Member
Account Moderator
http://download-uk.oracle.com/docs/cd/A97630_01/server.920/a96521/onlineredo.htm#273

And with these,
>>k this worked
>>n if i have to rename ..
I can only assume you have a broken keyboard.
Previous Topic: Differences between Oracle SID / Instance/ Listener / Service or Service_Name / Database
Next Topic: Status Invalid for Synonym
Goto Forum:
  


Current Time: Sun Dec 04 22:40:18 CST 2016

Total time taken to generate the page: 0.08589 seconds