文档课题:主库添加temp文件,dg端不会同步增加temp文件的验证.
系统:centos7.9 64位
数据库:oracle11.2.0.4 64位
环境:rac (双节点)+ dg
1、测试temp文件
主库节点1操作:
SQL>col file_name for a50
SQL>select file_name,bytes/1024/1024,autoextensible,tablespace_name fromdba_temp_files
FILE_NAME BYTES/1024/1024 AUT TABLESPACE_NAME
----------------------------------------------------------------- --- ------------------------------
+DATA/orcl/tempfile/temp.262.1117373987 60 YES TEMP
SQL>alter tablespace temp add tempfile '+data' size 50m autoextend on;
Tablespacealtered.
SQL>select file_name,bytes/1024/1024,autoextensible,tablespace_name from dba_temp_files;
FILE_NAME BYTES/1024/1024 AUT TABLESPACE_NAME
----------------------------------------------------------------- --- ------------------------------
+DATA/