Login  Register

move redolog

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

move redolog

big
442 posts
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
| More
Print post
Permalink

Re: move redolog

ErmanArslansOracleBlog
Administrator
5727 posts
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
| More
Print post
Permalink

Re: move redolog

big
442 posts
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.