restore database from ASM to filesystem
I have a backup from database which running on ASM and I need to restore datafile to another machine and change datafile path to local disk. but I found error as below
restoredb:/home/oracle(mmkkbzdc)$ rman target /
Recovery Manager: Release 11.2.0.4.0 - Production on Mon Sep 28 12:08:03 2015
Copyright (c) 1982, 2011, Oracle and/or its affiliates. All rights reserved.
connected to target database: MMKKBZDC (not mounted)
RMAN> run {
2> set newname for datafile 1 to '/oradata/mmkkbzdc/system.395.841057073';
3> restore datafile 1;
4> }
executing command: SET NEWNAME
Starting restore at 28-SEP-15
using target database control file instead of recovery catalog
allocated channel: ORA_DISK_1
channel ORA_DISK_1: SID=129 device type=DISK