Standby database using RMAN backups

In Primary:

1)      Create a standby control file.

SQL>alter database backup standby controlfile as ‘/Oracle/oracle/control01.ctl’;

2)      Login in Rman prompt.

$rman target sys/sys

RMAN> backup as compressed backupset incremental level=0 database maxsetsize=1g format '/Oracle/oracle/full_comp_prime_%t.bkp';

3)      SCP all the backup files to corresponding location in standby.

4)      Modify the pfile of primary as required and restart the DB.

In Secondary:

1)      Copy the backup files to the corresponding location.

2)      Modify the standby pfile as required  and start the DB in nomount stage.

SQL>startup pfile=initprime.ora nomount

3)      Mount the standby database.

SQL>alter database mount standby database;

Primary database Pfile:

*.db_files=230

*.db_name='prime'

*.instance_name='prime'

*.processes=100

*.sessions=100

*.sga_max_size=150m

*.sga_target=116m

*.undo_management='AUTO'

*.undo_retention=10800

*.undo_tablespace='UNDOTBS1'

*.background_dump_dest='/Oracle/oracle/oradata/data/admin/bdump'

*.control_files='/Oracle/oracle/oradata/data/oradata/control01.ctl'

*.core_dump_dest='/Oracle/oracle/oradata/data/admin/cdump'

*.user_dump_dest='/Oracle/oracle/oradata/data/admin/udump'

*.standby_file_management=AUTO

*.log_archive_format='%t_%r_%s.dbf'

*.remote_login_passwordfile='EXCLUSIVE'

*.FAL_CLIENT='153'

*.FAL_SERVER='152'

*.log_archive_dest_1='LOCATION=/Oracle/oracle/oradata/data/admin/arch'

*.log_archive_dest_2='service=152 lgwr sync'

*.log_file_name_convert='/Oracle/oracle/oradata/data/oradata/two','/Oracle/oracle/oradata/prime/two'

*.db_file_name_convert='/Oracle/oracle/oradata/data/oradata/one','/Oracle/oracle/oradata/prime/one','/Oracle/oracle/oradata/data/oradata/two','/Oracle/oracle/oradata/prime/two','/Oracle/oracle/oradata/data/oradata/three','/Oracle/oracle/oradata/prime/three'

*.standby_archive_dest='/Oracle/oracle/admin/prime/arch'

Standby database Pfile:

*.background_dump_dest='/Oracle/oracle/admin/prime/bdump'

*.control_files='/Oracle/oracle/oradata/prime/control01.ctl'

*.core_dump_dest='/Oracle/oracle/admin/prime/cdump'

*.db_files=230

*.db_name='prime'

*.instance_name='prime'

*.log_archive_dest_1='LOCATION=/Oracle/oracle/admin/prime/arch'

*.log_archive_format='%t_%r_%s.dbf'

*.processes=100

*.sessions=100

*.sga_max_size=150m

*.sga_target=125m

*.undo_management='AUTO'

*.undo_retention=10800

*.undo_tablespace='UNDOTBS1'

*.user_dump_dest='/Oracle/oracle/admin/prime/udump'

*.FAL_CLIENT='152'

*.FAL_SERVER='153'

*.remote_login_passwordfile='EXCLUSIVE'

*.standby_file_management='AUTO'

*.log_file_name_convert='/Oracle/oracle/oradata/data/oradata/two','/Oracle/oracle/oradata/prime/two'

*.db_file_name_convert='/Oracle/oracle/oradata/data/oradata/one','/Oracle/oracle/oradata/prime/one','/Oracle/oracle/oradata/data/oradata/two','/Oracle/oracle/oradata/pr

ime/two','/Oracle/oracle/oradata/data/oradata/three','/Oracle/oracle/oradata/prime/three'

*.standby_archive_dest='/Oracle/oracle/admin/prime/arch'