How do you recover a datafile that has not been physically
been backed up since its creation and has been deleted.
Provide syntax example.
- 4 Answers
- 8314 Views
- I also Faced
- E-Mail Answers
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
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 database compression introduced in sql server 2008? : sql server DBA
You have found corruption in a tablespace that contains static tables that are part of a database that is in NOARCHIVE log mode. How would you restore the tablespace without losing new data in the other tablespaces?
What is transparent data encryption? : sql server DBA
How would you extract DDL of a table without using a GUI tool?
i have 10gp file.now i need store in database..but database have only 7gb memory only..how do u store the file ?
what is ora 24313?what is the procedure to exclude that error?
Other than making use of the statspack utility, what would you check when you are monitoring or running a health check on an Oracle 8i or 9i database?
how can you record information about current session?
what is the role of dip user in our database?
How to craeate the New Database Schema in Oracle and mysql? Please tell me with Example?
Explain the difference between a FUNCTION, PROCEDURE and PACKAGE.
What are the different ways you can create databases in sql server? : sql server DBA
What is the importance of a recovery model? : sql server DBA
when does an alert gets signaled?
