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!

Interested in getting your voice heard by members of the Developer Marketing team at Oracle? Check out this post for AppDev or this post for AI focus group information.

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

2,993 views