DBAsupport.com Forums - Powered by vBulletin
Results 1 to 3 of 3

Thread: Problem with duplicate database using rman

  1. #1
    Join Date
    Sep 2006
    Posts
    16

    Problem with duplicate database using rman

    Hello,

    I'm trying to clone oracle database from existing database on remote server. First I prepared the same file structure on auxilary server as on target is, created passwd file on aux, created init.ora file on aux from spfile from target database, copied backup from target on the same file structure on aux host and updated lister.ora configuration on aux and tnsnames on target host. I started database instance on aux (with the same sid as it is on target) in nomount mode. I'm getting following error while I try to initiate the command as shown below from rman on target. Kindly help me resolving this.

    Recovery Manager: Release 9.2.0.5.0

    Copyright (c) 1995, 2002, Oracle Corporation. All rights reserved.

    RMAN> connect target
    connected to target database: ORCL (DBID=924445643)

    RMAN> connect auxiliary sys/passwd@conn_string_to_aux

    RMAN-00571: ===========================================================
    RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
    RMAN-00571: ===========================================================
    RMAN-04006: error from auxiliary database: ORA-01031: insufficient privileges

  2. #2
    Join Date
    Jun 2000
    Location
    Madrid, Spain
    Posts
    7,447
    sys as sysdba?

  3. #3
    Join Date
    Nov 2001
    Posts
    335
    You should be local in aux and remote for target
    One, who thinks that the other one who thinks that know and does not know, does not know either!

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  


Click Here to Expand Forum to Full Width