Oracle ADW Storage Tips
Oracle ADW 存储相关的Tips
ADW的限制
Restrictions for Database Features
Restrictions for Database Initialization Parameters
存储相关的Tips
创建ADW实例时候指定了Storage容量大小(1TB),使用上限是创建时候设置。如果使用到了上限，并不会自动扩展。
另外表空间和自创表空间的自动扩展是打开的(ON)的,另外也可以是用alter database datafile …. resize修改大小。
alter database datafile 'xxxx' autoextend on maxsize xxxGB;
如下默认有如下的表空间。
SQL> col file_name for a90
SQL> select file_name,tablespace_name,status,bytes/1024/1024/1024 from dba_data_files;
FILE_NAME TABLESPACE_NAME STATUS BYTES/1024/1024/1024
------------------------------------------------------------------------------------------ ------------------------------ --------- --------------------
+DATA/XXXXXXX/84539F43E9836FD8E0530818000AC97E/DATAFILE/system.7061.1003215437 SYSTEM AVAILABLE .176757813
+DATA/XXXXXXX/84539F43E9836FD8E0530818000AC97E/DATAFILE/sysaux.5651.1003215441 SYSAUX AVAILABLE .391235352
+DATA/XXXXXXX/84539F43E9836FD8E0530818000AC97E/DATAFILE/undotbs1.8063.1003215435 UNDOTBS1 AVAILABLE .17578125
+DATA/XXXXXXX/84539F43E9836FD8E0530818000AC97E/DATAFILE/data.7994.1003215433 DATA AVAILABLE 10.0976563
+DATA/XXXXXXX/84539F43E9836FD8E0530818000AC97E/DATAFILE/dbfs_data.7997.1003215433 DBFS_DATA AVAILABLE .09765625
+DATA/sampleschema_dbf SAMPLESCHEMA AVAILABLE 200
+DATA/XXXXXXX/84539F43E9836FD8E0530818000AC97E/DATAFILE/undo_8.5653.1003215653 UNDO_8 AVAILABLE .17578125
7 rows selected.
SQL>
SQL> alter database datafile '+DATA/XXXXXXX/84539F43E9836FD8E0530818000AC97E/DATAFILE/data.7994.1003215433' resize 20G;
Database altered.
SQL>
SQL> select file_name,tablespace_name,status,bytes/1024/1024/1024 from dba_data_files;
FILE_NAME TABLESPACE_NAME STATUS BYTES/1024/1024/1024
------------------------------------------------------------------------------------------ ------------------------------ --------- --------------------
+DATA/XXXXXXX/84539F43E9836FD8E0530818000AC97E/DATAFILE/system.7061.1003215437 SYSTEM AVAILABLE .176757813
+DATA/XXXXXXX/84539F43E9836FD8E0530818000AC97E/DATAFILE/sysaux.5651.1003215441 SYSAUX AVAILABLE .391235352
+DATA/XXXXXXX/84539F43E9836FD8E0530818000AC97E/DATAFILE/undotbs1.8063.1003215435 UNDOTBS1 AVAILABLE .17578125
+DATA/XXXXXXX/84539F43E9836FD8E0530818000AC97E/DATAFILE/data.7994.1003215433 DATA AVAILABLE 20
+DATA/XXXXXXX/84539F43E9836FD8E0530818000AC97E/DATAFILE/dbfs_data.7997.1003215433 DBFS_DATA AVAILABLE .09765625
+DATA/sampleschema_dbf SAMPLESCHEMA AVAILABLE 200
+DATA/XXXXXXX/84539F43E9836FD8E0530818000AC97E/DATAFILE/undo_8.5653.1003215653 UNDO_8 AVAILABLE .17578125
7 rows selected.
SQL>
备份：保留60天的备份策列，每天自动备份，另外这备份文件存放之前创建adw实例时候指定的存储大小内部，而是Ojbect Storage(用户是访问不了)
Have a good work&life! 2019/03 via LinHong