Database Software

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Cant create onlinelogs to different location after restore database

User505978 - OracleFeb 9 2015 — edited Feb 12 2015

I have a backup and I want to restore it on same server. I dont want to touch previous redologs and I want to create redologs on different location.

I run the following command;

run

{

set newname for database to '+DATA/TARGET/DATAFILE/%b' ;

set newname for logfile '+DATA/SOURCE/ONLINELOG/group_3.283.871168773' to '+DATA/TARGET/ONLINELOG/group_3.283.871168773';

set newname for logfile '/u01/app/oracle/backup/SOURCE/onlinelog/o1_mf_3_bfhnq7gr_.log' to '/u01/app/oracle/backup/TARGET/onlinelog/o1_mf_3_bfhnq7gr_.log';

set newname for logfile '+DATA/SOURCE/ONLINELOG/group_2.284.871168771' to '+DATA/TARGET/ONLINELOG/group_2.284.871168771';

set newname for logfile '/u01/app/oracle/backup/SOURCE/onlinelog/o1_mf_2_bfhnq3th_.log' to '/u01/app/oracle/backup/TARGET/onlinelog/o1_mf_2_bfhnq3th_.log';

set newname for logfile '+DATA/SOURCE/ONLINELOG/group_1.289.871168767' to '+DATA/TARGET/ONLINELOG/group_1.289.871168767';

set newname for logfile '/u01/app/oracle/backup/SOURCE/onlinelog/o1_mf_1_bfhnq04y_.log' to '/u01/app/oracle/backup/TARGET/onlinelog/o1_mf_1_bfhnq04y_.log';

restore database ;

switch datafile all;

switch tempfile all;

}

recover database;

alter database open resetlogs;

However, it creates the online redlogs to the previous paths...

Locked Post

New comments cannot be posted to this locked post.

Locked on Mar 12 2015

Added on Feb 9 2015

#performance-availability, #recovery-manager-rman

7 comments

4,967 views