Re: Changing redo logs location after incomplete recovery
- From: Ram K <lambu999@xxxxxxxxx>
- To: stalinsk@xxxxxxxxx
- Date: Tue, 30 Aug 2005 15:25:32 -0400
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@xxxxxxxxx> 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@xxxxxxxxx> 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
> > --
> > //www.freelists.org/webpage/oracle-l
> >
> --
> //www.freelists.org/webpage/oracle-l
>
--
Thanks,
Ram.
Other related posts: