-
Redo Log Group, members on a separate disk
Hi all,
Happy New Year to all.
We have two Redo log groups having 3 members each. But, since the begining, all members of a particular log group are on the same disk. Oracle recommends to have members of the same group on a separate disk so that in case a particular disk fails, we do not loose all members and there is no need to do database recovery.
Now, pl. tell me what is the procedure for relocating the members on separate disks.
Thanks in Adv.
Sam
------------------------
To handle yourself, use your head. To handle others, use your heart
-
creating new ones and dropping old ones
-
HI,
1. Backup the Database ( For Security Reason)
2. Using operating system method copy the online redolog files to
the new location
3. Alter database rename file (from) to (destination)
4. Backup the ControlFile
Seelan
-
thats gonna take a whole lot longer than creating new ones and dropping old ones.
Why make work for yourself?
-
Originally posted by davey23uk
thats gonna take a whole lot longer than creating new ones and dropping old ones.
Davey23uk,
Do I need to open the database in Restricted mode to do this or I can do it online?
Thanks,
Sam
------------------------
To handle yourself, use your head. To handle others, use your heart
-
Originally posted by seelan
HI,
1. Backup the Database ( For Security Reason)
2. Using operating system method copy the online redolog files to
the new location
3. Alter database rename file (from) to (destination)
4. Backup the ControlFile
Seelan
Does the word "fuzzy" have any meaning for you?
-
Re: Redo Log Group, members on a separate disk
Originally posted by samdba
Hi all,
Happy New Year to all.
We have two Redo log groups having 3 members each. But, since the begining, all members of a particular log group are on the same disk. Oracle recommends to have members of the same group on a separate disk so that in case a particular disk fails, we do not loose all members and there is no need to do database recovery.
Now, pl. tell me what is the procedure for relocating the members on separate disks.
Thanks in Adv.
Great question to research on your own given that you've stated you want to get certified.
-
Davey23uk,
Do I need to open the database in Restricted mode to do this or I can do it online?
Thanks,
No you can do it online, which is good.
I will leave it to you to work out how its done
-
Originally posted by seelan
HI,
1. Backup the Database ( For Security Reason)
2. Using operating system method copy the online redolog files to
the new location
3. Alter database rename file (from) to (destination)
4. Backup the ControlFile
Seelan
Really ? :-)
Oracle Certified Master
Oracle Certified Professional 6i,8i,9i,10g,11g,12c
email: ocp_9i@yahoo.com
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
Click Here to Expand Forum to Full Width
|