scp /gp/oradata/temp01.dbf dgdb@192.168.165.26:/opt/dgdb/oradata/dgdb/
scp /gp/oradata/users01.dbf dgdb@192.168.165.26:/opt/dgdb/oradata/dgdb/
6.修改备库初始化参数文件
[dgdb@rac1 dbs]$ cat initdgdb.ora
dgdb.__db_cache_size=557842432
dgdb.__java_pool_size=25165824
dgdb.__large_pool_size=4194304
dgdb.__shared_pool_size=255852544
dgdb.__streams_pool_size=130023424
*.aq_tm_processes=0
*.audit_file_dest='/opt/dgdb/admin/dgdb/adump'
*.audit_trail='DB'
*.background_dump_dest='/opt/dgdb/admin/dgdb/bdump'
*.compatible='10.2.0.3.0'
*.control_files='/opt/dgdb/oradata/dgdb/dg01.ctl','/opt/dgdb/oradata/dgdb/dg02.ctl','/opt/dgdb/oradata/dgdb/dg03.ctl'
*.core_dump_dest='/opt/dgdb/admin/dgdb/cdump'
*.cursor_sharing='EXACT'
*.db_block_size=8192
*.db_domain=''
*.db_file_multiblock_read_count=32
*.db_file_name_convert='/opt/ora10g/oradata/vsgpdb','/opt/dgdb/oradata/dgdb','/opt/dgdb/oradata/dgdb','/opt/ora10g/oradata/vsgpdb'
*.db_keep_cache_size=33554432
*.db_name='vsgpdb'
*.db_recovery_file_dest='/opt/dgdb/flash_recovery_area'
*.db_recovery_file_dest_size=10737418240
*.dispatchers='(PROTOCOL=TCP) (SERVICE=dgdbXDB)'
*.fal_client='DGDB'
*.fal_server='VSGPDB'
*.global_names=TRUE
*.job_queue_processes=10
*.log_archive_config='DG_CONFIG=(vsgpdb,dgdb)'
*.log_archive_dest_1='location=/gp/arch'
*.log_archive_dest_2='SERVICE=vsgpdb LGWR SYNC AFFIRM VALID_FOR=(ONLINE_LOGFILES,PRIMARY_ROLE) DB_UNIQUE_NAME=vsgpdb'
*.log_archive_dest_state_2=ENABLE
*.log_archive_format='arch%t_%s_%r.arc'
*.log_buffer=61081600
*.log_file_name_convert='/opt/ora10g/oradata/vsgpdb','/opt/dgdb/oradata/dgdb','/opt/dgdb/oradata/dgdb','/opt/ora10g/oradata/vsgpdb'
*.nls_date_format='YYYY-MM-DD HH24:MI:SS'
*.open_cursors=300
*.open_links=4
*.parallel_max_servers=20
*.pga_aggregate_target=170917888
*.processes=150
*.recyclebin='OFF'
*.remote_login_passwordfile='EXCLUSIVE'
*.sga_max_size=1073741824
*.sga_target=1073741824
*.standby_file_management='AUTO'
*.star_transformation_enabled='TRUE'
*.streams_pool_size=26214400
*.trace_enabled=FALSE
*.undo_management='AUTO'
*.undo_retention=3600
*.undo_tablespace='UNDOTBS1'
*.user_dump_dest='/opt/dgdb/admin/dgdb/udump'
*.utl_file_dir='*'
[dgdb@rac1 dbs]$
[dgdb@rac1 dbs]$ sqlplus / as sysdba
SQL*Plus: Release 10.2.0.4.0 - Production on Wed Aug 21 08:55:38 2013
Connected to an idle instance.
SQL>create spfile from pfile='/opt/dgdb/product/10.2.0/db_1/dbs/initdgdb.ora';
startup mount
相关参考: