move redolog

classic Classic list List threaded Threaded
3 messages Options
big
Reply | Threaded
Open this post in threaded view
|

move redolog

big
Hi,
On R12.2, DB 11.2.0.4,
We want to move redolog to a new FS.

Then these are the steps:

SQL>shutdown immediate;

mv /u0/logfile.dbf /u1/logfile.dbf

SQL>startup mount
SQL>alter database rename file /u0/logfile.dbf  to /u1/logfile.dbf

Now , should we run:

perl adcfgclone.pl dbconfig  $CONTEXT_FILE

Why?

Thanks
Reply | Threaded
Open this post in threaded view
|

Re: move redolog

ErmanArslansOracleBlog
Administrator
Your operation seems ok.

See the following MOS Note ->

How to Change The Location Of Redo Log Files (Doc ID 395062.1)

We have also a no downtime method -> See section "B. If the database cannot be shut down, it will not possible to rename the files directly : **first add new groups and then drop the non-needed ones."

"perl adcfgclone.pl dbconfig  $CONTEXT_FILE" ? Why? -- Why did this question come to your mind?
big
Reply | Threaded
Open this post in threaded view
|

Re: move redolog

big
In reply to this post by big
Thank you.

The following:
perl adcfgclone.pl dbconfig  $CONTEXT_FILE

is a point of discussion in our teams.

I want to know if it is really necessary to run it.

Regards.