deleted of control file how will u recover control file?

Question Posted / kittu_chintu2005

4 Answers
8690 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

How would you edit your CRONTAB to schedule the running of /test/test.sh to run every other day at 2PM?

1 Answers

what are the differences of where and if in SAS?

0 Answers

Q. How to set ORACLE_HOME to my oracle software directory. Hi Friend I am installing oracle 10g Express Edition on Linux Fedora Core 6. Installation is success but when i run #sqlplus I getting command not found error. Then I have search sqlplus .i.e # find / -name sqlplus /usr/lib/oracle/xe/app/oracle/product/10.2.0/server/bin/sqlplus /usr/lib/oracle/xe/app/oracle/product/10.2.0/server/sqlplus These above output from find i have doubt which is correct path of sqlplus. So doubtfully i have set path 1st one.i.e # PATH=$PATH:/usr/lib/oracle/xe/app/oracle/product/10.2.0/server/bin Then I have run #sqlplus but still i have problem following Error 6 initializing SQL*Plus Message file sp1<lang>.msb not found SP2-0750: You may need to set ORACLE_HOME to your Oracle software directory How overcome this please answer m???

1 Answers

what is the use of ocr?

0 Answers Oracle,

What is the dataguard background process??

1 Answers iGate,

How would you go about verifying the network name that the local_listener is currently using?

0 Answers

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

0 Answers

I have A,B,C servers.i want to 3 servers jobs move to D server(target server)..how? note: i said that take the backup of msdb and restore to the target server..he said while restoring jobs replaced. what is the solution

0 Answers

when does an alert gets signaled?

0 Answers Oracle,

Why would you call update statistics? : sql server DBA

0 Answers

How to craeate the New Database Schema in Oracle and mysql? Please tell me with Example?

0 Answers

what functionality does oracle provide to secure sensitive information?

0 Answers Oracle,

For more DB Administration Interview Questions Click Here