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!

Recreate control file in case its lost?

Beauty_and_dBestAug 7 2017 — edited Aug 9 2017

Hi ALL,

11gR1, 11gR2

OL6

I want to test creating controlfile, in case it is deleted accidentally.

So I alter database backup controlfile to trace.

Then I will run the script inside this trace file which is below:

STARTUP NOMOUNT

CREATE CONTROLFILE REUSE DATABASE "R1213" NORESETLOGS NOARCHIVELOG

MAXLOGFILES 32

MAXLOGMEMBERS 5

MAXDATAFILES 512

MAXINSTANCES 8

MAXLOGHISTORY 1168

LOGFILE

GROUP 1 '/u02/orar1213/R1213/db/apps_st/data/log3.dbf' SIZE 300M,

GROUP 2 '/u02/orar1213/R1213/db/apps_st/data/log2.dbf' SIZE 300M,

GROUP 3 '/u02/orar1213/R1213/db/apps_st/data/log1.dbf' SIZE 300M

-- STANDBY LOGFILE

DATAFILE

'/u02/orar1213/R1213/db/apps_st/data/sys1.dbf',

'/u02/orar1213/R1213/db/apps_st/data/tx_data11.dbf',

'/u02/orar1213/R1213/db/apps_st/data/tx_idx11.dbf',

'/u02/orar1213/R1213/db/apps_st/data/undotbs_01.dbf',

'/u02/orar1213/R1213/db/apps_st/data/nologging3.dbf',

'/u02/orar1213/R1213/db/apps_st/data/ctx1.dbf',

'/u02/orar1213/R1213/db/apps_st/data/reference3.dbf',

'/u02/orar1213/R1213/db/apps_st/data/dw_reference_tbs.dbf',

'/u02/orar1213/R1213/db/apps_st/data/dw_reference_idx.dbf'

CHARACTER SET AL32UTF8;

My question is, the controlfile name is not specified, what is the name it will create?

Kind regards,

This post has been answered by Oratig-Oracle on Aug 7 2017

Jump to Answer

Locked Post

New comments cannot be posted to this locked post.

Locked on Sep 6 2017

Added on Aug 7 2017

#general-database-discussions

9 comments

3,126 views