This discussion is archived
2 Replies Latest reply: Jan 28, 2013 5:33 AM by Sunny kichloo RSS

Active duplication with different DB name

007 Newbie
Currently Being Moderated
Hi,

I am trying to duplicate a Primary database in another server with different db name. On firing the duplicate target database for standby from active database nofilenamecheck i face ORA-01103: database name 'ORADB' in control file is not '11GDB' error. i even tried some other duplication commands by surfing in internet but nothing worked.

Primary DB

db name : ORADB

OS : OracleLinux 5

version : 11.2.0.1.0

Standby DB

db name : 11GDB

OS : OracleLinux 5

version : 11.2.0.1.0

Both the db is running in ASM with different diskgroup name. The below shown in the content of the Standby database pfile.

11GDB.__db_cache_size=314572800
11GDB.__java_pool_size=4194304
11GDB.__large_pool_size=4194304
11GDB.__oracle_base='/u01/app/oracle'#ORACLE_BASE set from environment
11GDB.__pga_aggregate_target=318767104
11GDB.__sga_target=478150656
11GDB.__shared_io_pool_size=0
11GDB.__shared_pool_size=146800640
11GDB.__streams_pool_size=0
*.audit_file_dest='/u01/app/oracle/admin/11GDB/adump'
*.audit_trail='db'
*.compatible='11.2.0.0.0'
*.control_files='+STDBY/11gdb/controlfile/current.260.788911153'
*.db_block_size=8192
*.db_create_file_dest='+STDBY'
*.db_domain=''
*.db_file_name_convert='+DATA','+STDBY'
*.db_name='11GDB'
*.db_unique_name='11GDB'
*.diagnostic_dest='/u01/app/oracle'
*.dispatchers='(PROTOCOL=TCP) (SERVICE=11GDBXDB)'
*.FAL_CLIENT='11GDB'
*.FAL_SERVER='ORADB'
*.log_archive_config='dg_config=(ORADB,11GDB)'
*.log_archive_dest_1='LOCATION=+STDBY valid_for=(all_logfiles,all_roles) db_unique_name=11GDB'
*.log_archive_dest_2='service=ORADB LGWR async valid_for=(online_logfiles,primary_role) db_unique_name=ORADB'
*.log_archive_dest_STATE_1='ENABLE'
*.log_archive_dest_state_2='ENABLE'
*.log_file_name_convert='+DATA','+STDBY'
*.memory_target=796917760
*.open_cursors=300
*.processes=150
*.remote_login_passwordfile='EXCLUSIVE'
*.standby_file_management='AUTO'
*.undo_tablespace='UNDOTBS1'

Plz anyone tell me where it goes wrong.

Regards,
007
  • 1. Re: Active duplication with different DB name
    Sunny kichloo Expert
    Currently Being Moderated
    From the error mentioned the SID of primary is ORADB

    Whereas in the pfile displayed by you it has name

    *.db_name='11GDB'

    db_unique_name can be different but db_name should be same.

    Please do the changes and proceed and Share the output.
  • 2. Re: Active duplication with different DB name
    CKPT Guru
    Currently Being Moderated
    I am trying to duplicate a Primary database in another server with different db name. On firing the duplicate target database for standby from active database nofilenamecheck i face ORA-01103: database name 'ORADB' in control file is not '11GDB' error. i even tried some other duplication commands by surfing in internet but nothing worked.
    When you duplicate from primary to standby. Ensure the DB_NAME same on both primary and standby and of course you can have different DB_UNIQUE_NAME in both primary and standby databases.

Legend

  • Correct Answers - 10 points
  • Helpful Answers - 5 points