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';


  
Pada database standby1. membuat direktori untuk bdump, udump, cdump, dbdump, pfile, adump
2. menambahkan pada tnsnames.ora ==> Oracle Net Service Name ===> dapat menggunakan netca
3. copy controlfile, redologfile, datafile dari primary database (changing the path)
4. membuat password file (orapw)
5. copy pfile dari primary database kemudian buat spfile from pfile (jangan lupa mengubah nama database)
6. copy standby controlfile (that was created in primary) to the directory control file in standby
   cp /path/controltsstandby.ctl' control01.ctl
   cp /path/controltsstandby.ctl' control02.ctl
   cp /path/controltsstandby.ctl' control03.ctl
7. mount database (startup mount)
Connect to dgmgrl
$ dgmgrl sys/oracle@orcl
1. create a broker configuration
   DGMGRL > create configuration (name) as primary database is [database_name]
            connect identifier is [connect identifier];
   dgmgrl > add database <database name> as connect identifier is <connect identifier>
            maintained as {physical|logical}
2. enable configuration