Interested to Buy Any Domain ? << Click Here >> for more details...
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
- 3123 Views
- I also Faced
- E-Mail Answers
Answer Posted / 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 |
Post New Answer View All Answers
What is meant by raw datatype?
how to use select statement as formal parameter in procedure specification?(someone said that using string) ex:-procedure(a in number,select ename from emp ) i am asking syntax like this?
What is a static data dictionary in oracle?
Explain an exception?
Explain the use of indexes option in exp command.
types of indexes and the rationale behind choosing a particular index for a situation.
What is Segment Advisor in Oracle?
 What are the oracle DML commands possible through an update strategy?
How to retrieve the count of updated rows?
How to assign values to variables?
How do I connect to oracle database?
What is Data Dictionary Cache in Oracle?
How to convert raw data type into text in oracle? Explain
What are the data types in oracle?
Explain the use of online redo log files in oracle.
