This discussion is archived
8 Replies Latest reply: Jan 16, 2013 9:54 PM by SimonTann RSS

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

SimonTann Newbie
Currently Being Moderated
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

Legend

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