控制文件获取信息-CSDN博客

本文链接：https://blog.csdn.net/minwang593/article/details/12571313

1 创建控制文件

alter database backup controlfile to trace as '/oracle/DEV/control01.bak';

2 查看/oracle/DEV/control01.bak内容

STARTUP NOMOUNT
CREATE CONTROLFILE REUSE DATABASE "DEV" NORESETLOGS ARCHIVELOG
    MAXLOGFILES 255
    MAXLOGMEMBERS 3
    MAXDATAFILES 254
    MAXINSTANCES 50
    MAXLOGHISTORY 4041
LOGFILE
GROUP 1 (
    '/oracle/DEV/origlogA/log_g11m1.dbf',
    '/oracle/DEV/mirrlogA/log_g11m2.dbf'
) SIZE 50M BLOCKSIZE 512,
GROUP 2 (
    '/oracle/DEV/origlogB/log_g12m1.dbf',
    '/oracle/DEV/mirrlogB/log_g12m2.dbf'
) SIZE 50M BLOCKSIZE 512,
GROUP 3 (
    '/oracle/DEV/origlogA/log_g13m1.dbf',
    '/oracle/DEV/mirrlogA/log_g13m2.dbf'
) SIZE 50M BLOCKSIZE 512,
GROUP 4 (
    '/oracle/DEV/origlogB/log_g14m1.dbf',
    '/oracle/DEV/mirrlogB/log_g14m2.dbf'
) SIZE 50M BLOCKSIZE 512
-- STANDBY LOGFILE
DATAFILE
'/oracle/DEV/sapdata1/system_1/system.data1',
'/oracle/DEV/sapdata1/sysaux_1/sysaux.data1',
'/oracle/DEV/sapdata1/undo_1/undo.data1',
'/oracle/DEV/sapdata2/sr3_1/sr3.data1',
'/oracle/DEV/sapdata2/sr3_2/sr3.data2',
'/oracle/DEV/sapdata2/sr3_3/sr3.data3',
'/oracle/DEV/sapdata2/sr3_4/sr3.data4',
'/oracle/DEV/sapdata2/sr3_5/sr3.data5',
'/oracle/DEV/sapdata2/sr3_6/sr3.data6',
'/oracle/DEV/sapdata2/sr3_7/sr3.data7',
'/oracle/DEV/sapdata2/sr3_8/sr3.data8',
'/oracle/DEV/sapdata2/sr3_9/sr3.data9',
'/oracle/DEV/sapdata2/sr3_10/sr3.data10',
'/oracle/DEV/sapdata2/sr3_11/sr3.data11',
'/oracle/DEV/sapdata2/sr3_12/sr3.data12',
'/oracle/DEV/sapdata2/sr3_13/sr3.data13',
'/oracle/DEV/sapdata2/sr3_14/sr3.data14',
'/oracle/DEV/sapdata2/sr3_15/sr3.data15',
'/oracle/DEV/sapdata2/sr3_16/sr3.data16',
'/oracle/DEV/sapdata3/sr3702_1/sr3702.data1',
'/oracle/DEV/sapdata3/sr3702_2/sr3702.data2',
'/oracle/DEV/sapdata3/sr3702_3/sr3702.data3',
'/oracle/DEV/sapdata3/sr3702_4/sr3702.data4',
'/oracle/DEV/sapdata3/sr3702_5/sr3702.data5',
'/oracle/DEV/sapdata3/sr3702_6/sr3702.data6',
'/oracle/DEV/sapdata3/sr3702_7/sr3702.data7',
'/oracle/DEV/sapdata3/sr3702_8/sr3702.data8',
'/oracle/DEV/sapdata3/sr3702_9/sr3702.data9',
'/oracle/DEV/sapdata3/sr3702_10/sr3702.data10',
'/oracle/DEV/sapdata3/sr3702_11/sr3702.data11',
'/oracle/DEV/sapdata3/sr3702_12/sr3702.data12',
'/oracle/DEV/sapdata3/sr3702_13/sr3702.data13',
'/oracle/DEV/sapdata3/sr3702_14/sr3702.data14',
'/oracle/DEV/sapdata4/sr3usr_1/sr3usr.data1'
CHARACTER SET UTF8
;