![hot backup in oracle 10g steps hot backup in oracle 10g steps](https://www.oracle.com/ocom/groups/public/@otn/documents/digitalasset/2103683.png)
![hot backup in oracle 10g steps hot backup in oracle 10g steps](https://img.veeam.com/blog/wp-content/uploads/2016/10/09203408/how-to-backup-oracle-database-best-practices-meta-700x350.png)
# Generated by Oracle configuration tools.PRIM = # tnsnames.ora Network Configuration File: F:\oracle\product\10.2.0\db_1\network\admin\tnsnames.ora Modify the Tnsnames.ora file on Primary server.
![hot backup in oracle 10g steps hot backup in oracle 10g steps](https://www.oracle.com/ocom/groups/public/@otn/documents/digitalasset/2103790.png)
# Generated by Oracle configuration tools.LISTENER1 = # listener.ora Network Configuration File: F:\oracle\product\10.2.0\db_1\network\admin\listener.ora Modify the Listener.ora file on Primary server.
#Hot backup in oracle 10g steps archive#
Take backup of primary database archive as follows.īackup archivelog all format ' F:\oracle\product\10.2.0\rman\%d_%T_s%s_p%p.arch' ġ1. Shutdown the database and startup again using spfile.Ĭreate one backup folder under F:\oracle\product\10.2.0\rmanīackup format 'F:\oracle\product\10.2.0\rman\%U_db' database īackup format 'F:\oracle\product\10.2.0\rman\%U_ctl' current controlfile for standby ġ0. Verify the parameter whether all set properly.Ĩ. SQL> create spfile from pfile='F:\oracle\product\10.2.0\db_1\database\ INITprim.ORA' ħ. Create spfile from pfile using below command. SQL> startup pfile='F:\oracle\product\10.2.0\db_1\database\INITprim.ORA' Ħ. Startup database using newly created pfile. *.log_archive_dest_2='service=prim_dr lgwr async valid_for=(online_logfiles,primary_role) db_unique_name=prim_dr' *.LOG_ARCHIVE_DEST_1='location=F:\oracle\product\10.2.0\archive valid_for=(all_logfiles,all_roles) db_unique_name=prim' *.LOG_ARCHIVE_CONFIG='dg_config=(prim,prim_dr)' Open parameter file INITprim.ORA in notepad and add below mentioned parameter. SQL>Select FORCE_LOGGING from V$DATABASE SQL>ALTER DATABASE FORCE LOGGING Ĥ. This statement may take some time to complete, because it waits for all logged direct write I/O to finish. If it is not enabled, enable FORCE LOGGING mode. Server failed with minimum downtime we can transfer to standby Server.Following are the steps to configure the Dataguard with RMAN backup.Ĭ:\>set ORACLE_HOME= F:\oracle\product\10.2.0\db_1Ģ. Dataguard is oracle feature for provide standby database in case of primary Configure the dataguard environment with the help of RMAN backup.