I lost one datafile i dont have backup how can you recover that???
Answer Posted / mohapatra.gouranga@gmail.com
Recovery is not possible if no backup.
But inconsistent recovery is possible by 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 ? | 3 Yes | 0 No |
Post New Answer View All Answers
What purpose does the model database server? : sql server DBA
who owns the operating system files created by the utl_file package?
how can you schedule a job in database?
How do you open a cluster administrator? : sql server DBA
What is the difference between clustered and non-clustered index? : sql server DBA
How would you best determine why your MVIEW couldn't FAST REFRESH?
What are the different types of database compression introduced in sql server 2008? : sql server DBA
Draft one mock email requesting your non-technical management grant you downtime to (provide justification where applicable) complete the following tasks: (1) Generate statistics on a large table; (2) Generate an RDA – if you don't know what an RDA is please say so. (3) Rename datafiles.
suppose you want to audit specific activities on sensitive data. How can you achieve that?
Can you tell me about your experience with the administration of COTS system..? Also, how do you set up seed data..?
what is a crs resource?
i have 10gp file.now i need store in database..but database have only 7gb memory only..how do u store the file ?
Does transparent data encryption provide encryption when transmitting data across network? : sql server DBA
Why would you use sql agent? : sql server DBA
Which dictionary view(s) would you first look at to understand or get a high-level idea of a given Advanced Replication environment?