课程第53/54次（2018-11-05星期一和2018-11-09星期五）

botang

station23：

1. Last login: Mon Nov  5 16:13:51 2018 from station90.example.com
   
2. [root@station23 ~]# su - oracle
   
3. [oracle@station23 ~]$ srvctl config database -d c01orcl
   
4. Database unique name: c01orcl
   
5. Database name: c01orcl
   
6. Oracle home: /u01/app/oracle/product/11.2.0/dbhome_1
   
7. Oracle user: oracle
   
8. Spfile: +DATA/c01orcl/spfilec01orcl.ora
   
9. Domain: example.com
   
10. Start options: open
    
11. Stop options: immediate
    
12. Database role: PRIMARY
    
13. Management policy: AUTOMATIC
    
14. Server pools: c01orcl
    
15. Database instances: c01orcl1,c01orcl2
    
16. Disk Groups: DATA,FRA
    
17. Mount point paths:
    
18. Services:
    
19. Type: RAC
    
20. Database is administrator managed
    
21. [oracle@station23 ~]$
    

复制代码

1. 要改/etc/oratab：
c01orcl1:/u01/app/oracle/product/11.2.0/dbhome_1:N
2. 转成pfile改init.ora：
*.audit_file_dest='/u01/app/oracle/admin/c01orcl/adump'
*.audit_trail='db'
*.cluster_database=true
*.compatible='11.2.0.4.0'
*.control_files='+DATA/c01orcl/controlfile/current.260.991429095','+FRA/c01orcl/controlfile/current.256.991429095'
*.db_block_size=8192
*.db_create_file_dest='+DATA'
*.db_domain='example.com'
*.db_name='c01orcl'
*.db_unique_name='c01orcl'
*.db_recovery_file_dest='+FRA'
*.db_recovery_file_dest_size=15366881280
*.diagnostic_dest='/u01/app/oracle'
*.dispatchers='(PROTOCOL=TCP) (SERVICE=c01orclXDB)'
c01orcl1.instance_number=1
c01orcl2.instance_number=2
*.memory_target=6481248256
*.open_cursors=300
*.processes=650
*.remote_listener='scan23.example.com:1521'
*.remote_login_passwordfile='exclusive'
*.sessions=720
c01orcl2.thread=2
c01orcl1.thread=1
c01orcl1.undo_tablespace='UNDOTBS1'
c01orcl2.undo_tablespace='UNDOTBS2'
*.log_archive_config='dg_config=(c01orcl,c02orcl)'
*.log_archive_dest_1='location=use_db_recovery_file_dest'
*.log_archive_dest_2='service=c02orcl valid_for=(online_logfiles,primary_role) db_unique_name=c02orcl'
*.standby_file_management=auto
*.fal_server=c02orcl
*.fal_client=c01orcl

station25：
1. mkdir /u01/app/oracle/admin/c02orcl/adump

station26：
1. mkdir /u01/app/oracle/admin/c02orcl/adump

station23.zip (8.24 KB, 下载次数: 417)

2018-11-9 20:01 上传

点击文件名下载附件 station24.zip (6.34 KB, 下载次数: 397)

2018-11-9 20:02 上传

点击文件名下载附件 station25.zip (10.57 KB, 下载次数: 389)

2018-11-9 20:02 上传

点击文件名下载附件 station26.zip (7.9 KB, 下载次数: 389)

2018-11-9 20:02 上传

点击文件名下载附件

1. select  * from v$standby_log;

复制代码

	GROUP#	DBID	THREAD#	SEQUENCE#	BYTES	BLOCKSIZE	USED	ARCHIVED	STATUS	FIRST_CHANGE#	FIRST_TIME	NEXT_CHANGE#	NEXT_TIME	LAST_CHANGE#	LAST_TIME
1	5	UNASSIGNED	1	0	524288000	512	0	YES	UNASSIGNED
2	6	UNASSIGNED	1	0	524288000	512	0	YES	UNASSIGNED
3	7	UNASSIGNED	1	0	524288000	512	0	YES	UNASSIGNED
4	8	UNASSIGNED	2	0	524288000	512	0	YES	UNASSIGNED
5	9	UNASSIGNED	2	0	524288000	512	0	YES	UNASSIGNED
6	10	UNASSIGNED	2	0	524288000	512	0	YES	UNASSIGNED

duplicate.rcv：

1. duplicate target database
   
2. for standby
   
3. from active database
   
4. nofilenamecheck
   
5. dorecover
   
6. spfile
   
7. set db_unique_name='c02orcl'
   
8. set remote_listener='scan25.example.com:1521'
   
9. set audit_file_dest='/u01/app/oracle/admin/c02orcl/adump'
   
10. set log_archive_dest_2='service=c01orcl valid_for=(online_logfiles,primary_role) db_unique_name=c01orcl'
    
11. set fal_server='c01orcl'
    
12. set fal_client='c02orcl'
    
13. set control_files='+DATA','+FRA'
    
14. set db_file_name_convert='c01orcl','c02orcl'
    
15. set log_file_name_convert='c01orcl','c02orcl'
    
16. set instance_number='1';

复制代码

1. rman target sys/oracle_4U@c01orcl1 auxiliary sys/oracle_4U@c02orcl1 cmdfile=duplicate.rcv

复制代码