OraFAQ Forum: Backup & Recovery » Restore a database on new host (Problem 2)

Home » RDBMS Server » Backup & Recovery » Restore a database on new host (Problem 2) (11.2,Windows Server 2008)

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

Restore a database on new host (Problem 2) [message #611679]

Mon, 07 April 2014 01:10

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?

Report message to a moderator

Re: Restore a database on new host (Problem 2) [message #611693 is a reply to message #611679]

Mon, 07 April 2014 05:47

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;

Report message to a moderator

Previous Topic:	Problem after restoring a database on new host
Next Topic:	backup from disk to tape

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Tue Mar 11 22:05:26 CDT 2025