Database Backup and Recovery (MOSC)

MOSC Banner

restore database from ASM to filesystem

edited Oct 6, 2015 1:28AM in Database Backup and Recovery (MOSC) 23 commentsAnswered

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

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center