Oracle Database Discussions

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Problem Creating a control file

jonhwellSep 9 2014 — edited Sep 10 2014

CREATE CONTROLFILE REUSE DATABASE "DSV" RESETLOGS ARCHIVELOG

MAXLOGFILES 16

MAXLOGMEMBERS 3

MAXDATAFILES 100

MAXINSTANCES 8

MAXLOGHISTORY 292

LOGFILE

GROUP 1 (

'D:\ORACLE\ORADATA\DSV\REDO01.LOG',

'D:\ORACLE\ORADATA\DSV\REDO01A.LOG'

) SIZE 2048M BLOCKSIZE 512,

GROUP 2 (

'D:\oracle\oradata\DSV\redo02.log',

'D:\oracle\oradata\DSV\redo02a.log'

) SIZE 2048M BLOCKSIZE 512,

GROUP 3 (

'D:\oracle\oradata\DSV\redo03.log',

'D:\oracle\oradata\DSV\redo03a.log'

) SIZE 2048M BLOCKSIZE 512,

GROUP 4 (

'D:\oracle\oradata\DSV\redo04.log',

'D:\oracle\oradata\DSV\redo04a.log'

) SIZE 2048M BLOCKSIZE 512

-- STANDBY LOGFILE

DATAFILE

'D:\oracle\oradata\DSV\datafile\system.dbf',

'D:\oracle\oradata\DSV\datafile\sysaux.dbf',

'D:\oracle\oradata\DSV\datafile\fusion_undots.dbf',

'D:\oracle\oradata\DSV\datafile\fusion_ts_tx_data01.dbf',

'D:\oracle\oradata\DSV\datafile\fusion_ts_tx_data02.dbf',

'D:\oracle\oradata\DSV\datafile\fusion_ts_tx_data03.dbf',

'D:\oracle\oradata\DSV\datafile\fusion_ts_tx_data04.dbf',

'D:\oracle\oradata\DSV\datafile\fusion_ts_tx_data05.dbf',

'D:\oracle\oradata\DSV\datafile\fusion_ts_tx_data06.dbf',

'D:\oracle\oradata\DSV\datafile\fusion_ts_tx_data07.dbf',

'D:\oracle\oradata\DSV\datafile\fusion_ts_tx_data08.dbf',

'D:\oracle\oradata\DSV\datafile\fusion_ts_tx_data09.dbf',

'D:\oracle\oradata\DSV\datafile\fusion_ts_tx_data10.dbf',

'D:\oracle\oradata\DSV\datafile\fusion_ts_tx_idx01.dbf',

'D:\oracle\oradata\DSV\datafile\fusion_ts_tx_idx02.dbf',

'D:\oracle\oradata\DSV\datafile\fusion_ts_tx_idx03.dbf',

'D:\oracle\oradata\DSV\datafile\fusion_ts_tools.dbf',

'D:\oracle\oradata\DSV\datafile\search_index.dbf',

'D:\oracle\oradata\DSV\datafile\fusion_ias_orasdpm_aq.dbf',

'D:\oracle\oradata\DSV\datafile\fusion_ts_archive.dbf',

'D:\oracle\oradata\DSV\datafile\fusion_ts_dq.dbf',

'D:\oracle\oradata\DSV\datafile\fusion_ts_interface.dbf',

'D:\oracle\oradata\DSV\datafile\fusion_ts_nologging.dbf',

'D:\oracle\oradata\DSV\datafile\biacmts.dbf',

'D:\oracle\oradata\DSV\datafile\fusion_ts_seed.dbf',

'D:\oracle\oradata\DSV\datafile\fusion_dyn_ts.dbf',

'D:\oracle\oradata\DSV\datafile\fusion_ts_queues.dbf',

'D:\oracle\oradata\DSV\datafile\fusion_ts_aq.dbf',

'D:\oracle\oradata\DSV\datafile\search_data.dbf',

'D:\oracle\oradata\DSV\datafile\fusion_ts_media.dbf',

'D:\oracle\oradata\DSV\datafile\fusion_ts_summary.dbf'

CHARACTER SET AL32UTF8

;

ERROR at line 11:

ORA-01967: invalid option for CREATE CONTROLFILE

What is this problem???

Thanks.

Locked Post

New comments cannot be posted to this locked post.

Locked on Oct 8 2014

Added on Sep 9 2014

#general-database-discussions

9 comments

1,765 views