Return-Path: X-Original-To: oracle-l@orafaq.com Delivered-To: oracle-l@orafaq.com Received: from puck1183.startdedicated.com (localhost [127.0.0.1]) by puck1183.startdedicated.com (Postfix) with ESMTP id DAB171961058 for ; Wed, 10 Oct 2012 22:03:46 +0200 (CEST) Received: from turing.freelists.org (freelists-180.iquest.net [206.53.239.180]) by puck1183.startdedicated.com (Postfix) with ESMTP for ; Wed, 10 Oct 2012 22:03:46 +0200 (CEST) Received: from localhost (localhost [127.0.0.1]) by turing.freelists.org (Avenir Technologies Mail Multiplex) with ESMTP id 37E66F013D7; Wed, 10 Oct 2012 16:03:45 -0400 (EDT) DKIM-Signature: v=1; a=rsa-sha256; c=simple/simple; d=freelists.org; s=turing; t=1349899425; bh=j//xaG21ZNo93iRoHF1F72ZYNlPTidvZIADix4m/ /OU=; h=MIME-Version:Date:Message-ID:Subject:From:To:Content-type: Content-Transfer-Encoding:Sender:Reply-To:List-help: List-unsubscribe:List-Id:List-subscribe:List-owner:List-post: List-archive; b=UhaXuTOqTIBuAboTmWhlDyAsg1d68Z/Y6gn4GQZH2H88WEyRnA E05+Ydvp9PwW0BDLbQpU9nWYhXgFEcxfs3Eb6AHP2Jut2ssVPkjRzgMhOYUheVr0Lez 7F8LtFJE21QpKtXpmjkWwDJb8ooW0SYqp6stBwnkc0BjAM5Q9xa+XM= X-Virus-Scanned: Debian amavisd-new at localhost.localdomain Received: from turing.freelists.org ([127.0.0.1]) by localhost (turing.freelists.org [127.0.0.1]) (amavisd-new, port 10024) with ESMTP id IWkidTMIDO5C; Wed, 10 Oct 2012 16:03:44 -0400 (EDT) Received: from turing.freelists.org (localhost [127.0.0.1]) by turing.freelists.org (Avenir Technologies Mail Multiplex) with ESMTP id 59D33F01142; Wed, 10 Oct 2012 16:03:02 -0400 (EDT) Received: with ECARTIS (v1.0.0; list oracle-l); Wed, 10 Oct 2012 16:02:21 -0400 (EDT) Received: from localhost (localhost [127.0.0.1]) by turing.freelists.org (Avenir Technologies Mail Multiplex) with ESMTP id D6CC7F01141 for ; Wed, 10 Oct 2012 16:02:20 -0400 (EDT) Authentication-Results: turing.freelists.org; dkim=pass (2048-bit key) header.i=@gmail.com Received: from turing.freelists.org ([127.0.0.1]) by localhost (turing.freelists.org [127.0.0.1]) (amavisd-new, port 10024) with ESMTP id 1Z4+zR48EtPx for ; Wed, 10 Oct 2012 16:02:20 -0400 (EDT) Received: from mail-ob0-f179.google.com (mail-ob0-f179.google.com [209.85.214.179]) by turing.freelists.org (Avenir Technologies Mail Multiplex) with ESMTP id E07E5F0113C for ; Wed, 10 Oct 2012 16:02:19 -0400 (EDT) Received: by mail-ob0-f179.google.com with SMTP id lz20so925011obb.10 for ; Wed, 10 Oct 2012 13:02:19 -0700 (PDT) DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=gmail.com; s=20120113; h=mime-version:date:message-id:subject:from:to:content-type; bh=RvQag5RZrnfdYFr+DBt/J5bIdPtORFDGtZ6W/jFUYDE=; b=brIIMsFIZqqObVeaFvy0jRuZrBfFIqo2VPZXehjBhobpLpsWumWnePzinc00YrO+f2 fDj3J3OHoyqp99yT/5MZtZlKUzOtCPBQj+C3KUn5fSoYwtnMHqRDPQDa7SkwNNozVfKZ iu2TLmf0VZjOvw1QdYqTAbg8EU+86wLUNSkQiid7ZAXpc6lzV14Z9mom+SWkgQ3GUf0D WSxkWksmM4RmZGwFEnr/j4LZAib/J8bRfcZXN0MPdNyIZHZsFHkEZb82N/282LX+QUnj LQLvZz62+hxbLhLHp0m8updWk+k4F1LQ9eOA9Eer8aAimm+uBt8eqUUma8r8b2KSjPXD AoVA== MIME-Version: 1.0 Received: by 10.60.154.198 with SMTP id vq6mr20492839oeb.20.1349899339429; Wed, 10 Oct 2012 13:02:19 -0700 (PDT) Received: by 10.76.139.195 with HTTP; Wed, 10 Oct 2012 13:02:19 -0700 (PDT) Date: Thu, 11 Oct 2012 01:32:19 +0530 Message-ID: Subject: RMAN Restore Problem From: Venkat srinivasan To: oracle-l@freelists.org Content-type: text/plain; charset=ISO-8859-1 Content-Transfer-Encoding: 8bit X-archive-position: 45213 X-ecartis-version: Ecartis v1.0.0 Sender: oracle-l-bounce@freelists.org Errors-to: oracle-l-bounce@freelists.org X-original-sender: srini.venkat.raman@gmail.com Precedence: normal Reply-To: srini.venkat.raman@gmail.com List-help: List-unsubscribe: List-software: Ecartis version 1.0.0 List-Id: oracle-l X-List-ID: oracle-l List-subscribe: List-owner: List-post: List-archive: X-list: oracle-l Hi Gurus, I would like to clone the 10G Db from Rman backup.Currently we are using asm and would like to clone the db to filesystem. I have taken the rman backup set and moved to the filesystem.steps below followed. Target machine. 1. startup nomount 2. restore the control file from the rman backup 3. mount the db 4. catalog backuppiece to new location. 5. run { set newname for datafile 1 to '/u01/zilt/system.dbf'; 6. set newname for all the datafiles. 7. restore database. Its trying to restore in to the ASM disk group. I am getting the below error. Any idea what i have missed. restoring datafile 00003 to +DG_ZILTEST/zilt/datafile/sysaux.261.786493797 channel ORA_DISK_1: reading from backup piece /newdisk/backup/zilt_rmanbkp/b_2cnmuc2k_1_1 ORA-19870: error reading backup piece /u01/zilt_dump/rman_zilt/b_2cnmuc2k_1_1 ORA-19504: failed to create file "+DG_ZILTEST" ORA-17502: ksfdcre:4 Failed to create file +DG_ZILTEST ORA-15001: diskgroup "DG_ZILTEST" does not exist or is not mounted ORA-15077: could not locate ASM instance serving a req Thanks in advance. Venkat -- http://www.freelists.org/webpage/oracle-l