How do you recover a datafile that has not been physically
been backed up since its creation and has been deleted.
Provide syntax example.
- 4 Answers
- 8292 Views
- I also Faced
- E-Mail Answers
Answer Posted / bharath
Perform below steps
1) alter database datafile < file_id> offline;
2) alter database create datafile <file_id>;
3) recover datafile <file_id>;
4) alter database datafile <file_id> online;
| Is This Answer Correct ? | 13 Yes | 0 No |
Post New Answer View All Answers
Provide an example of a shell script which logs into SQLPLUS as SYS, determines the current date, changes the date format to include minutes & seconds, issues a drop table command, displays the date again, and finally exits.
I have kept recovery catalog on same target database and taken backup of target DB to disk. deleted the target DB & tried to restore and revoer DB using the backup on disk but it is not possible, how do we restore & recover DB
Can you tell me about your experience with the administration of COTS system..? Also, how do you set up seed data..?
I got an error SQL1042C. An unexpected system error occurred. Explanation: A system error occurred. One possible reason for this error is that the database manager is not installed correctly or the environment is not set up correctly. On OS/2, while trying to start the database manager, a very common reason for this error is a corrupted NET.ACC file. The command cannot be processed. The tables and views would not be opened. What is the way to open the dataase? pls help me
How can you control the amount of free space in your index pages? : sql server DBA
What spfile/init.ora file parameter exists to force the CBO to make the execution path of a given statement use an index, even if the index scan may appear to be calculated as more costly?
what is the last version,the release date of that version and fix pack of ibm db2 udb?
i have 10gp file.now i need store in database..but database have only 7gb memory only..how do u store the file ?
What is the difference between the 2 operating modes of database mirroring? : sql server DBA
Assuming today is Monday, how would you use the DBMS_JOB package to schedule the execution of a given procedure owned by SCOTT to start Wednesday at 9AM and to run subsequently every other day at 2AM.
What is transparent data encryption? : sql server DBA
how can you get actual data change values from previous transactions in oracle?
what do you understand by flashback feature of oracle?
When setting replication, can you have distributor on sql server 2005, publisher on sql server 2008? : sql server DBA
What happens on checkpoint? : sql server DBA
