| Block recovery using logical backup [message #325853] |
Mon, 09 June 2008 04:18  |
srini_thiru
Messages: 133
Registered: May 2008
|
Senior Member |
|
|
Hi to all,
We are using oracle 9i database. last night One data file got corrupted. When I look into the v$database_block_corruption, I found that 5 blocks are corrupted. And there is no backup of data file. We have only logical backup that too taken after the block corruption. Any other options available to bring the data file to normal mode..
This is the sample output of v$database_block_corruption
FILE# BLOCK# BLOCKS CORRUPTION_CHANGE# CORRUPTION_TYPE
19 494215 1 0 FRACTURED
Like this there are four more blocks corrupted
our database is running in archive log mode. how can i recover the datafile. How to view which archive file belongs to which datafile.
thanks in advance,
Seenu
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
| To drop corrupted datafile [message #326100 is a reply to message #325853] |
Tue, 10 June 2008 03:43  |
srini_thiru
Messages: 133
Registered: May 2008
|
Senior Member |
|
|
Hi,
One of my database datafile got corrupted. I don't have a backup of the datafile.
When i try to open the database i can't open because of that corrupted datafile. i like to drop the datafile but when i try to drop it the response i got is database not open. Presently the database is in MOUNT STATE.
How can i make my database open...
|
|
|
|
|
|
| Re: To drop corrupted datafile [message #326187 is a reply to message #326100] |
Tue, 10 June 2008 09:18 |
varu123
Messages: 754
Registered: October 2007
|
Senior Member |
|
|
To drop the tablespace you need to open the database.
Follow simple steps;
1)startup mount
2)alter database datafile <locationofdatafile> offline drop;
3)alter database open;
4)drop tablespace <tablespace_name> including contents and datafiles;
5)Recreate the tablespace
6)backup database
Thats it I suppose.
|
|
|
|
| importing tables [message #326196 is a reply to message #325853] |
Tue, 10 June 2008 10:20 |
srini_thiru
Messages: 133
Registered: May 2008
|
Senior Member |
|
|
HI,
I am using oracle 10g release 2 version. In one of my datafile 3 blocks are corrupted. I have a logical backup of the database. there are 15 tables in that corrupted datafile.
if i drop these tables and recreate using logical backup whether the blocks will be recovered or not.
or else can i rename the tables and import the particular table from logical backup..
Thanks in Advance,
Seenu
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
