课程第53/54次（2018-11-05星期一和2018-11-09星期五）
station23：Last login: Mon Nov5 16:13:51 2018 from station90.example.com
# su - oracle
$ srvctl config database -d c01orcl
Database unique name: c01orcl
Database name: c01orcl
Oracle home: /u01/app/oracle/product/11.2.0/dbhome_1
Oracle user: oracle
Spfile: +DATA/c01orcl/spfilec01orcl.ora
Domain: example.com
Start options: open
Stop options: immediate
Database role: PRIMARY
Management policy: AUTOMATIC
Server pools: c01orcl
Database instances: c01orcl1,c01orcl2
Disk Groups: DATA,FRA
Mount point paths:
Services:
Type: RAC
Database is administrator managed
$
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
select* from v$standby_log;
GROUP#DBIDTHREAD#SEQUENCE#BYTESBLOCKSIZEUSEDARCHIVEDSTATUSFIRST_CHANGE#FIRST_TIMENEXT_CHANGE#NEXT_TIMELAST_CHANGE#LAST_TIME
15UNASSIGNED105242880005120YESUNASSIGNED
26UNASSIGNED105242880005120YESUNASSIGNED
37UNASSIGNED105242880005120YESUNASSIGNED
48UNASSIGNED205242880005120YESUNASSIGNED
59UNASSIGNED205242880005120YESUNASSIGNED
610UNASSIGNED205242880005120YESUNASSIGNED
duplicate.rcv：
duplicate target database
for standby
from active database
nofilenamecheck
dorecover
spfile
set db_unique_name='c02orcl'
set remote_listener='scan25.example.com:1521'
set audit_file_dest='/u01/app/oracle/admin/c02orcl/adump'
set log_archive_dest_2='service=c01orcl valid_for=(online_logfiles,primary_role) db_unique_name=c01orcl'
set fal_server='c01orcl'
set fal_client='c02orcl'
set control_files='+DATA','+FRA'
set db_file_name_convert='c01orcl','c02orcl'
set log_file_name_convert='c01orcl','c02orcl'
set instance_number='1';
rman target sys/oracle_4U@c01orcl1 auxiliary sys/oracle_4U@c02orcl1 cmdfile=duplicate.rcv
页:
[1]