Oracle:OMF
Oracle管理的文件,即:OMF。
OMF可以管理Oracle中的以下几种文件:表空间、联机日志文件、控制文件。
1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43 44 45 46 47 48 49 50 51 52 53 54 55 56 57 58 59 60 61 62 63 64 65 66 67 68 |
SQL> show parameter db_create NAME TYPE VALUE ------------------------------------ ----------- ------------------------------ db_create_file_dest string db_create_online_log_dest_1 string db_create_online_log_dest_2 string db_create_online_log_dest_3 string db_create_online_log_dest_4 string db_create_online_log_dest_5 string SQL> SQL> show parameter db_recovery_file_dest NAME TYPE VALUE ------------------------------------ ----------- ------------------------------ db_recovery_file_dest string /u01/app/oracle/fast_recovery_ area db_recovery_file_dest_size big integer 4560M SQL> SQL> select file_name from dba_data_files; FILE_NAME -------------------------------------------------------------------------------- /ora_data/allah/system01.dbf /ora_data/allah/sysaux01.dbf /ora_data/allah/users01.dbf /ora_data/allah/undotbs01.dbf SQL> SQL> select tablespace_name from dba_tablespaces; TABLESPACE_NAME ------------------------------ SYSTEM SYSAUX UNDOTBS1 TEMP USERS SQL> SQL> alter system set db_create_file_dest='/ora_data'; System altered. SQL> show parameter db_create_file_dest NAME TYPE VALUE ------------------------------------ ----------- ------------------------------ db_create_file_dest string /ora_data SQL> SQL> create tablespace allah; Tablespace created. SQL> select file_name from dba_data_files; FILE_NAME -------------------------------------------------------------------------------- /ora_data/allah/system01.dbf /ora_data/allah/sysaux01.dbf /ora_data/allah/undotbs01.dbf /ora_data/allah/users01.dbf /ora_data/ALLAH/datafile/o1_mf_allah_b5jmqm12_.dbf SQL> !du -sh /ora_data/ALLAH/datafile/* 101M /ora_data/ALLAH/datafile/o1_mf_allah_b5jmqm12_.dbf SQL> |
——————————————————————————————————
Ending。