deleted of control file how will u recover control file?

Question Posted / kittu_chintu2005

4 Answers
8699 Views
CTS, I also Faced
E-Mail Answers

Answers were Sorted based on User's Feedback

deleted of control file how will u recover control file?..

If RMAN backup exists
go to RMAN prompt
recover controlfile from backup controlfile
restore database from bckup
recover database

Is This Answer Correct ?

5 Yes

0 No

deleted of control file how will u recover control file?..

Answer / kittu_chintu2005

Method 1:
SQL>STARTUP NOMOUNT;
SQL>CREATE CONTROLFILE REUSE DATABASE "DB_NAME" ARCHIVELOG RESETLOGS
LOGFILE
GROUP 1 ( 'location of redo1a.log','location of redo1b.log') size XXmb,
GROUP 2 ( 'location of redo2a.log','location of redo2b.log') size xxmb
DATAFILE
'location of system.dbf',
'location of users.dbf',
'location of temp.dbf',
'location of ts1.dbf';
SQL>RECOVER DATABASE;
SQL>ALTER DATABASE OPEN RESETLOGS;

Is This Answer Correct ?

8 Yes

4 No

deleted of control file how will u recover control file?..

Answer / suman

we are restore the control file from cold/hot backup
after that
$sqlplus / 'as sysdba'
>startup nomount
>recover database using backup controlfile until cancel;
>alter database mount;
>alter database open resetlogs;

Is This Answer Correct ?

4 Yes

0 No

deleted of control file how will u recover control file?..

Answer / bolla

At o/s level we are restore control.file from cold/hot backup
after
]$sqlplus /'as sysdba'
sys>startup nomount
sys>recover database using backup controlfile until cancel;
sys>alter database mount;
sys>alter database open resetlogs;

Is This Answer Correct ?

3 Yes

1 No

Post New Answer

More DB Administration Interview Questions

suppose you want to audit specific activities on sensitive data. How can you achieve that?

0 Answers Oracle,

From the database level, how can you tell under which time zone a database is operating?

1 Answers

Define the SGA and: How you would configure SGA for a mid-sized OLTP environment? What is involved in tuning the SGA?

0 Answers

How can you control the amount of free space in your index pages? : sql server DBA

0 Answers

What are the operating modes in which database mirroring runs? : sql server DBA

0 Answers

how can you generate profile of pl/sql applications to identify performance bottlenecks?

0 Answers Oracle,

How can we know the exact updation date of a particular database?

2 Answers Satyam,

how can you initialize log miner?

0 Answers Oracle,

deleted of control file how will u recover control file?

4 Answers CTS,

What are statistics, under what circumstances they go out of date, how do you update them?

0 Answers

What is the difference between Datapump & export/import?

2 Answers

now one user in online.now i want drop him..how do u drop him?

4 Answers Wipro,

For more DB Administration Interview Questions Click Here