Ulfat`s DataBase Blog

Example of recovery database until time. For checking after recovery I am going to create simple table with one row SQL> create user ulfet identified by ulfet; User created. SQL> grant dba to ulfet; Grant succeeded. SQL> conn ulfet/ulfet Connected. SSQL> create table test1 (id number); Table created. SQL> insert into test1 values(1); 1 row created. SQL> commit; Commit complete. Now taking backup. RMAN> backup database plus archivelog; --note date SQL> select systimestamp from dual; SYSTIMESTAMP --------------------------------------------------------------------------- 13-JAN-16 11.03.34.646076 AM +04:00 --dropping table SQL> drop table ulfet.test1; Table dropped. SQL> select systimestamp from dual; SYSTIMESTAMP --------------------------------------------------------------------------- 13-JAN-16 11.04.40.428868 AM +04:00 SQL> --start recovery process --firstly start...

Today while duplication database I faced strange error: RMAN-00571: =========================================================== RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS =============== RMAN-00571: =========================================================== RMAN-03002: failure of Duplicate Db command at 07/09/2013 16:02:16 RMAN-06136: ORACLE error from auxiliary database: ORA-01503: CREATE CONTROLFILE failed ORA-01130: database file version 11.1.0.0.0 incompatible with ORACLE version 11.0.0.0.0 ORA-01110: data file 1: '/u01/app/oracle/oradata/DUPLPROD/system01.dbf' I checked all actions and tried again, but result was same. Error happened creation control file. Let me note that I used to duplication on the same host and Oracle version 11.1.0.7.0 SQL> select * from v$version; BANNER -------------------------------------------------------------------------------- Oracle Database 11g Enterprise Edition Release 11.1.0.7.0 - 64bit Production PL/SQL R...