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