You have just had to restore from backup and do not have any
control files. How would you go about bringing up this database?
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
What the different components in replication and what is their use? : sql server DBA
A table is classified as a parent table and you want to drop and re-create it. How would you do this without affecting the children tables?
when does an alert gets signaled?
What is the difference between dropping a database and taking a database offline? : sql server DBA
What are the new features in sql server 2005 when compared to sql server 2000? : sql server DBA
how can you connect from 10g user to 11g user??
how can you create a user-defined lock?
What purpose does the model database server? : sql server DBA
What are the high-availability solutions in sql server and differentiate them briefly? : 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 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
i have 10gp file.now i need store in database..but database have only 7gb memory only..how do u store the file ?
what are the performance views in an oracle rac environment?
Define the SGA and: How you would configure SGA for a mid-sized OLTP environment? What is involved in tuning the SGA?
What authentication modes does sql server support? : sql server DBA