How do you recover a datafile that has not been physically
been backed up since its creation and has been deleted.
Provide syntax example.
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 |
What is the effect of setting the value of OPTIMIZER_MODE to 'RULE' ?
How can we create the complete backup of data in the oracle.
1 Answers IPEC, Satyam, SunTec,
How to bring a tablespace online?
Explain the types of exception?
what are corelated subqueries
Can select statements be used on views in oracle?
How to bring a tablespace offline?
what is the scripts in data base?
What is a table in oracle?
Differnce between view and index
Without giving condition how to retrieve the unmatched records from table.
what is the exact diiference between DBMS and RDBMS