Re: Changing redo logs location after incomplete recovery

Hi,
  Can we also use 'SET NEWNAME' along with SWITCH commands for the same? or use LOG_FILE_NAME CONVERT?
They come with RMAN.
  The reason I am asking is I want to know if there are any undocumented errors using them. I have seen similar advise of using ALTER DATABASE RENAME FILE elsewhere recently.
  On 8/29/05, Stalin <stalinsk_at_gmail.com> wrote:
>
> Jerome,
>
> Before resetlogs, you can change redologs location via alter database
> rename command.
>
> for e.g.
> alter database rename file 'oldpath/redo.log' to 'newpath/redo.log';
>
> you need to do the same for the ones you wanted to move to a different
> location and then issue resetlogs.
>
> Regards,
> Stalin
>
> On 8/29/05, Vitalis Jerome <vitalisman_at_gmail.com> wrote:
> > Hi,
> >
> > Let's say there are 3 redo log groups that aren't mirrored. They are
> > all located in one filesystem /fs1/ (for simplicity). The database is
> > in archivelog mode. It has been backed up with RMAN, and the archived
> > logs as well.
> >
> > The database is lost and we want to restore & recover it to the latest
> > log sequence on tape. It's easy with RMAN.
> >
> > But before opening the database in resetlogs mode, we have to change
> > the location of the redo logs from /fs1/ (no longer existent) to /fs2/
> > How can we do that?
> >
> > My idea was to create new logfile groups on /fs2/ before the
> > resetlogs, but it seemed impossible to switch from the "current" log
> > on /fs1/. Of course
> > alter database clear unarchived logfile '/fs1/...';
> > didn't work since the file did not exist.
> >
> > Eventually I created a symlink /fs1/.../current_redo_path to /fs2/ and
> > let "alter database open resetlogs;" create it there. Afterwards I
> > dealt with the switching/dropping of this log group without any
> > difficulty.
> > But could I have avoided all this hassle and change the location
> > BEFORE the resetlogs?
> >
> > TIA,
> > Jerome
> > --
> > http://www.freelists.org/webpage/oracle-l
> >
> --
> http://www.freelists.org/webpage/oracle-l
>

-- 
Thanks,
Ram.

--
http://www.freelists.org/webpage/oracle-l