If you had a tablespace, test_tablespace, which consists of three files:test01.dbf, test02.dbf, and test03.dbf, and someone accidentally used the unix command"rm" to delete the file test02.dbf, what else would you need in order to recover all the data thatwas present in test_tablespace at the time that test02.dbf was deleted?
- 1 Answers
- 680 Views
- I also Faced
- E-Mail Answers
Answer / Imran Ahmad
To recover the lost data in test_tablespace when test02.dbf is accidentally deleted using 'rm', you would need a valid backup of the affected tablespace (test_tablespace) that was taken before test02.dbf was deleted.
| Is This Answer Correct ? | 0 Yes | 0 No |
The system has a program that always includes the word nocomp in its name, how can you determine the number of processes that are using this program?
When configuring sqlnet on the client what files need to be set up?
When looking at v$sysstat you see that sorts (disk) is high. Is this bad or good? If bad -how do you correct it?
What happens if the constraint name is left out of a constraint clause?
What is the finger command?
What do you understand by the term 'system change number (scn)'?
What is the difference between sga and pga?
How can you tell if an index on particular table is used or not used in 9i?
What does an oracle dba do?
Explain the wait events in statspack report 'db scattered read', 'db sequential real', 'enqueue'?
Discuss row chaining, how does it happen? How can you reduce it?
What are bind variables and why are they important?
Oracle General 
