How Standby Database Build ?

Actually Standby Database Creation  i know two types
1. Using Backup of Primary Databse
2. Using Duplicate command
        Both are Allmost similar but depend upon the company Documents they will do.

Standby Database Creation :

1. In primary database,edit and insert some parameter

    $ vi pfile.sql
             instance_name=dev
            database_name=dev
            db_unique_name=primary
            log_archive_dest_2='target service name' valid for=(primary dbname,standby dbname)                                                          lgwr Assync oraffirm or no affirm
            standby_file_management=auto
            fal_server='remote tns name'
            fal_client='local tns name'

2. In Standby database,edit and insert some parameter

  $ vi pfile.sql
 
             Instance_name=dev
            database_name=dev
            db_unique_name=Standby
            db_file_name_convert='/u01/home/dev','/u01/home/dev/standby/data'
            log_file_name_convert='/u01/home/dev','/u01/home/dev/standby/data'

            log_archive_dest_1='/u01/home/standby/archive'

3. Listener,Tns service,pwd files are common to create,if already have use them.

4.Take the primary database backup ( cold backup )

5. Take the standby control file 

    

    Rman>backup controlfile for standby '/u01/home/standby/controlbakcup.ctl';

6. put the database in no mount ( standby database )

7. Restore the standby control file 

    Rman>restore control file from '/u01/home/standby/controlbakcup.ctl';

8. Put the database in mount stage ( standby database )

     SQL>startup mount;
         

9. start the MRP process

   SQL>alter database recover managed standby database disconnect;




Createing Standby database using  Duplicate Command :

 Rman>duplicate target database for standby from active database;