Skip to Main Content
  • Questions

  • How to restore database from ASM to Non-ASM ?

Breadcrumb

Question and Answer

Chris Saxon

Thanks for the question, Alfins.

Asked: January 07, 2016 - 4:23 am UTC

Last updated: January 07, 2016 - 12:08 pm UTC

Version: 12

Viewed 1000+ times

You Asked

I want to restore database from tape to another server. The source data is in ASM and the target server is Non-ASM.
The control file has been successfully restored to the target server. But I don't know how to restore the datafile to the target server. The datafile '+DATA/OPOSSIN/DATAFILE/system.260.896102967' want to be restore to directory /oracle/opossin1/data01/.

The command :

run {
allocate channel ch00 device type 'SBT_TAPE';
send 'NB_ORA_SERV= vrbackup, NB_ORA_CLIENT=vpoossdb01x';
set newname for datafile 00001 to '/oracle/opossin1/data01/';
restore datafile 00001;
release channel ch00;
}

Error message :

RMAN-00571: ===========================================================
RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
RMAN-00571: ===========================================================
RMAN-03002: failure of restore command at 01/05/2016 16:28:33
ORA-01180: can not create datafile 1
ORA-01110: data file 1: '+DATA/OPOSSIN/DATAFILE/system.260.896102967'


Thanks.

and Connor said...

I dont think "set newname" works like that (ie, at the directory level).

Try either explict names, eg

RUN
{
SET NEWNAME FOR DATAFILE 1 TO '/oradata1/system01.dbf';
SET NEWNAME FOR DATAFILE 2 TO '/oradata2/sysaux01.dbf';
...
}

or some of the substitution characters

RUN
{
SET NEWNAME FOR TABLESPACE users TO '/oradata%f/%b';
...
}

The substitution characters can be found here

http://docs.oracle.com/database/121/BRADV/rcmdupad.htm#GUID-9693D878-75CA-4E17-A972-F97E33F0BE0F__CIHJJJAJ

Hope this helps.


Rating

  (2 ratings)

Is this answer out of date? If it is, please let us know via a Comment

Comments

Alfins Alfins, January 07, 2016 - 9:29 am UTC

Hi, Connor McDonald. Thanks for your answer. It's very helpful for me because your explaination.
Connor McDonald
January 07, 2016 - 12:08 pm UTC

No problem at all...We're here to help.

Sajan, January 07, 2016 - 4:29 pm UTC

Or you can do an export import
more

Connor and Chris don't just spend all day on AskTOM. You can also catch regular content via Connor's blog and Chris's blog. Or if video is more your thing, check out Connor's channel and Chris's channel from their Youtube channels. And of course, keep up to date with AskTOM via the official twitter account.

More to Explore

Backup/Recovery

Check out the complete guide to all of the Backup & Recovery techniques in the Oracle Database.