Redo Log Group, members on a separate disk

Printable View

12-31-2003, 12:32 PM
samdba

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.
12-31-2003, 12:49 PM
davey23uk

creating new ones and dropping old ones
12-31-2003, 01:02 PM
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
12-31-2003, 01:31 PM
davey23uk

thats gonna take a whole lot longer than creating new ones and dropping old ones.

Why make work for yourself?
12-31-2003, 01:52 PM
samdba

Quote:

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,
12-31-2003, 02:16 PM
stecal

Quote:

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?
12-31-2003, 02:18 PM
stecal

Re: Redo Log Group, members on a separate disk

Quote:

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.
12-31-2003, 04:32 PM
davey23uk

Quote:

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
01-01-2004, 04:32 PM
julian

Quote:

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 ? :-)