Re: Changing redo logs location after incomplete recovery
- From: Stalin <stalinsk@xxxxxxxxx>
- To: vitalisman@xxxxxxxxx
- Date: Mon, 29 Aug 2005 13:36:33 -0700
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
Other related posts:
