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 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 concurrency in oracle?
What is hot backup and logical backup?
Explain the use of rows option in imp command.
What is analyze command used for?
What types of joins are used in writing subqueries?
How to drop an existing table in oracle?
What is user managed backup in Oracle?
What is using clause and give example?
what is insert all statement in sql
What are the execution control statements in oracle?
What is the difference between formal parameters and actual parameters?
Why cursor variables are easier to use than cursors?
What is where clause in oracle?
Please explain me all types of Data models. Also give me the details if each model can have other name.for example:schematic data model is also known as conceptual data model and entity relation data model.
How to drop an index?