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 / bharath
Perform below steps
1) alter database datafile < file_id> offline;
2) alter database create datafile <file_id>;
3) recover datafile <file_id>;
4) alter database datafile <file_id> online;
| Is This Answer Correct ? | 13 Yes | 0 No |
Post New Answer View All Answers
How do you troubleshoot errors in a sql server agent job? : sql server DBA
what is the last version,the release date of that version and fix pack of ibm db2 udb?
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.
What is dcl? : sql server DBA
How would you extract DDL of a table without using a GUI tool?
You create a private database link and upon
connection, fails with: ORA-2085: connects to
What happens on checkpoint? : sql server DBA
how can you connect from 10g user to 11g user??
how does an oracle clusterware manage crs resources?
What the different types of replication and why are they used? : sql server DBA
how can you schedule a job in database?
Query processing is slow(eg select query)how will u solve that
how can you enable flashback feature?
When setting replication, can you have distributor on sql server 2005, publisher on sql server 2008? : sql server DBA
What is the default fill factor value? : sql server DBA