After cloning
633221Jul 15 2008 — edited Jul 15 2008After cloning the database .
i cannt able to open the destination database(clone).
The source database and destination database are consist only archivelog sequences till 377 , but recovery is searching for sequences 379
Please find the below one, Kindly suggest me a solution
SQL> alter database open;
alter database open
*
ERROR at line 1:
ORA-01589: must use RESETLOGS or NORESETLOGS option for database open
SQL> alter database open resetlogs;
alter database open resetlogs
*
ERROR at line 1:
ORA-01113: file 1 needs media recovery
ORA-01110: data file 1: 'D:\ORACLE\PRODUCT\10.2.0\ORADATA\CLONE\SYSTEM01.DBF'
SQL> recover database;
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;
ORA-00279: change 13815092 generated at 07/15/2008 11:52:55 needed for thread 1
ORA-00289: suggestion :
D:\ORACLE\PRODUCT\10.2.0\FLASH_RECOVERY_AREA\CLONE\ARCHIVELOG\2008_07_15\O1_MF_1
_379_%U_.ARC
ORA-00280: change 13815092 for thread 1 is in sequence #379
Specify log: {<RET>=suggested | filename | AUTO | CANCEL}
auto
ORA-00308: cannot open archived log
'D:\ORACLE\PRODUCT\10.2.0\FLASH_RECOVERY_AREA\CLONE\ARCHIVELOG\2008_07_15\O1_MF_
1_379_%U_.ARC'
ORA-27041: unable to open file
OSD-04002: unable to open file
O/S-Error: (OS 2) The system cannot find the file specified.
ORA-00308: cannot open archived log
'D:\ORACLE\PRODUCT\10.2.0\FLASH_RECOVERY_AREA\CLONE\ARCHIVELOG\2008_07_15\O1_MF_
1_379_%U_.ARC'
ORA-27041: unable to open file
OSD-04002: unable to open file
O/S-Error: (OS 2) The system cannot find the file specified.
SQL> select SEQUENCE# from V$ARCHIVED_LOG;
SEQUENCE#
----------
359
360
361
362
363
364
365
366
367
368
369
SEQUENCE#
----------
370
371
372
373
374
375
376
377
19 rows selected.