DBAsupport.com Forums - Powered by vBulletin
Results 1 to 3 of 3
  1. #1
    Join Date
    Sep 2006

    Problem with duplicate database using rman


    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

    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
    Madrid, Spain
    sys as sysdba?

  3. #3
    Join Date
    Nov 2001
    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

By using this site, you agree to the Privacy Policy