8 Replies Latest reply: Jan 16, 2013 11:54 PM by Simon Tann RSS

    Converting Primary Database in a Primary/Standby pair into a Standalone DB

    Simon Tann
      Hi

      We currently have a database that has a physical standby. This is overkill for this system and the standby database is taking up room on another server.

      To convert the primary into a standalone server I am thinking that I need to change some of the initialisation parameters in the pfile/spfile?

      The current pfile/spfile for the primary database is as follows:
      IPMPROD.__db_cache_size=419430400
      IPMPROD.__java_pool_size=16777216
      IPMPROD.__large_pool_size=16777216
      IPMPROD.__shared_pool_size=671088640
      IPMPROD.__streams_pool_size=16777216
      *.audit_file_dest='/opt/oracle/admin/IPMPROD/adump'
      *.background_dump_dest='/opt/oracle/admin/IPMPROD/bdump'
      *.compatible='10.2.0.3.0'
      *.control_files='+ASMDG1/ipmprod/controlfile/current.271.691873139','/opt/oracle/flash_recovery_area/IPMPROD/controlfile/o1_mf_55g7qo15_.ctl'#Restore Controlfile
      *.core_dump_dest='/opt/oracle/admin/IPMPROD/cdump'
      *.db_block_size=8192
      *.db_create_file_dest='+ASMDG1'
      *.db_domain=''
      *.db_file_multiblock_read_count=16
      *.DB_FILE_NAME_CONVERT='/IPMPROD/','/IPMDR/'
      *.db_name='IPMPROD'
      *.db_recovery_file_dest='/opt/oracle/flash_recovery_area'
      *.db_recovery_file_dest_size=11811160064
      *.db_unique_name='IPMPROD'
      *.dispatchers='(PROTOCOL=TCP) (SERVICE=IPMPRODXDB)'
      *.FAL_CLIENT='IPMPROD'# TNSNAME of the FAL Server (usually primary)
      *.FAL_SERVER='IPMDR'# TNSNAME of the Standby Database
      *.job_queue_processes=10
      *.LOG_ARCHIVE_CONFIG='DG_CONFIG=(IPMPROD,IPMDR)'
      *.log_archive_dest_1='LOCATION=/opt/oracle/rman/ipmdblx/IPMPROD/archivelogs VALID_FOR=(ALL_LOGFILES,ALL_ROLES) DB_UNIQUE_NAME=IPMPROD'
      *.log_archive_dest_2='SERVICE=IPMDR LGWR ASYNC VALID_FOR=(ONLINE_LOGFILES,PRIMARY_ROLE) DB_UNIQUE_NAME=IPMDR'
      *.LOG_ARCHIVE_DEST_STATE_1='ENABLE'
      *.LOG_ARCHIVE_DEST_STATE_2='ENABLE'
      *.log_archive_format='%t_%s_%r.dbf'
      *.LOG_FILE_NAME_CONVERT='/IPMPROD/','/IPMDR/'
      *.open_cursors=300
      *.pga_aggregate_target=384827392
      *.processes=150
      *.remote_login_passwordfile='EXCLUSIVE'
      *.sga_target=1155530752
      *.STANDBY_FILE_MANAGEMENT='AUTO'
      *.undo_management='AUTO'
      *.undo_tablespace='TBS_UNDO'
      *.user_dump_dest='/opt/oracle/admin/IPMPROD/udump'
      I think we need to remove/comment the following lines:
      *.FAL_CLIENT='IPMPROD'# TNSNAME of the FAL Server (usually primary)
      *.FAL_SERVER='IPMDR'# TNSNAME of the Standby Database
      *.STANDBY_FILE_MANAGEMENT='AUTO'
      *.LOG_ARCHIVE_CONFIG='DG_CONFIG=(IPMPROD,IPMDR)'
      *.log_archive_dest_2='SERVICE=IPMDR LGWR ASYNC VALID_FOR=(ONLINE_LOGFILES,PRIMARY_ROLE) DB_UNIQUE_NAME=IPMDR'
      *.LOG_ARCHIVE_DEST_STATE_2='ENABLE'
      Can someone confirm if this is the case, or if there are any other steps I need to take to make the primary database a stand alone database?

      Thanks

      Simon