Ulfat`s DataBase Blog

Today I found in my backup log file strange error. RMAN-06207: WARNING: 1 objects could not be deleted for DISK channel(s) due RMAN-06208:          to mismatched status.  Use CROSSCHECK command to fix status RMAN-06210: List of Mismatched objects RMAN-06211: ========================== RMAN-06212:   Object Type   Filename/Handle RMAN-06213: --------------- --------------------------------------------------- RMAN-06214: Datafile Copy   /u01/app/oracle/product/11.2.0.3/db_1/dbs/snapcf_FCDBPROD.f RMAN> Report obsolete; RMAN retention policy will be applied to the command RMAN retention policy is set to recovery window of 3 days Report of obsolete backups and copies Type                 Key    Completion Time    Filename/Handle -------------------- ------ ------------------ -------------------- Control File Copy     1      13-JAN-14   ...

Yesterday I suddenly faced ORA-38761 and ORA-38754 errors. I checked all logs and backups which were available, but why I could not flashback db. Let`s simulate. -- First I will create new user and will create table under new user. This is for checking purpose after flashback. SQL> create user ulfet identified by ulfet; User created. SQL> grant dba to ulfet; Grant succeeded. SQL> conn ulfet/ulfet Connected. -- Note date. If you desire you may note SCN SQL> select systimestamp from dual; SYSTIMESTAMP --------------------------------------------------------------------------- 09-JAN-14 09.13.23.721393 AM +04:00 SQL> SQL> create table test (id number); Table created. SQL> insert into test values (1); 1 row created. SQL> commit; Commit complete. SQL> select systimestamp from dual; SYSTIMESTAMP --------------------------------------------------------------------------- 09-JAN-14 09.15.10.917401 AM +04:00 SQL...