oracle 19c rac+dg + taf 安装部署

DG rebuild.txt

set verify off
col value format a20
column file_name format a50 word_wrapped
column smallest format 999,990 heading "Smallest|Size|Poss." column currsize format 999,990 heading "Current|Size" column savings format 999,990 heading "Poss.|Savings" break on report
compute sum of savings on report

column value new_val blksize select value from v$parameter where name = 'db_block_size' / select file_name,
       ceil( (nvl(hwm,1)*&&blksize)/1024/1024 ) smallest,
       ceil( blocks*&&blksize/1024/1024) currsize,
       ceil( blocks*&&blksize/1024/1024) -
       ceil( (nvl(hwm,1)*&&blksize)/1024/1024 ) savings from dba_data_files a,
     ( select file_id, max(block_id+blocks-1) hwm from dba_extents group by file_id ) b where a.file_id = b.file_id(+)
/
 
column cmd format a75 word_wrapped set heading off feedback off termout off
spool /tmp/tmp_shrink_data_files.sql select 'alter database datafile '''||file_name||''' resize ' ||
       ceil( (nvl(hwm,1)*&&blksize)/1024/1024 ) || 'm;' cmd from dba_data_files a,
     ( select file_id, max(block_id+blocks-1) hwm from dba_extents group by file_id ) b where a.file_id = b.file_id(+) and ceil( blocks*&&blksize/1024/1024) - ceil( (nvl(hwm,1)*&&blksize)/1024/1024 ) > 0
/
spool off; set heading on feedback on termout on
@/tmp/tmp_shrink_data_files.sql 

------TAF
---primary db
srvctl add service -d itsm -s itsm_app -r "itsm1" -a "itsm2"  -pdb "its" -j short -P basic -e select -m basic -w 5 -z 180 -q true
srvctl start service -d itsm -s itsm_ap


---primary db
srvctl add service -d dgitsm -s itsm_app -r "dgitsm1" -a "dgitsm2" -pdb "its" -j short -P basic -e select -m basic -w 5 -z 180 -q true
srvctl start service -d dgitsm -s itsm_app




itsm_app =
  (DESCRIPTION =
    (ADDRESS = (PROTOCOL = TCP)(HOST = dg-scan.yxit.com)(PORT = 1521))
    (ADDRESS = (PROTOCOL = TCP)(HOST = rac-scan.yxit.com)(PORT = 1521))
    (CONNECT_DATA =
      (SERVER = DEDICATED)
      (SERVICE_NAME = itsm_app.yxit.com)
    )
  )