Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Mailing Lists -> Oracle-L -> Changing redo logs location after incomplete recovery

Changing redo logs location after incomplete recovery

From: Vitalis Jerome <vitalisman_at_gmail.com>
Date: Mon, 29 Aug 2005 15:58:10 +0200
Message-ID: <68b1285505082906581239fa07@mail.gmail.com>


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
Received on Mon Aug 29 2005 - 09:00:10 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US