deleted of control file how will u recover control file?
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
Draft one mock email requesting your non-technical management grant you downtime to (provide justification where applicable) complete the following tasks: (1) Generate statistics on a large table; (2) Generate an RDA – if you don't know what an RDA is please say so. (3) Rename datafiles.
how can you find out if a table can be redefined?
What are statistics, under what circumstances they go out of date, how do you update them?
What authentication modes does sql server support? : sql server DBA
What are the new features in sql server 2005 when compared to sql server 2000? : sql server DBA
How does propagation differ between Advanced Replication and Snapshot Replication (read-only)?
What the different topologies in which replication can be configured? : sql server DBA
What is the importance of a recovery model? : sql server DBA
What purpose does the model database server? : sql server DBA
what is the last version,the release date of that version and fix pack of ibm db2 udb?
Claims and Drains are the locks used to control the concurrency between SQL processes and utilities. Referring to the above statement, what is the maximum number of concurrent Claimers for a Subsystem? Choice 1 32 Choice 2 64 Choice 3 128 Choice 4 256 Choice 5 No limit
How can you control the amount of free space in your index pages? : sql server DBA
What is transparent data encryption? : sql server DBA
what is the use of ocr?
Explain about your sql server dba experience? : sql server DBA