Changing redo logs location after incomplete recovery
- From: Vitalis Jerome <vitalisman@xxxxxxxxx>
- To: oracle-l <oracle-l@xxxxxxxxxxxxx>
- Date: Mon, 29 Aug 2005 15:58:10 +0200
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
Other related posts:
