- 论坛徽章:
- 0
|
http://unixman.tk/?p=600
rman总结3 dup
it’s not setup by setup
1. 创建目标实例
$ export ORACLE_SID=dupdb1
##如果是windows,需要oradim先新建一个服务
2. 创建目录
$ cd /oracle/admin/
$ mkdir adump bdump cdump dpdump udump
3 创建,配置pfile
从原来的库弄一个出来
SQL> create pfile=’/home/oracle/pfile.dup’ from spfile;
修改参数
注意: 如果目标和源库的dbfile,logfile存放位置不一致,需要增加2个参数.
db_file_name_convert,log_file_name_convert
exp:
.db_file_name_convert=’/dev’,'/oradata/orcl’
.log_file_name_convert=’/dev’,'/oradata/orcl’
再从pfile.dup创建spfile
SQL>create spfile from pfile=’/home/oracle/pfile.dup’
4.创建密码文件
$orapwd file=/oracle/product/10.2.0.db_1/dbs/PWDdupdb1.ora
5.启动到nomount
SQL>startup nomount;
6. 创建dupdb1的listener
7. 修改源库的tnsname.ora
增加一个dupdb1的连接.
8. 在源裤创建一个full database backupset
9. 把源库的备份set scp到目标库,注意存放位置要跟源库一致.(也可以用nfs mount)
10. 执行复制
>rman target / auxliary sys/oracle@dupdb1
>duplicate target database to “dupdb1″ nofilenamecheck;
需要注意的是,如果源和目标库的dbfile和logfile路径一致,那么需要增加 nofilenamecheck的参数.
如果不一致,需要修改目标库的pfile,增加 db_file_name_convert,log_file_name_convert这2个参数.
下面是个目标库pfile的例子 ,供参考
- stb.__db_cache_size=1207959552
- stb.__java_pool_size=16777216
- stb.__large_pool_size=16777216
- stb.__shared_pool_size=352321536
- stb.__streams_pool_size=0
- *.audit_file_dest='/oracle/app/admin/orcl/adump'
- *.background_dump_dest='/oracle/app/admin/orcl/bdump'
- *.compatible='10.2.0.3.0'
- *.control_files='/oradata/orcl/control01','/oradata/orcl/control02'#Restore Controlfile
- *.core_dump_dest='/oracle/app/admin/orcl/cdump'
- *.db_block_size=8192
- *.db_domain=''
- *.db_file_multiblock_read_count=16
- *.db_file_name_convert='/dev','/oradata/orcl'
- *.db_name='orcl'
- *.db_unique_name='stb'
- *.fal_client='STB'
- *.fal_server='ORCL'
- orcl1.instance_number=1
- orcl2.instance_number=2
- *.job_queue_processes=10
- *.log_archive_config='dg_config=(orcl,stb)'
- *.log_archive_dest_1='LOCATION=/archive valid_for=(all_logfiles,all_roles)
- db_unique_name=stb'
- *.log_archive_dest_state_1='ENABLE'
- *.log_archive_format='%t_%s_%r.arc'
- *.log_archive_max_processes=4
- *.log_file_name_convert='/dev','/oradata/orcl'
- *.open_cursors=300
- *.pga_aggregate_target=3304062976
- *.processes=1000
- *.remote_login_passwordfile='EXCLUSIVE'
- *.sessions=1105
- *.sga_target=1610612736
- *.standby_file_management='AUTO'
- *.undo_management='AUTO'
- *.undo_tablespace='UNDOTBS1'
复制代码 |
|