IBM Control file Recreation Script

CREATE CONTROLFILE SET DATABASE "TST" RESETLOGS  ARCHIVELOG

    MAXLOGFILES 32

    MAXLOGMEMBERS 5

    MAXDATAFILES 512

    MAXINSTANCES 8

    MAXLOGHISTORY 20742

LOGFILE

  GROUP 1 (

    '/TESTDB/R12/db/apps_st/data/log01a.dbf',

    '/TESTDB/R12/db/apps_st/data/log01b.dbf'

  ) SIZE 1024M BLOCKSIZE 512,

  GROUP 2 (

    '/TESTDB/R12/db/apps_st/data/log02a.dbf',

    '/TESTDB/R12/db/apps_st/data/log02b.dbf'

  ) SIZE 1024M BLOCKSIZE 512

-- STANDBY LOGFILE

DATAFILE

  '/TESTDB/R12/db/apps_st/data/system01.dbf',

  '/TESTDB/R12/db/apps_st/data/system02.dbf',

  '/TESTDB/R12/db/apps_st/data/system03.dbf',

  '/TESTDB/R12/db/apps_st/data/system04.dbf',

  '/TESTDB/R12/db/apps_st/data/system05.dbf',

  '/TESTDB/R12/db/apps_st/data/system06.dbf',

  '/TESTDB/R12/db/apps_st/data/system07.dbf',

  '/TESTDB/R12/db/apps_st/data/system08.dbf',

  '/TESTDB/R12/db/apps_st/data/system09.dbf',

  '/TESTDB/R12/db/apps_st/data/system10.dbf',

  '/TESTDB/R12/db/apps_st/data/system11.dbf',

  '/TESTDB/R12/db/apps_st/data/undo01.dbf',

  '/TESTDB/R12/db/apps_st/data/a_archive01.dbf',

  '/TESTDB/R12/db/apps_st/data/a_int01.dbf',

  '/TESTDB/R12/db/apps_st/data/a_media01.dbf',

  '/TESTDB/R12/db/apps_st/data/a_nolog01.dbf',

  '/TESTDB/R12/db/apps_st/data/a_queue01.dbf',

  '/TESTDB/R12/db/apps_st/data/a_queue02.dbf',

  '/TESTDB/R12/db/apps_st/data/a_ref01.dbf',

  '/TESTDB/R12/db/apps_st/data/a_ref02.dbf',

  '/TESTDB/R12/db/apps_st/data/a_summ01.dbf',

  '/TESTDB/R12/db/apps_st/data/a_txn_data01.dbf',

  '/TESTDB/R12/db/apps_st/data/a_txn_data02.dbf',

  '/TESTDB/R12/db/apps_st/data/a_txn_data03.dbf',

  '/TESTDB/R12/db/apps_st/data/a_txn_ind01.dbf',

  '/TESTDB/R12/db/apps_st/data/a_txn_ind02.dbf',

  '/TESTDB/R12/db/apps_st/data/a_txn_ind03.dbf',

  '/TESTDB/R12/db/apps_st/data/a_txn_ind04.dbf',

  '/TESTDB/R12/db/apps_st/data/a_txn_ind05.dbf',

  '/TESTDB/R12/db/apps_st/data/ctxd01.dbf',

  '/TESTDB/R12/db/apps_st/data/odm.dbf',

  '/TESTDB/R12/db/apps_st/data/olap.dbf',

  '/TESTDB/R12/db/apps_st/data/owad01.dbf',

  '/TESTDB/R12/db/apps_st/data/portal01.dbf',

  '/TESTDB/R12/db/apps_st/data/sysaux01.dbf',

  '/TESTDB/R12/db/apps_st/data/apps_ts_tools01.dbf',

  '/TESTDB/R12/db/apps_st/data/a_txn_data4.dbf',

  '/TESTDB/R12/db/apps_st/data/a_txn_data5.dbf',

  '/TESTDB/R12/db/apps_st/data/a_txn_data6.dbf',

  '/TESTDB/R12/db/apps_st/data/XXICAR01.dbf'

CHARACTER SET AL32UTF8

;