用Rman创建physical Standby

Primary : HP-UX  ORACLE 9.2.0.8
Standby:  HP-UX  ORACLE 9.2.0.8

On Primary:

Backup Scripts:
rman targetsys/password@tpmes  catalogrmantest/rmantest@rman
run
{
allocate channel ch1 device type 'sbt_tape';
backup database
  include current controlfile for standby
 plus archivelogdelete all input;
release channel ch1;
}

On Standby:
orapwd file=tpstb password=p
export ORACLE_SID=tpstb
startup nomount;

rman targetsys/password@tpmes  catalogrmantest/rmantest@rmanAUXILIARY /

Restore Scripts:
run {
allocate auxiliary channel ch1 device  type 'SBT_TAPE' PARMS 'ENV=(NB_ORA_CLIENT=g18wlpd0)';
SET newname FOR DATAFILE  1  to '/data/oradata/tpstb/system01.dbf';
SET newname FOR DATAFILE  2  to '/data/oradata/tpstb/undotbs01.dbf';
SET newname FOR DATAFILE  3  to '/data/oradata/tpstb/indx01.dbf';
SET newname FOR DATAFILE  4  to '/data/oradata/tpstb/tools01.dbf';
SET newname FOR DATAFILE  5  to '/data/oradata/tpstb/users01.dbf';
DUPLICATE TARGET DATABASE FOR STANDBY
DORECOVER
NOFILENAMECHECK;
}

pfile:
On Primary:

*.background_dump_dest='/data/app/oracle/admin/tpmes/bdump'
*.compatible='9.2.0.0.0'
*.control_files='/data/app/oracle/oradata/tpmes/control01.ctl','/data/app/oracle/oradata/tpmes/control02.ctl','/data/app/oracle/oradata/tpmes/control03.ctl'
*.core_dump_dest='/data/app/oracle/admin/tpmes/cdump'
*.db_block_size=8192
*.db_cache_size=16777216
*.db_domain=''
*.db_file_multiblock_read_count=16
*.db_name='tpmes'
*.fast_start_mttr_target=300
*.hash_join_enabled=TRUE
*.instance_name='tpmes'
*.java_pool_size=0
*.job_queue_processes=2
*.large_pool_size=8388608
*.log_archive_dest_1='LOCATION=/data2/archive/tpmes'
*.log_archive_format='%t_%s.dbf'
*.log_archive_start=true
*.open_cursors=300
*.pga_aggregate_target=25165824
*.processes=150
*.query_rewrite_enabled='FALSE'
*.remote_login_passwordfile='EXCLUSIVE'
*.shared_pool_size=33554432
*.sort_area_size=524288
*.star_transformation_enabled='FALSE'
*.timed_statistics=TRUE
*.undo_management='AUTO'
*.undo_retention=10800
*.undo_tablespace='UNDOTBS1'
*.user_dump_dest='/data/app/oracle/admin/tpmes/udump'
*.utl_file_dir='/data2/purge/loader'

On Standby:
*.background_dump_dest='/opt/oracle/admin/tpstb/bdump'
*.compatible='9.2.0.0.0'
*.control_files='/data/oradata/tpstb/control01.ctl','/data/oradata/tpstb/control02.ctl','/data/oradata/tpstb/control03.ctl'
*.core_dump_dest='/opt/oracle/admin/tpstb/cdump'
*.db_block_size=8192
*.db_cache_size=16777216
*.db_domain=''
*.db_file_multiblock_read_count=16
*.db_name='tpmes'
*.fast_start_mttr_target=300
*.hash_join_enabled=TRUE
*.instance_name='tpstb'
*.service_names='tpstb'
*.fal_client='tpstb'
*.fal_server='tpmes'
*.db_file_name_convert=('/data2/oradata/tpmes/','/data/oradata/tpstb/')
*.log_file_name_convert=('/data/app/oracle/oradata/tpmes/','/data/oradata/tpstb/')
*.java_pool_size=0
*.job_queue_processes=2
*.large_pool_size=8388608
*.log_archive_dest_1='LOCATION=/data/oradata/arch/'
*.standby_archive_dest='LOCATION=/data/oradata/stbarch/'
*.remote_archive_enable='TRUE'
*.standby_file_management='AUTO'
*.log_archive_format='%t_%s.dbf'
*.log_archive_start=true
*.open_cursors=300
*.pga_aggregate_target=25165824
*.processes=150
*.query_rewrite_enabled='FALSE'
*.remote_login_passwordfile='EXCLUSIVE'
*.shared_pool_size=33554432
*.sort_area_size=524288
*.star_transformation_enabled='FALSE'
*.timed_statistics=TRUE
*.undo_management='AUTO'
*.undo_retention=10800
*.undo_tablespace='UNDOTBS1'
*.user_dump_dest='/opt/oracle/admin/tpstb/udump'
*.dg_broker_start='TRUE'

tnsnames.ora
On Primary:
TPMES =
  (DESCRIPTION =
    (ADDRESS_LIST =
      (ADDRESS = (PROTOCOL = TCP)(HOST = 192.168.0.5)(PORT = 1521))
    )
    (CONNECT_DATA =
      (SERVER = DEDICATED)
      (SERVICE_NAME = tpmes)
    )
  )
RMAN =
  (DESCRIPTION =
   (ADDRESS_LIST =
   (ADDRESS = (PROTOCOL = TCP)(HOST = 192.168.0.8)(PORT = 1521))
   )
    (CONNECT_DATA =
   (SERVER = DEDICATED)
  (SERVICE_NAME = rman)
     )
        )
 
tpstb =
  (DESCRIPTION =
      (ADDRESS_LIST =
            (ADDRESS = (PROTOCOL = TCP)(HOST = 192.168.0.2)(PORT = 1521))
                )
                    (CONNECT_DATA =
                         (SERVER = DEDICATED)
                         (SID = tpstb)
                )
     )

On Standby:
RMAN =
  (DESCRIPTION =
    (ADDRESS_LIST =
      (ADDRESS = (PROTOCOL = TCP)(HOST = 192.168.0.8)(PORT = 1521))
    )
    (CONNECT_DATA =
      (SERVER = DEDICATED)
      (SERVICE_NAME = rman)
    )
  )
 
tpmes =
  (DESCRIPTION =
    (ADDRESS_LIST =
      (ADDRESS = (PROTOCOL = TCP)(HOST = 192.168.0.5)(PORT = 1521))
    )
    (CONNECT_DATA =
      (SERVER = DEDICATED)
      (SERVICE_NAME = tpmes)
    )
  )
 
tpstb =
  (DESCRIPTION =
    (ADDRESS_LIST =
      (ADDRESS = (PROTOCOL = TCP)(HOST = 192.168.0.2)(PORT = 1521))
    )
    (CONNECT_DATA =
      (SERVER = DEDICATED)
      (SERVICE_NAME = tpstb)
    )
  )

Listener.ora
On Primary:
SID_LIST_LISTENER =
  (SID_LIST =
    (SID_DESC =
      (SID_NAME = PLSExtProc)
      (ORACLE_HOME = /data/app/oracle/product/920)
      (PROGRAM = extproc)
    )
    (SID_DESC =
      (GLOBAL_DBNAME = tpmes)
      (ORACLE_HOME = /data/app/oracle/product/920)
      (SID_NAME = tpmes)
    )
  )
 
LISTENER =
  (DESCRIPTION_LIST =
    (DESCRIPTION =
      (ADDRESS_LIST =
        (ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC))
      )
      (ADDRESS_LIST =
        (ADDRESS = (PROTOCOL = TCP)(HOST = 192.168.0.5)(PORT = 1521))
      )
    )
  )

On Standby:
SID_LIST_LISTENER =
  (SID_LIST =
    (SID_DESC =
      (SID_NAME = PLSExtProc)
      (ORACLE_HOME = /opt/oracle/product/920)
      (PROGRAM = extproc)
    )
        (SID_DESC =
              (GLOBAL_DBNAME = tpstb)
                    (ORACLE_HOME = /opt/oracle/product/920)
                          (SID_NAME = tpstb)
                              )
    (SID_DESC =
      (GLOBAL_DBNAME = tpmes)
      (ORACLE_HOME = /opt/oracle/product/920)
      (SID_NAME = tpmes)
    )
  )
 
LISTENER =
  (DESCRIPTION_LIST =
    (DESCRIPTION =
      (ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC))
    )
    (DESCRIPTION =
      (ADDRESS = (PROTOCOL = TCP)(HOST = 192.168.0.2)(PORT = 1521))
    )
  )