| adding online redo logfile group [message #302165] |
Sun, 24 February 2008 06:25  |
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 #302172 is a reply to message #302166] |
Sun, 24 February 2008 08:18  |
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?
|
|
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
