Workaround for ORA-00283, ORA-01610, ORA-00279, ORA-00339 Errors When Duplicating Database

In my earlier posts i described how to clon an oracle database.Today when i clon database for development environment, i struggled some oracle errors. I want to share this experince by this entry:

After creatimg control files....

 
oracle@aur:/data/oradata> sqlplus / as sysdba

SQL*Plus: Release 10.1.0.5.0 - Production on Fri Dec 8 16:38:06 2006

Copyright (c) 1982, 2005, Oracle.  All rights reserved.

Connected to an idle instance.

SQL> startup nomount
ORACLE instance started.

Total System Global Area  293601280 bytes
Fixed Size                  1302824 bytes
Variable Size              94117592 bytes
Database Buffers          197132288 bytes
Redo Buffers                1048576 bytes
SQL> alter database recover database until cancel;
alter database recover database until cancel
*
ERROR at line 1:
ORA-01507: database not mounted


SQL> alter database mount;

Database altered.

SQL> alter database recover database until cancel;
alter database recover database until cancel
*
ERROR at line 1:
ORA-00283: recovery session canceled due to errors
ORA-01610: recovery using the BACKUP CONTROLFILE option must be done


SQL> recover database using backup controlfile until cancel;
ORA-00279: change 9058471059996 generated at 12/08/2006 14:18:39 needed for
thread 1
ORA-00289: suggestion :
/data06/app/oracle/product/10.1/dbs/arch1_1_608653118.dbf
ORA-00280: change 9058471059996 for thread 1 is in sequence #1


Specify log: {=suggested | filename | AUTO | CANCEL}
/data/oradata/test/redo01.log
ORA-00339: archived log does not contain any redo
ORA-00334: archived log: '/data/oradata/test/redo01.log'


ORA-01547: warning: RECOVER succeeded but OPEN RESETLOGS would get error below
ORA-01194: file 1 needs more recovery to be consistent
ORA-01110: data file 1: '/data/oradata/test/system01.dbf'


SQL> recover database using backup controlfile until cancel;
ORA-00279: change 9058471059996 generated at 12/08/2006 14:18:39 needed for
thread 1
ORA-00289: suggestion :
/data06/app/oracle/product/10.1/dbs/arch1_1_608653118.dbf
ORA-00280: change 9058471059996 for thread 1 is in sequence #1


Specify log: {=suggested | filename | AUTO | CANCEL}
/data/oradata/test/redo02.log
ORA-00339: archived log does not contain any redo
ORA-00334: archived log: '/data/oradata/test/redo02.log'


ORA-01547: warning: RECOVER succeeded but OPEN RESETLOGS would get error below
ORA-01194: file 1 needs more recovery to be consistent
ORA-01110: data file 1: '/data/oradata/test/system01.dbf'


SQL> recover database using backup controlfile until cancel;
ORA-00279: change 9058471059996 generated at 12/08/2006 14:18:39 needed for
thread 1
ORA-00289: suggestion :
/data06/app/oracle/product/10.1/dbs/arch1_1_608653118.dbf
ORA-00280: change 9058471059996 for thread 1 is in sequence #1


Specify log: {RET=suggested | filename | AUTO | CANCEL}
/data/oradata/test/redo03.log
Log applied.
Media recovery complete.
SQL> RECOVER DATABASE
ORA-00283: recovery session canceled due to errors
ORA-01610: recovery using the BACKUP CONTROLFILE option must be done


SQL> ALTER DATABASE OPEN RESETLOGS;

Database altered.

SQL> ALTER TABLESPACE TEMP ADD TEMPFILE '/data/oradata/test/temp01.dbf'
  2       SIZE 1470M REUSE AUTOEXTEND ON NEXT 655360  MAXSIZE 32767M;

Tablespace altered.

SQL> select * from dual;

D
-
X


SQL>