关于RMAN 复制的理论知识,参考
实验平台: RedHat + Oracle 10g
源库的相关信息:
ORACLE_BASE: /u01/app/oracle
ORACLE_HOME: /u01/app/oracle/product/10.2.0/db_1
ORACLE_SID:ORCL
复制的数据库实例名假设为: DAVE
(1)构建辅助数据库目录结构
(2)修改init.ora 初始话文件
(3)创建辅助实例口令文件
(4)RMAN 备份源库
(5)配置监听
(6)启动辅助库至nomount 状态
(7)RMAN duplicate复制实例
(8)创建spfile
[oracle@db1 oradata]$ ls
orcl
[oracle@db1 oradata]$ pwd
/u01/app/oracle/oradata
[oracle@db1 oradata]$
[oracle@db1 oradata]$ ls
DAVE orcl
[oracle@db1 admin]$ pwd
/u01/app/oracle/admin
[oracle@db1 admin]$ mkdir DAVE
[oracle@db1 admin]$ ls
DAVE orcl
[oracle@db1 admin]$ cd orcl
[oracle@db1 orcl]$ ls
adump bdump cdump dpdump pfile udump
[oracle@db1 DAVE]$ cd ..
[oracle@db1 admin]$ cd DAVE
[oracle@db1 DAVE]$ mkdir bdump
[oracle@db1 DAVE]$ mkdir cdump
[oracle@db1 DAVE]$ mkdir pfile
[oracle@db1 DAVE]$ mkdir udump
[oracle@db1 DAVE]$ ls
adump bdump cdump dpdump pfile udump
SQL> conn / as sysdba
Connected.
SQL> create pfile from spfile;
File created.
[oracle@db1 DAVE]$ cd $ORACLE_HOME/dbs
[oracle@db1 dbs]$ ls
hc_orcl.dat init.ora lkORCL snapcf_orcl.f
initdw.ora orapworcl spfileorcl.ora
[oracle@db1 dbs]$ cp initorcl.ora initDAVE.ora
[oracle@db1 dbs]$ ls
hc_orcl.dat initdw.ora initorcl.ora orapworcl spfileorcl.ora
init.ora lkORCL snapcf_orcl.f
[oracle@db1 dbs]$ more initDAVE.ora
orcl.__db_cache_size=171966464
orcl.__java_pool_size=4194304
orcl.__large_pool_size=4194304
orcl.__shared_pool_size=58720256
orcl.__streams_pool_size=0
*.audit_file_dest='/u01/app/oracle/admin/adump'
*.background_dump_dest='/u01/app/oracle/admin//bdump'
*.compatible='10.2.0.1.0'
*.control_file_record_keep_time=14
*.control_files='/u01/app/oracle/oradata//control01.ctl','/u01/app/oracle/oradata//control02.ctl'
,'/u01/app/oracle/oradata/control03.ctl'
*.core_dump_dest='/u01/app/oracle/admin/cdump'
*.db_block_size=8192
*.db_domain=''
*.db_file_multiblock_read_count=16
*.db_name='DAVE'
*.db_recovery_file_dest='/u01/app/oracle/flash_recovery_area'
*.db_recovery_file_dest_size=2147483648
*.dispatchers='(PROTOCOL=TCP) (SERVICE=orclXDB)'
*.job_queue_processes=10
*.log_archive_dest_1=
*.open_cursors=300
*.pga_aggregate_target=81788928
*.processes=150
*.remote_login_passwordfile='EXCLUSIVE'
*.sga_target=246415360
*.undo_management='AUTO'
*.undo_tablespace='UNDOTBS1'
*.user_dump_dest='/u01/app/oracle/admin//udump'