1.主库添加新的表空间,备库中的STANDBY_FILE_MANAGEMENT参数设置为AUTO
2.主库:192.168.14.112
3.备库: 192.168.14.111
查看备库是否为STANDBY_FILE_MANAGEMENT参数是否为AUTO
SQL> show parameter STANDBY_FILE_MANAGEMENT;
NAME TYPE VALUE
------------------------------------ ----------- ----------
standby_file_management string auto
----------------------------------------------------------------------
#主库创建表空间
SQL>create tablespace testabc01
logging
datafile '/u01/app/oracle/oradata/testabc01.dbf'
size 5m
autoextend on
next 10m maxsize 2048m
extent management local;
#查询主库是否创建表空间成功
SQL> select name from v$datafile;
NAME
----------------------------------------------------------------------
/u01/app/oracle/oradata/pdb/system01.dbf
2.主库:192.168.14.112
3.备库: 192.168.14.111
查看备库是否为STANDBY_FILE_MANAGEMENT参数是否为AUTO
SQL> show parameter STANDBY_FILE_MANAGEMENT;
NAME TYPE VALUE
------------------------------------ ----------- ----------
standby_file_management string auto
----------------------------------------------------------------------
#主库创建表空间
SQL>create tablespace testabc01
logging
datafile '/u01/app/oracle/oradata/testabc01.dbf'
size 5m
autoextend on
next 10m maxsize 2048m
extent management local;
#查询主库是否创建表空间成功
SQL> select name from v$datafile;
NAME
----------------------------------------------------------------------
/u01/app/oracle/oradata/pdb/system01.dbf