Interested to Buy Any Domain ? << Click Here >> for more details...
I lost one datafile i dont have backup how can you recover that???
- 2 Answers
- 6117 Views
- HP, I also Faced
- E-Mail Answers
Answer Posted / mohapatra.gouranga@gmail.com
Recovery is imposible if no recent backup available with
archive logs. But inconsistent recovery is possible if any
old backup pieace available. Can be followed following
method.
1.shutdown your database
2.take the database in mount state
3. Make the tablespace of lost datafile to off line.
4.alter database create datafile 'old_datafile_path'
as 'new_datafile_path';
5. Made the database online.
6.once new file created do the incomplete recovery. from
any old backup.
7. open the database with resetlogs.
| Is This Answer Correct ? | 0 Yes | 0 No |
Post New Answer View All Answers
can u plz tell me what r the mandatory skills for getting job as a sql dba......plz send me all details thank you my id :k.mohann.mohan@gmail.com
What is the default fill factor value? : sql server DBA
What do the 9i dbms_standard.sql_txt() and dbms_standard.sql_text() procedures do?
What is a correlated sub-query? : sql server DBA
Why would you use sql agent? : sql server DBA
what is the role of dip user in our database?
Database crashes. Corruption is found scattered among the file system neither of your doing nor of Oracle's. What database recovery options are available? Database is in archive log mode.
Database is hung. Old and new user connections alike hang on impact. What do you do? Your SYS SQLPLUS session IS able to connect.
Query processing is slow(eg select query)how will u solve that
how can you connect from 10g user to 11g user??
currently iam working in mnc as a oracleappsdba,please send the EXPERIENCE RESUME those who r worked as a oracle apps dba
What is the difference between dropping a database and taking a database offline? : sql server DBA
Illustrate how to determine the amount of physical CPUs a Unix Box possesses (LINUX and/or Solaris).
Define the SGA and: How you would configure SGA for a mid-sized OLTP environment? What is involved in tuning the SGA?
How would you go about verifying the network name that the local_listener is currently using?
