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 are the diffeenes between oracle 9i,oracle 10g
What is an Oracle Instance?
1. How actually index will work ? 2. Why do people prefer mostly bitmap index and btree index in datawarehouse ? 3. If I use the column in aggrigate functions like max,min,count and avg and if I have a index created on that column, will it increases the performance ?
Is primary key indexed by default in oracle?
What are different Oracle database objects?
Explain the use of file option in exp command.
various types of hints and their usage
What are the attributes of the cursor?
Can the query output be sorted by multiple columns in oracle?
How will you write a query to get a 5th rank student from a table student_report?
What is an Oracle index?
what is the maximum number of indexes i can create for a table? What happens if i create indexes for all the columns of a table? Will it slow down the speed of retrieval