Skip to Main Content

Oracle Database Discussions

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

After cloning

633221Jul 15 2008 — edited Jul 15 2008
After 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.
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Aug 12 2008
Added on Jul 15 2008
2 comments
428 views