Liunx中Oracle 11g duplicate恢复至异机---实测

源端    ： liunx6 oracle 11.2.0.1.0       

主机名： zwl1   

IP： 192.168.43.191

目标端：liunx6 oracle  11.2.0.1.0

主机名： zwl2     

IP： 192.168.43.192

        Oracle11g duplicate相比于10g需要将备份文件拷贝至目标端进行恢复，11g duplicate可在源库开启状态进行恢复数据库至目标端，源库可不用进行备份，操作简单方便。适用于恢复测试库、主库异机恢复、搭建DG等.

以下在oracle用户下操作：

1.源端开启归档：
SQL> archive log list;
Database log mode              Archive Mode
Automatic archival             Enabled
Archive destination            /home/oracle/arch1
Oldest online log sequence     28
Next log sequence to archive   30
Current log sequence           30

如未配置归档，如下配置归档：

$sqlplus / as sysdba
SQL>startup mount
SQL>alter system set log_archive_dest_1='location=/home/oracle/arch1';
SQL>alter database archivelog;
SQL>alter database open;

2.配置监听源端和目标端：
源端tnsname.ora
PROD1 =
  (DESCRIPTION =
    (ADDRESS_LIST =
      (ADDRESS = (PROTOCOL = TCP)(HOST = zwl1.us.oracle.com)(PORT = 1521))
    )
    (CONNECT_DATA =
      (SERVER = DEDICATED)
      (SERVICE_NAME = PROD1.US.ORACLE.COM)
    )
  )

PROD5 =
  (DESCRIPTION =
    (ADDRESS_LIST =
      (ADDRESS = (PROTOCOL = TCP)(HOST = zwl2)(PORT = 1521))
    )
    (CONNECT_DATA =
      (SERVER = DEDICATED)
      (SERVICE_NAME = PROD5.US.ORACLE.COM)
    )
  )

目标端tnsname.ora
PROD1 =
  (DESCRIPTION =
    (ADDRESS_LIST =
      (ADDRESS = (PROTOCOL = TCP)(HOST = zwl1.us.oracle.com)(PORT = 1521))
    )
    (CONNECT_DATA =
      (SERVER = DEDICATED)
      (SERVICE_NAME = PROD1.us.oracle.com)
    )
  )

PROD5 =
  (DESCRIPTION =
    (ADDRESS_LIST =
      (ADDRESS = (PROTOCOL = TCP)(HOST = zwl2.us.oracle.com)(PORT = 1521))
    )
    (CONNECT_DATA =
      (SERVER = DEDICATED)
      (SERVICE_NAME = PROD5.us.oracle.com)
    )
  )
目标端：listener.ora(需要配置静态监听，源端连接nomount状态目标端)
ADR_BASE_LSNR2 = /u01/app/oracle

SID_LIST_LISTENER =
  (SID_LIST =
    (SID_DESC =
      (GLOBAL_DBNAME = PROD4.us.oracle.com)
      (ORACLE_HOME = /u01/app/oracle/product/11.2.0/db_1)
      (SID_NAME = PROD4)
    )
    (SID_DESC =
      (GLOBAL_DBNAME = EMREP.us.oracle.com)
      (ORACLE_HOME = /u01/app/oracle/product/11.2.0/db_1)
      (SID_NAME = EMREP)
    )
    (SID_DESC =
      (GLOBAL_DBNAME = PROD5.us.oracle.com)
      (ORACLE_HOME = /u01/app/oracle/product/11.2.0/db_1)
      (SID_NAME = PROD5)
    )
  )

LISTENER =
  (DESCRIPTION =
    (ADDRESS = (PROTOCOL = TCP)(HOST = zwl2.us.oracle.com)(PORT = 1521))
  )

ADR_BASE_LISTENER = /u01/app/oracle

ENABLE_GLOBAL_DYNAMIC_ENDPOINT_LISTENER = ON

3.源端生成pfile文件及密码文件传至目标端，目标端修改参数文件配置路径并启动到nomount状态

源端操作：

$sqlplus  / as sysdba

SQL>create pfile='/home/oracle/initPROD1.ora' from spfile;

目标端操作:

修改pfile文件 
$vim $ORACLE_HOME/dbs/initPROD5.ora
PROD5.__db_cache_size=213909504
PROD5.__java_pool_size=4194304
PROD5.__large_pool_size=41943040
PROD5.__oracle_base='/u01/app/oracle'#ORACLE_BASE set from environment
PROD5.__pga_aggregate_target=213909504
PROD5.__sga_target=637534208
PROD5.__shared_io_pool_size=0
PROD5.__shared_pool_size=360710144
PROD5.__streams_pool_size=8388608
*.audit_file_dest='/u01/app/oracle/admin/PROD5/adump'
*.audit_trail='db'
*.compatible='11.2.0.0.0'
*.control_files='/u01/app/oracle/oradata/PROD5/controlfile/o1_mf_bpy15704_.ctl',
'/u01/app/oracle/flash_recovery_area/PROD5/controlfile/o1_mf_bpy15799_.ctl','/u0
1/app/oracle/oradata/PROD5/controlfile/control03.ctl'
*.db_block_size=8192
*.db_create_file_dest='/u01/app/oracle/oradata'
*.db_domain='US.ORACLE.COM'
*.db_name='PROD5'
*.db_recovery_file_dest='/home/oracle/flash'
*.db_recovery_file_dest_size=4294967296
*.diagnostic_dest='/u01/app/oracle/product/11.2.0/db_1'
*.dispatchers='(PROTOCOL=TCP)(DISPATCHERS=3)'
*.job_queue_processes=15
*.log_archive_dest_1='location=/home/oracle/arch1'
*.max_dispatchers=10
*.max_shared_servers=30
*.open_cursors=300
*.parallel_degree_policy='AUTO'
*.parallel_max_servers=100
*.parallel_min_servers=10
*.parallel_min_time_threshold='5'
*.pga_aggregate_target=211812352
*.processes=135
*.remote_login_passwordfile='EXCLUSIVE'
*.sessions=300
*.sga_target=635437056
*.star_transformation_enabled='TRUE'
*.undo_retention=5400
*.undo_tabl