Duplicate a Database Using RMAN
DBAsupport.com Forums - Powered by vBulletin
Results 1 to 4 of 4

Thread: Duplicate a Database Using RMAN

  1. #1
    Join Date
    Feb 2009
    Posts
    91

    Duplicate a Database Using RMAN

    In every piece of online documentaion I see the first step to duplicating
    a DB with RMAN says that you must use the orapwd utility to create
    a password file.

    Ie:
    http://www.oracle-base.com/articles/...singRMAN9i.php

    While following each step in the arcticle above except creating the
    orapwd file I was successful in creating the AUX DB.

    Can somebody please explain why I would need the orapwd file? I am
    obvisously missing something but not sure what.

    Maybe you can provide an example as it pertains to the above mentioned article and show between what steps it would be accessed.

    Thanks

  2. #2
    Join Date
    Jul 2002
    Location
    Lake Worth, FL
    Posts
    1,443

    Talking Sysdba login

    You need orapwd file to be able to login "as sysdba" from an external (OS) account that belogs to the dba group.
    "The person who says it cannot be done should not interrupt the person doing it." --Chinese Proverb

  3. #3
    Join Date
    Feb 2009
    Posts
    91
    As per the document above, how come I did need to create an orapwd file when the directions say too. Can you please be a bit more specific.

    FYI, I was logged into UNIX OS as user oracle and group dba

  4. #4
    Join Date
    Mar 2007
    Location
    Ft. Lauderdale, FL
    Posts
    3,554
    orapwd -as already pointed out by LKBrwn_DBA - allows for Operating System authentication so if you do not do as suggested in the note you are not going to have such a feature for your clonned database.

    If not clear, please research O/S authentication.
    Pablo (Paul) Berzukov

    Author of Understanding Database Administration available at amazon and other bookstores.

    Disclaimer: Advice is provided to the best of my knowledge but no implicit or explicit warranties are provided. Since the advisor explicitly encourages testing any and all suggestions on a test non-production environment advisor should not held liable or responsible for any actions taken based on the given advice.

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