Home » RDBMS Server » Backup & Recovery » Restore a database on new host (Problem 2) (11.2,Windows Server 2008)
Restore a database on new host (Problem 2) [message #611679] Mon, 07 April 2014 01:10 Go to next message
kakakoko
Messages: 22
Registered: March 2014
Junior Member
Hi,

I want to restore Database on new host:
database host1 has two diskgroups called on +DATA and +CATCHE and each diskgroup has one datafile (+DATA\orcl\datafile\datafile1.dbf , +CATCHE\orcl\datafile\datafile2.dbf)

First of all I made two diskgroups in host2 with same name diskgroups in host1. But after restoring, both two datafile are in diskgroup +DATA.

Even I used Set NewName commnad in restorantion command.
RUN{
Set NewName for datafile 6 to '+CATCHE\orcl\datafile\datafile2.dbf';
RESTORE DATABASE ;
SWITCH DATAFILE ALL;
RECOVER DATABASE;
}

Does anyone know what is the problem?

Re: Restore a database on new host (Problem 2) [message #611693 is a reply to message #611679] Mon, 07 April 2014 05:47 Go to previous message
kakakoko
Messages: 22
Registered: March 2014
Junior Member
I solved the problem By unset the parameter DB_CREATE_FILE_DEST before starting the restore operation:

alter system set DB_CREATE_FILE_DEST='' scope=memory;
Previous Topic: Problem after restoring a database on new host
Next Topic: backup from disk to tape
Goto Forum:
  


Current Time: Fri Mar 29 10:22:10 CDT 2024