554 reputation
1821
bio website dba010.wordpress.com
location Tbilisi, Georgia
age 23
visits member for 2 years, 9 months
seen 4 hours ago

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


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
Nov
13
awarded  Notable Question
Nov
11
revised Recover corrupted blocks in Oracle 10g XE
Editional steps that corrected problem but don't understand something
Nov
11
asked Recover corrupted blocks in Oracle 10g XE
Nov
1
accepted How to setup Oracle SSL using self-signed certificate between client and DB?
Oct
30
comment How to setup Oracle SSL using self-signed certificate between client and DB?
Thank you @Munchi. It helped me alot. I have read this assay(topic or what is its name in English, don't know) but for now I catch up a lot of info. :)