After performing a restore of a database to another server using rman, when I issue Alter Database Open Resetlogs it fails creating the online log.
the following errors appear
ora-00344: unable to re-create online log '+LOG/windc/onlinelog/windcredo01a'
ora-17502: ksfdcre:4 Failed to create file '+LOG/windc/onlinelog/windcredo01a'
ora-15005: name "+LOG/windc/onlinelog/windcredo01a" is already used by an existing alias
I have tried with 2 different backups of the source database. in between the restore attempts, I deleted the database, used asmcmd to delete any files that did not get deleted, and recreated the database.
would someone know what I can do to complete this restore?
restore the control file from the source database.
First, I restored the backup of the controlfile from the source database, then perform the restore
======================================================================================
rman
connect target sys/xxxxxx@windc
run
{
Allocate channel c1 device type disk;
Backup current controlfile format ‘/Path/to/controlfile/backup’;
Release channel c1;
}
alter database mount
run
{
allocate channel c1
set until time "TO_DATE('10/16/2014:10:00','mm/dd/yyyy:hh24:mi')";
restore database;
recover database;
release channel c1
}
alter database open resetlogs;
ora-00344: unable to re-create online log '+LOG/windc/onlinelog/windcredo01a'
ora-17502: ksfdcre:4 Failed to create file '+LOG/windc/onlinelog/windcredo01a'
ora-15005: name "+LOG/windc/onlinelog/windcredo01a" is already used by an existing alias
==========================================================================================
Thanks