CREATE STANDBY 10gR2 cloning by RMAN
====================================


OracleŽ Data Guard Concepts and Administration 10g Release 2 (10.2) Part Number B14239-05


Primary Database Initialization Parameters
====================================================


######################
# PRIMARY INIT.ORA
######################
DB_NAME=DG
DB_UNIQUE_NAME=DGPRAHA
CONTROL_FILES='C:/oradata/DG/control01.ctl', 'C:/oradata/DG/control02.ctl','C:/oradata/DG/control02.ctl'
#
# which databases (DB_UNIQUE_NAMEs) are part of Dataguard configuration
LOG_ARCHIVE_CONFIG='DG_CONFIG=(DGPRAHA,DGBRNO)'
#
# one arhive dest local for all roles (DB could be in primary or in standby role)
LOG_ARCHIVE_DEST_1='LOCATION=C:/oradata/DG/arch1 VALID_FOR=(ALL_LOGFILES,ALL_ROLES) DB_UNIQUE_NAME=DGPRAHA'
#
# second archive dest is only for DB in primary role
# shiping archives to second location 'DGBRNO'
LOG_ARCHIVE_DEST_2='SERVICE=DGBRNO LGWR ASYNC VALID_FOR=(ONLINE_LOGFILES,PRIMARY_ROLE) DB_UNIQUE_NAME=DGBRNO'
#
LOG_ARCHIVE_DEST_STATE_1=ENABLE
LOG_ARCHIVE_DEST_STATE_2=ENABLE
LOG_ARCHIVE_FORMAT=%t_%s_%r.arc
LOG_ARCHIVE_MAX_PROCESSES=30
#
REMOTE_LOGIN_PASSWORDFILE=EXCLUSIVE
#
# following config parameters affects when primary becomes standby
# so DGBRNO is becoming to be primary and DGPRAHA standby database
#
# standby is a client which accepting redo records/archives 
# through file transport service  known as FAL
# FAL client is DB in primary role, FAL client is DB in standby role
FAL_SERVER=BRNO
FAL_CLIENT=PRAHA
#
# Set to AUTO so when datafiles are added to or dropped from the primary database, 
# corresponding changes are made automatically to the standby database
STANDBY_FILE_MANAGEMENT=AUTO


====
Database has to be in archivelog and force loging (redo) has to be enabled
SQL> startup nomount pfile='c:\initDGPRAHA.ora'
SQL> create spfile from pfile='c:\initDGPRAHA.ora'
SQL> STARTUP MOUNT;
SQL> ALTER DATABASE ARCHIVELOG;
SQL> ALTER DATABASE FORCE LOGGING;
SQL> ALTER DATABASE OPEN;


=== RMAN BACKUP DATABASE ===
rman 
rman> connect target
rman> backup database
rman> backup archivelog all


== create standby instance ===
==============================

- pfile

dgbrno.__db_cache_size=100663296
dgbrno.__java_pool_size=4194304
dgbrno.__large_pool_size=4194304
dgbrno.__shared_pool_size=54525952
dgbrno.__streams_pool_size=0
*.audit_file_dest='C:\oracle\product\10.2.0\admin\DG\adump'
*.background_dump_dest='C:\oracle\product\10.2.0\admin\DG\bdump'
*.compatible='10.2.0.3.0'
*.core_dump_dest='C:\oracle\product\10.2.0\admin\DG\cdump'
*.db_block_size=8192
*.db_domain=''
*.db_file_multiblock_read_count=16
*.db_recovery_file_dest='C:\fra'
*.db_recovery_file_dest_size=2147483648
*.dispatchers='(PROTOCOL=TCP) (SERVICE=DGBRNOXDB)'
*.job_queue_processes=10
*.nls_language='CZECH'
*.nls_territory='CZECH REPUBLIC'
*.open_cursors=300
*.pga_aggregate_target=16777216
*.processes=150
*.sga_target=167772160
*.undo_management='AUTO'
*.undo_tablespace='UNDOTBS1'
*.user_dump_dest='C:\oracle\product\10.2.0\admin\DG\udump'
#################################
# dataguard specific parameters #
#################################
*.CONTROL_FILES='C:/oradata/DG/control01.ctl', 'C:/oradata/DG/control02.ctl','C:/oradata/DG/control03.ctl'
*.DB_NAME=DG
*.DB_UNIQUE_NAME=DGBRNO
*.LOG_ARCHIVE_CONFIG='DG_CONFIG=(DGPRAHA,DGBRNO)'
*.LOG_ARCHIVE_DEST_1='LOCATION=C:/oradata/DG/arch1 VALID_FOR=(ALL_LOGFILES,ALL_ROLES) DB_UNIQUE_NAME=DGBRNO'
*.LOG_ARCHIVE_DEST_2='SERVICE=DGPRAHA LGWR ASYNC VALID_FOR=(ONLINE_LOGFILES,PRIMARY_ROLE) DB_UNIQUE_NAME=DGPRAHA'
*.LOG_ARCHIVE_DEST_STATE_1=ENABLE
*.LOG_ARCHIVE_DEST_STATE_2=ENABLE
*.LOG_ARCHIVE_FORMAT=%t_%s_%r.arc
*.LOG_ARCHIVE_MAX_PROCESSES=30
*.remote_login_passwordfile='EXCLUSIVE'
*.FAL_SERVER=PRAHA
*.FAL_CLIENT=BRNO
*.STANDBY_FILE_MANAGEMENT=AUTO
*
*
- password file
- directory structure according PFILE


== SQLNET ===

- configure standby listener - static registration => Netmanager add database - (for rman duplicate)
SID_LIST_LISTENER =
  (SID_LIST =
    (SID_DESC =
      (SID_NAME = PLSExtProc)
      (ORACLE_HOME = C:\oracle\product\10.2.0\db_1)
      (PROGRAM = extproc)
    )
    (SID_DESC =
      (GLOBAL_DBNAME = DGBRNO)
      (ORACLE_HOME = C:\oracle\product\10.2.0\db_1)
      (SID_NAME = DGBRNO)
    )
  )

LISTENER =
  (DESCRIPTION_LIST =
    (DESCRIPTION =
      (ADDRESS = (PROTOCOL = TCP)(HOST = ORACLE20)(PORT = 1521))
    )
    (DESCRIPTION =
      (ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC0))
    )
  )



- tnsnames.ora

DGPRAHA =
  (DESCRIPTION =
    (ADDRESS_LIST =
      (ADDRESS = (PROTOCOL = TCP)(HOST = oracle10)(PORT = 1521))
    )
    (CONNECT_DATA =
      (SID = DGPRAHA)
    )
 )

DGBRNO =
  (DESCRIPTION =
    (ADDRESS_LIST =
      (ADDRESS = (PROTOCOL = TCP)(HOST = oracle20)(PORT = 1521))
    )
    (CONNECT_DATA =
      (SID = DGBRNO)
    )
 )

- test standby via SQLNET/listener, start nomount standby instance
- sqlplus sys@DGBRNO AS SYSDBA


RMAN duplicate database for standby z FRA
=========================================

na primaru

rman> backup database;
rman> backup archivelog all;
rman> croscheck backup;
rman> backup current controlfile for standby

na standby


rman
rman> connect target SYS@DGPRAHA
rman> connect auxiliary SYS@DGBRNO

rman> DUPLICATE TARGET DATABASE FOR STANDBY NOFILENAMECHECK DORECOVER;

* metalink 419435.1 
 (ORA-19693: backup piece \\HGTUKORA1\RMAN1\BACKUP1\B_0MIB4K5G_1_1 already included)
 (staci udelat pred backup "standby CF" crosscheck, aby se srovnaly zaznamy o backupech)  

==================
file:///D:/documentation/B19306_01/server.102/b14239/rcmbackp.htm#i636377