oracle 12c Single Instance to Single Instance的Active Database Duplicate测试

oracle 12c Single Instance to Single Instance的Active Database Duplicate测试
--target
SQL> archive log list  
Database log mode              No Archive Mode
Automatic archival             Disabled
Archive destination            /home/oracle/app/oracle/product/12.1.0/db_1/dbs/arch
Oldest online log sequence     278
Current log sequence           280
SQL> shutdown immediate
Database closed.
Database dismounted.
ORACLE instance shut down.
SQL> startup mount
ORA-32004: obsolete or deprecated parameter(s) specified for RDBMS instance
ORACLE instance started.

Total System Global Area 2516582400 bytes
Fixed Size                  2927528 bytes
Variable Size             973079640 bytes
Database Buffers         1526726656 bytes
Redo Buffers               13848576 bytes
Database mounted.
SQL> alter database archivelog
  2  ;

Database altered.

SQL> alter database open;

Database altered.

SQL> archive log list;
Database log mode              Archive Mode
Automatic archival             Enabled
Archive destination            /home/oracle/app/oracle/product/12.1.0/db_1/dbs/arch
Oldest online log sequence     278
Next log sequence to archive   280
Current log sequence           280
SQL>

--auxiliary
cat initauxdb.ora
*.audit_file_dest='/home/oracle/app/oracle/admin/oradb/adump'
*.audit_trail='db'
*.compatible='12.1.0.2.0'
*.control_files='/home/oracle/app/oracle/oradata/oradb/control01.ctl','/home/oracle/app/oracle/fast_recovery_area/oradb/control02.ctl'
*.db_block_size=8192
*.db_name='oradb'

db_file_name_convert=('/home/oracle/app/oracle/oradata/tardb','/home/oracle/app/oracle/oradata/oradb','/home/oracle/app/oracle/oradata/tsp_tardb','/home/oracle/app/oracle/oradata/oradb')
log_file_name_convert=('/home/oracle/app/oracle/oradata/tardb','/home/oracle/app/oracle/oradata/oradb')

cp orapwtardb orapwauxdb

startup nomount pfile='/home/oracle/app/oracle/product/12.1.0/db_1/dbs/initauxdb.ora';

--target
rman target sys/tardb@10.16.28.200/tardb auxiliary sys/tardb@172.16.28.210/oradb
--duplicate target database to oradb from active database;
duplicate target database to oradb from active database nofilenamecheck;



--auxiliary check
ALTER SYSTEM SET SEC_CASE_SENSITIVE_LOGON = FALSE;
select name from v$datafile;
select host_name,instance_name,status from gv$instance;
show parameter name
show parameter pfile
select * from v$log;
select * from v$logfile;

  • 0
    点赞
  • 0
    收藏
    觉得还不错? 一键收藏
  • 0
    评论

“相关推荐”对你有帮助么?

  • 非常没帮助
  • 没帮助
  • 一般
  • 有帮助
  • 非常有帮助
提交
评论
添加红包

请填写红包祝福语或标题

红包个数最小为10个

红包金额最低5元

当前余额3.43前往充值 >
需支付:10.00
成就一亿技术人!
领取后你会自动成为博主和红包主的粉丝 规则
hope_wisdom
发出的红包
实付
使用余额支付
点击重新获取
扫码支付
钱包余额 0

抵扣说明:

1.余额是钱包充值的虚拟货币,按照1:1的比例进行支付金额的抵扣。
2.余额无法直接购买下载,可以购买VIP、付费专栏及课程。

余额充值