I lost one datafile i dont have backup how can you recover that???
Answer Posted / mohapatra.gouranga@gmail.com
Recovery is not possible if no backup.
But inconsistent recovery is possible by following method:
1.shutdown your database
2.take the database in mount state
3. Make the tablespace of lost datafile to off line.
4.alter database create datafile 'old_datafile_path'
as 'new_datafile_path';
5. Made the database online.
6.once new file created do the incomplete recovery. from
any old backup.
7. open the database with resetlogs.
| Is This Answer Correct ? | 3 Yes | 0 No |
Post New Answer View All Answers
Which dictionary view(s) would you first look at to understand or get a high-level idea of a given Advanced Replication environment?
what are the benefits of flashback feature?
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 types of connection load-balancing?
What are the different types of indexes available in sql server? : sql server DBA
suppose you want to audit specific activities on sensitive data. How can you achieve that?
What is the default port no on which sql server listens? : sql server DBA
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 are the steps you will take to improve performance of a poor performing query?
how can you process messages in order asynchronously?
Explain about your sql server dba experience? : sql server DBA
What authentication modes does sql server support? : sql server DBA
how does an oracle clusterware manage crs resources?
List out some of the requirements to setup a sql server failover cluster.? : 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?