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
- 3218 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 redo log?
How to start your 10g xe server from command line?
What is difference between sid and service name in oracle?
how to handle exceptions in post production
How to get a create statement for an existing table?
How to define an explicit cursor in oracle?
How to add a new column to an existing table in oracle?
What is the difference between postgresql and oracle?
How do we represent comments in oracle?
How to pass parameters to procedures?
What happens to the data files if a tablespace is dropped?
How to run create database statement?
Describe an oracle table?
How can we force the database to use the user specified rollback segment?
What query tells you how much space a tablespace named test is taking up, and how much space is remaining?
