Showing posts with label Dataguard. Show all posts
Showing posts with label Dataguard. Show all posts

Saturday, July 16, 2011

Membuat database standby

Pada database primary:
1. database harus pada archive log mode
2. memastikan database yang memiliki orapw (passwordfile)
   cd $ORACLE_HOME/dbs orapwd file=orapw[database_name] password=oracle entries=5 force=y
3. mengubah parameter:
   * db_file_name_convert='/path/','/path/'
   * log_file_name_convert='/path/','/path/'
   * dg_broker_start='TRUE'
   * standby_file_management='AUTO'
4. membuat stanby controlfile
   alter database create standby controlfile as '/path/controltsstandby.ctl';