Oracle 12c 부터 RAW device가 desupport 됩니다. 

Oracle 12c, Desupport for Raw Storage Devices

 

어찌어찌 해서 raw device를 사용한채로 upgrade를 한다해도 raw device를 direct로 사용하면 오류 발생할 거라네요. 

12c로 upgrade 할땐 ASM으로의 migration 까지도 염두해 둬야 되겠네요.. OTL


언듯 raw device 별로 diskgroup을 만들어 tablespace를 생성하는 꼼수가 머리를 스치는 군요 .. ㅋ 



Starting with Oracle Database version 12.1 (release date TBD), support for storing data files, spfiles, controlfiles, online redo logfiles, OCRs and voting files on raw devices directly will end. This means commands such as the following will report an error while attempting to use raw devices directly in Oracle Database Version 12.1:


SQL> create tablespace ABC DATAFILE '/dev/raw/raw1' size 2GB;


Note that while the direct use of raw devices will be de-supported for Oracle Database 12.1, customers can choose to create Oracle ASM diskgroups on top of raw devices. While it is recommended to store all shared files on ASM diskgroups, storing those files on NFS or certified cluster file systems remains supported.


The following SQL commands will not return an error while attempting to use raw devices. Reason: the raw devices in the example below are used indirectly via Oracel ASM (no direct use of raw devices here):


SQL>alter diskgroup MYDG add disk '/dev/raw/ABC1.dbf';

 OR

SQL>create diskgroup MYDB EXTERNAL REDUNDANCY disk 'dev/raw/ABC1.dbf'


Then use the following command to create the tablespace


SQL> create tablespace ABC DATAFILE '+MYDG' size 2GB;


If raw devices are not being used directly in the current release then no further actions need to be taken. However, if raw devices are being used directly currently, then planning should be performed to migrate respective files off raw devices. There are many choices currently to replace raw devices, including Oracle ASM, NFS, and supported cluster file systems.


참고 : Announcement of De-Support of using RAW devices in Oracle Database Version 12.1 (Doc ID 578455.1)


+ Recent posts