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
- 3223 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 do you find out from the RMAN catalog if a particular archive log has been backed-up?
Where is the export dump file located?
what are the mandortary parameters required for cuncurrent program definition in oracle apps R12?
How to define a variable of a specific record type?
Q) How to Find Max Date from each Group? (Asked in Infosys (INFI)Interview)
How to use an explicit cursor without open statements?
Can group functions be used in the order by clause in oracle?
We have one Package(which has many function/procedures, SQL quires etc). Now we need to check, which query or procedure is taking lot of time in that Package. ? How do we do it.
How to run the anonymous block again?
What are oracle functions?
How to assign a table row to a record variable?
What is key preserved table?
Oracle General 
