deleted of control file how will u recover control file?
- 4 Answers
- 7633 Views
- CTS, I also Faced
- E-Mail Answers
Answer Posted / 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 |
Post New Answer View All Answers
how can you communicate with operating system files from oracle?
Explain the difference between a FUNCTION, PROCEDURE and PACKAGE.
Explain about your sql server dba experience? : sql server DBA
What would you do with an "in-doubt" distributed transaction?
Illustrate how to determine the amount of physical CPUs a Unix Box possesses (LINUX and/or Solaris).
What are the recovery models for a database? : sql server DBA
can u plz tell me what r the mandatory skills for getting job as a sql dba......plz send me all details thank you my id :k.mohann.mohan@gmail.com
how can you implement fine-grained auditing?
In what script is "snap$" created? In what script is the "scott/tiger" schema created?
what is asm?
How do you open a cluster administrator? : sql server DBA
what are the benefits of flashback feature?
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 many files can a database contain in sql server?how many types of data files exists in sql server? How many of those files can exist for a single database? : sql server DBA
when does an alert gets signaled?
