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;
--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
- oracle 12c Single Instance to Single Instance的Active Database Duplicate测试
- oracle 12c RAC to Single Instance的Active Database Duplicate测试
- Migrate database from single instance to Oracle RAC
- GoldenGate -1> oracle 12c RAC to Single Instance 数据同步
- Convert 10g Single-Instance database to 10g RAC
- Convert a Single Instance Database to Oracle RAC 10g on RHEL3
- Convert Oracle 9i Single-Instance database to 10g RAC .
- Oracle 11.2.0.4.0 RAC Using RMAN Recovery to Single Instance Database
- rac restore to single instance
- Upgrading ASM instance from Oracle 10.1 to Oracle 10.2. (Single Instance)
- Upgrading ASM instance from Oracle 10.1 to Oracle 10.2. (Single Instance)
- single instance to 3 node rac
- 浅谈ORACLE AWR single instance 一
- How to change single-instance database to RAC(10g)
- How to Convert 10g Single-Instance database to 10g RAC using Manual Conversion procedure
- How to Convert 10g Single-Instance database to 10g RAC using Manual Conversion procedure
- Convert Single Instance to RAC – Part 1: Duplicate DB using RMAN
- template + single instance
- 归档接档实现收藏 数据保存
- 关于数位板怎么用,电脑绘画入门篇
- CSS之简易相册
- iOS APP提示升级直接跳转到AppStore
- 成都男子电脑文件被病毒绑架 解密需3个比特币
- oracle 12c Single Instance to Single Instance的Active Database Duplicate测试
- SpringCloud-Learning -作者:翟永超
- Apache Tomcat 启动异常
- android 启动白屏问题完美解决
- jQuery focus和blur事件
- css实现太极图标
- HTML第二章横纵同时
- 框架关联
- 小编也疯狂:什么是封停机器