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
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 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
How to craeate the New Database Schema in Oracle and mysql? Please tell me with Example?
What the different types of replication and why are they used? : sql server DBA
how to restore files with rman?
What are the commands used in dcl? : sql server DBA
Query processing is slow(eg select query)how will u solve that
how can a session indicate its interest in receiving alerts?
Which autogrowth database setting is good? : sql server DBA
what is the use of recording information about current session?
how can you initialize log miner?
how do we explain a project in cognos in an interview? please help me. Also how do we perform testing in cognos after creating reports?
what functionality does oracle provide to secure sensitive information?
What are the different authentication modes in sql server and how can you change authentication mode? : sql server DBA
how can you find out if a table can be redefined?