确定裸设备上控制文件的大小

1. 使用oracle的工具dbfsize

[AIXP55A:oracle:/oracle/product/9.2.0/dbs]>dbfsize ./db_control1
Database file: ./db_control1
Database file type: raw device without 4K starting offset
Database file size: 286 8192 byte blocks

2.执行完下面的SQL语句,再到user_dump_dest目录查看刚产生的trc文件

SQL> ALTER SESSION SET EVENTS 'IMMEDIATE TRACE NAME CONTROLF LEVEL 10';

DUMP OF CONTROL FILES, Seq # 62704 = 0xf4f0
 V10 STYLE FILE HEADER:
 Compatibility Vsn = 169870080=0xa200300
 Db ID=1714783872=0x66358680, Db Name='WEBDATA'
 Activation ID=0=0x0
 Control Seq=62704=0xf4f0, File size=438=0x1b6
 File Number=0, Blksiz=16384, File Type=1 CONTROL

438*16384+16384=7192576bytes 这就是控制文件的大小

原文地址:https://www.cnblogs.com/jasonsfu/p/1156125.html