I lost one datafile i dont have backup how can you recover that???
Answer Posted / mohapatra.gouranga@gmail.com
Recovery is imposible if no recent backup available with
archive logs. But inconsistent recovery is possible if any
old backup pieace available. Can be followed 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 ? | 0 Yes | 0 No |
Post New Answer View All Answers
How do you trace the traffic hitting a sql server? : sql server DBA
Typically, where is the conventional directory structure chosen for Oracle binaries to reside?
how can you communicate with operating system files from oracle?
what is the use of recording information about current session?
what is logical system in sap basis
what is the use of ocr?
Where would you look for errors from the database engine?
how can you generate profile of pl/sql applications to identify performance bottlenecks?
What view(s) do you use to associate a user's SQLPLUS session with his o/s process?
How can you tell how much space is left on a given file system and how much space each of the file system's subdirectories take-up?
How would you extract DDL of a table without using a GUI tool?
What is the difference between dropping a database and taking a database offline? : sql server DBA
what are the performance views in an oracle rac environment?
What types of replication are supported in sql server? : sql server DBA
What are the operating modes in which database mirroring runs? : sql server DBA