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
- 2507 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 |
master table and child table performances and comparisons in Oracle ?
How to start instance with a minimal initialization parameter file?
Describe Referential Integrity ?
Which environment variables are absolutely critical in order to run the OUI?
Explain integrity constraints?
I know that i can create a table without a primary key.But is there any significance for that table???? while creating an application.
what are the mandortary parameters required for cuncurrent program definition in oracle apps R12?
can we pass two out parameters at a time in function?please answer to my question
What is meant by a deadlock situation?
List out the types of joins.
How to rename an index in oracle?
What is the difference between 10g OEM and 11g OEM?
Oracle General 
