How do you recover a datafile that has not been physically
been backed up since its creation and has been deleted.
Provide syntax example.
- 1 Answers
- 2516 Views
- I also Faced
- E-Mail Answers
Answer / vineet tyagi
Without Backup Of the Datafile(Excepts System/Active Undo Datafiles)
First Of All,We will take the particular datafile offline.
After that we will create same datafile with same location or another location.Then recover the datafile and online datafile.
Steps:--
1)Alter database datafile <name> offline; (Excepts System/Active undo tablespace related files)
2)Shutdown immediate/abort
3)Startup monut
4)Alter database create datafile <name> With same locatioin and same size; Or
Alter databse create datafile <name> old location to <name> new location with same size;
5)recover database/recover datafile <name>;
6)alter database open
7)alter database datafile online;
| Is This Answer Correct ? | 0 Yes | 0 No |
How to export several tables together?
Define oracle database
How to declare a local variable?
How to find the duplicate rows count from employees table in oracle?
How to run create database statement?
What is an Index ?
List out the difference between commit, rollback, and savepoint?
How to lock and unlock a user account in oracle?
What are the different approaches used by Optimizer in choosing an execution plan ?
Difference between open_form and call_form in oracle.
In oracle there is column command, how will you explain that?
query to find the maximum no persons with same age(age colomn) from emp table
Oracle General 
