How do you recover a datafile that has not been physically
been backed up since its creation and has been deleted.
Provide syntax example.
Answer Posted / shiva
>alter database create datafile < path>;
> alter database recover automatic datafile < path> /<file_id>
| Is This Answer Correct ? | 1 Yes | 0 No |
Post New Answer View All Answers
What is a system database and what is a user database? : sql server DBA
What is the cache hit ratio, what impact does it have on performance of an Oracle database and what is involved in tuning it?
What happens on checkpoint? : sql server DBA
Why does Oracle not permit the use of PCTUSED with indexes?
how can you schedule a job in database?
What are the different authentication modes in sql server and how can you change authentication mode? : sql server DBA
Typically, where is the conventional directory structure chosen for Oracle binaries to reside?
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 are the different types of indexes available in sql server? : sql server DBA
What are the differences in clustering in sql server 2005 and 2008 or 2008 r2? : sql server DBA
Where would you look for errors from the database engine?
Which autogrowth database setting is good? : sql server DBA
How do you troubleshoot errors in a sql server agent job? : sql server DBA
Define the SGA and: How you would configure SGA for a mid-sized OLTP environment? What is involved in tuning the SGA?
how can you initialize log miner?