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

来源:互联网 发布:淘宝哪家锂电池好 编辑:程序博客网 时间:2024/06/01 09:53
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
原创粉丝点击