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
- 3194 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 a subquery in oracle?
Give the constructs of a package, function or a procedure.
What is save point in oracle database?
How does the on-delete-cascade statement work?
what is difference between sql plus and sql*plus? (not sql and sql plus).
Her departmandaki isçilerden empno' su ikinci sirada olan isçilerin empno, deptno, hiredate, sira_no bigilerini döndüren sorguyu yaziniz?
How to create lov dynamically at runtime & attach to text field?
Which dictionary tables and/or views would you look at to diagnose a locking issue?
How do I manually uninstall oracle client?
How to call a stored function with parameters?
What is a cursor in oracle?
What is a trace file and how is it created in oracle?
How do you bind variables in oracle?
What to do if dba lost the system password?
How to convert numbers to characters in oracle?
