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
- 3155 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 would you go about verifying the network name that the local_listener is currently using?
various types of hints and their usage
How to drop a stored procedure in oracle?
What is clustered table in Oracle?
How to make a Data Backup in oracle ? What is the procedure for creating the dump files in oracle ( any version ) ?
Where are the settings stored for each instance in oracle?
Explain the use of record option in exp command.
how to store only time in a data base table
How can you Enforce Referential Integrity in snapshots ?
What does COMMIT do ?
What is blob data type in oracle?
What is an oracle user role?
Oracle General 
