1. Categories >> Software >> Databases >> DB Administration
  2. Suggest New Category

deleted of control file how will u recover control file?

Question Posted / kittu_chintu2005

Answers were Sorted based on User's Feedback



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

Answer / raj

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 determine what sessions are connected and what resources they are waiting for?

2 Answers  

what is incremental checkpoint?

1 Answers   CTS,

What is the difference between a TEMPORARY tablespace and a PERMANENT tablespace?

2 Answers  

CTS int questions: 1.Temperory tablespace corrupted,how to resolve?If you need to recover? 2.In tablespace begin backup mode,Its possible to add the datafile? 3.How to partition the table using Hash partioning,what happened internally? 4.During rman backup,some files are missing Rman will continue the backup? 5.what are the errors occurs frequently? 6.which join method is best?why? 7.how to solve deadlock errors? please reply anyone.... regards siva

2 Answers   CTS,

How would you best determine why your MVIEW couldn't FAST REFRESH?

0 Answers  




What the different topologies in which replication can be configured? : sql server DBA

0 Answers  

if monday take full backup and tuesday it was cumulative backup and wednesday we taken incremental backup, thursday some disaster happen then what type of recovery and how it will take?

1 Answers  

How does Oracle guarantee data integrity of data changes?

1 Answers   SoftSol,

What is the difference between the 2 operating modes of database mirroring? : sql server DBA

0 Answers  

Explain about your sql server dba experience? : sql server DBA

0 Answers  

what is the role of dip user in our database?

0 Answers  

You have 4 instances running on the same UNIX box. How can you determine which shared memory and semaphores are associated with which instance?

0 Answers  

For more DB Administration Interview Questions Click Here
Categories