554 reputation
1925
bio website dba010.wordpress.com
location Tbilisi, Georgia
age 23
visits member for 3 years
seen Jun 17 at 8:00

I am 11g OCP and I work as a Senior DBA at Ministry of Justice of Georgia.


Dec
27
comment Drop table without its dependencies and solve block corruption
you are great! but I will check your solution now... but a little thing I did not understand. While I dropped the table containing corrupted block, and then recreated it with the same parameters the error still raised during the creation, according your reply during the re-creation the table the corrupted block should have been re-initialized and corrected, why not happened so?.(I did it before I read you post, will try now and write what happens)
Dec
24
awarded  Popular Question
Dec
21
comment Drop table without its dependencies and solve block corruption
@MindaugasRiauba you are right, after dropping a table corrupted blocks are still corrupted. I've read somewhere on the internet that after dropping a segment containing the corrupted block solves the corruption but it is not in 10g Oracle as I see. If I don't have backup how can I solve this problem? Can I move segments from this datafile to another one and drop this datafile after that?
Dec
20
comment Drop table without its dependencies and solve block corruption
I've tested now and if you drop all constraints, then drop table .. child records remain itself :)
Dec
20
asked Drop table without its dependencies and solve block corruption
Dec
9
revised Oracle 11g database structural change doesn't autobackup controlfile/spfile
changed format and added a clear explanation.
Dec
9
accepted Oracle 11g database structural change doesn't autobackup controlfile/spfile
Dec
6
comment Oracle 11g database structural change doesn't autobackup controlfile/spfile
@Ivan So you may be taking backups on tapes as usual but your controlfile autobackups taken by server process will be located on disk :)
Dec
6
comment Oracle 11g database structural change doesn't autobackup controlfile/spfile
@Phil , I have just added tablespace. Have not run any backup after that and for about 15 minutes later controlfile autobackup was generated..So it is automatic..
Dec
6
comment Oracle 11g database structural change doesn't autobackup controlfile/spfile
@Ivan such kind of automatic backups of controlfile are saved always on disk(when database structure changes, because backup is taken by server process itself, rather than one of the RMAN channels) Also , in 10g every structural change was causing controlfile to be backed up (so many controlfile autobackups were being generated) , in 11g it waits for a few minutes and then generates(nice upgrade) <- have tested myself , believe me :)
Dec
6
revised Oracle 11g database structural change doesn't autobackup controlfile/spfile
added 3 characters in body
Dec
6
comment Oracle 11g database structural change doesn't autobackup controlfile/spfile
@Phil Please see the answer below. and also this link docs.oracle.com/cd/E11882_01/backup.112/e10643/…
Dec
6
answered Oracle 11g database structural change doesn't autobackup controlfile/spfile
Dec
6
comment Oracle 11g database structural change doesn't autobackup controlfile/spfile
As I know that database structural changes cause controlfile/spfile to be automatically backed up.
Dec
6
asked Oracle 11g database structural change doesn't autobackup controlfile/spfile
Nov
20
revised Oracle 10g XE SET NEWNAME doesn't work
Solution added
Nov
20
asked Oracle 10g XE SET NEWNAME doesn't work
Nov
19
comment Install 10g XE on 64bit linux
@Phil backup taken with RMAN
Nov
19
asked Install 10g XE on 64bit linux
Nov
18
accepted Recover corrupted blocks in Oracle 10g XE