Interested to Buy Any Domain ? << Click Here >> for more details...
You have just had to restore from backup and do not have any
control files. How would you go about bringing up this database?
- 3 Answers
- 11440 Views
- I also Faced
- E-Mail Answers
Answer Posted / ramesh chowdary
I would create a text based backup control file,
stipulating where on disk all the data files where and then
issue the recover command with the using backup control
file clause.
| Is This Answer Correct ? | 7 Yes | 0 No |
Post New Answer View All Answers
Database is hung. Old and new user connections alike hang on impact. What do you do? Your SYS SQLPLUS session IS able to connect.
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
what is a user-defined lock?
What is a system database and what is a user database? : sql server DBA
What are the different sql server versions you have worked on? : sql server DBA
How does propagation differ between Advanced Replication and Snapshot Replication (read-only)?
What are the different types of database compression introduced in sql server 2008? : sql server DBA
Database crashes. Corruption is found scattered among the file system neither of your doing nor of Oracle's. What database recovery options are available? Database is in archive log mode.
Why would you call update statistics? : sql server DBA
What are the different types of indexes available in sql server? : sql server DBA
You create a private database link and upon
connection, fails with: ORA-2085: connects to
internal architecture
What is dbcc? : sql server DBA
what are the types of connection load-balancing?
Provide an example of a shell script which logs into SQLPLUS as SYS, determines the current date, changes the date format to include minutes & seconds, issues a drop table command, displays the date again, and finally exits.
