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

Thread: Issue in RMAn Duplicate

  1. #1
    Join Date
    Oct 2002
    Posts
    109

    Issue in RMAn Duplicate

    Hi ,
    I have two database , find and fint.
    Need to duplicate find to fint m using RMAN.
    RMAN is configured for both find and fint in rmancatalog.
    I edit tnsnames.ora and listener.ora of fint as below :
    TNSNAMES.ora
    ----------------

    OEMP =
    (DESCRIPTION =
    (ADDRESS = (PROTOCOL = TCP)(HOST = dclnderdb11.hertz.com)(PORT = 1521))
    (CONNECT_DATA =
    (SERVER = DEDICATED)
    (SERVICE_NAME = oemp.hertz.com)
    )
    )

    find=
    (DESCRIPTION=
    (ADDRESS=(PROTOCOL=tcp)(HOST=dclnderdb06.hertz.com)(PORT=1526))
    (CONNECT_DATA=
    (SERVICE_NAME=find)
    (INSTANCE_NAME=find)
    )
    )
    fint=
    (DESCRIPTION=
    (ADDRESS=(PROTOCOL=tcp)(HOST=dclnderdb06.hertz.com)(PORT=1523))
    (CONNECT_DATA=
    (SERVICE_NAME=fint)
    (INSTANCE_NAME=fint)
    )
    )



    Listner.ora
    =============

    fint =
    (DESCRIPTION_LIST =
    (DESCRIPTION =
    (ADDRESS = (PROTOCOL = TCP)(HOST = dclnderdb06.hertz.com)(PORT = 1523))
    )
    )

    SID_LIST_fint =
    (SID_LIST =
    (SID_DESC =
    (ORACLE_HOME= /u15/oracle/fint/db/tech_st/11.1.0)
    (SID_NAME = fint)
    )
    (SID_DESC =
    (ORACLE_HOME=/u01/oracle/find/db/tech_st/11.1.0)
    (SID_NAME = find)
    )
    )

    --------------------------------------------------
    ISSUE:
    I am getting the below mentioned error while invokin RMAN
    can any body help me

    RMAN> connect target sys/diagon03@find;

    RMAN-00571: ===========================================================
    RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
    RMAN-00571: ===========================================================
    ORA-01031: insufficient privileges

    RMAN> connect catalog rman_user/rman1234@oemp;

    connected to recovery catalog database

    RMAN> connect AUXILIARY sys/stream12@fint;

    connected to auxiliary database: FINT (not mounted)

    RMAN>

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

    Cool

    ISSUE:
    I am getting the below mentioned error while invokin RMAN
    can any body help me

    RMAN> connect target sys/diagon03@find;

    RMAN-00571: ===========================================================
    RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
    RMAN-00571: ===========================================================
    ORA-01031: insufficient privileges
    Perhaps you need to configure your "find" database correctly, check out the fine Oracle® Database Administrator's Guide on this issue.


    Or...because you are on the same host, setup the environment for 'find' database and try this (see if it works):
    Code:
    RMAN> connect target sys/diagon03
    "The person who says it cannot be done should not interrupt the person doing it." --Chinese Proverb

  3. #3
    Join Date
    Oct 2008
    Posts
    20
    do you have the password file created

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