Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
![]() |
![]() |
Home -> Community -> Mailing Lists -> Oracle-L -> Changing redo logs location after incomplete recovery
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-lReceived on Mon Aug 29 2005 - 09:00:10 CDT
![]() |
![]() |