adspace


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

deleted of control file how will u recover control file?

Question Posted / kittu_chintu2005

Answer Posted / 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



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

what is the last version,the release date of that version and fix pack of ibm db2 udb?

2059

Does any body has ORACLE Certification Dumps or Materials on 9i DBA, 10G DBA, Internet Application Developer, OCP 8i to 10g DBA Upgrade, Oracle 11i if any body have it, please kindly drop an email to: taruni_2k8@yahoo.com

2187

Can you tell me about your experience with the administration of COTS system..? Also, how do you set up seed data..?

2718