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
- 10921 Views
- I also Faced
- E-Mail Answers
Answer Posted / y. naresh kumar
SQL> RECOVER DATABASE USING BACKUP CONTROLFILE:
| Is This Answer Correct ? | 12 Yes | 6 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.
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
What types of replication are supported in sql server? : sql server DBA
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 do you troubleshoot errors in a sql server agent job? : sql server DBA
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.
Which autogrowth database setting is good? : sql server DBA
How would you best determine why your MVIEW couldn't FAST REFRESH?
What is the default port no on which sql server listens? : sql server DBA
what is the use of ocr?
what do you understand by flashback feature of oracle?
What authentication modes does sql server support? : sql server DBA
What are the commands you'd issue to show the explain plan for "select * from dual"?
Illustrate how to determine the amount of physical CPUs a Unix Box possesses (LINUX and/or Solaris).
You have 4 instances running on the same UNIX box. How can you determine which shared memory and semaphores are associated with which instance?
