Re: Changing redo logs location after incomplete recovery

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