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
- 6193 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
What are the different types of upgrades that can be performed in sql server? : sql server DBA
Explain about your sql server dba experience? : sql server DBA
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.
How does propagation differ between Advanced Replication and Snapshot Replication (read-only)?
what are the performance views in an oracle rac environment?
What is the difference between dropping a database and taking a database offline? : sql server DBA
what are the types of connection load-balancing?
currently iam working in mnc as a oracleappsdba,please send the EXPERIENCE RESUME those who r worked as a oracle apps dba
how can you communicate with operating system files from oracle?
You create a private database link and upon
connection, fails with: ORA-2085: connects to
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.
how can a session indicate its interest in receiving alerts?
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 are the steps you will take to improve performance of a poor performing query?
what functionality does oracle provide to secure sensitive information?
