Dulu saya pernah mengalami kejadian seperti ini.. Sepertinya karena masih ada datafile yang belum sinkron SCN-nya dengan yang lain (masih di redo log) atau bagaimana. Inilah yang saya lakukan
SQL> startup mount; SQL> recover database; SQL> alter database open; (tanpa resetlogs) dengan catatan, saat anda re-create controlfile tidak ada masalah/error yang muncul sebelumnya regards, adipt ----- Original Message ----- From: Andes Febrian<mailto:[email protected]> To: [email protected]<mailto:[email protected]> Sent: Wednesday, November 11, 2009 10:51 AM Subject: External Email: --> [indo-oracle] setelah restore db, ketika recover muncul error.. urgent Dear gurus, saya berniat untuk melakukan restore database (cloning database) dari server lama RAC - ASM ke server baru single instance - ASM. kemudian tahap restore controlfile hingga restore database sukses, Finished restore at 10-NOV-09 released channel: ch01 RMAN> quit tapi ketika recover database keluar error di bawah ini : SQL> recover database; ORA-00283: recovery session canceled due to errors ORA-01610: recovery using the BACKUP CONTROLFILE option must be done kemudian saya lakukan, recover using backup controlfile, recover database using backup controlfile ORA-00279: change 2830971 generated at 11/10/2009 17:01:41 needed for thread 1 ORA-00289: suggestion : +DGARCH ORA-00280: change 2830971 for thread 1 is in sequence #22 Specify log: {<RET>=suggested | filename | AUTO | CANCEL} CANCEL Media recovery cancelled. SQL> QUIT setelah itu saya coba recover archive log sequence 22, RMAN> connect target / connected to target database: TESTDB (DBID=3854894242, not open) RMAN> run 2> { 3> allocate channel ch01 type sbt; 4> restore archivelog from logseq 22; 5> release channel ch01; 6> } using target database control file instead of recovery catalog allocated channel: ch01 channel ch01: sid=148 devtype=SBT_TAPE channel ch01: Data Protection for Oracle: version 5.5.1.0 Starting restore at 10-NOV-09 channel ch01: starting archive log restore to default destination channel ch01: restoring archive log archive log thread=1 sequence=22 channel ch01: restoring archive log archive log thread=1 sequence=23 channel ch01: reading from backup piece TESTDB/702580055/13/1 channel ch01: restored backup piece 1 piece handle=TESTDB/702580055/13/1 tag=BACKUP TEST DB ARCHIVE LOGS channel ch01: restore complete, elapsed time: 00:01:36 Finished restore at 10-NOV-09 released channel: ch01 RMAN> quit finish dengan restore dan recover archive log 22 dan 23, saya coba open database dengan resetlogs, 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: '+DGSYSTEM/testdb/datafile/system.297.702580735' please butuh masukan dari gurus. Thanks. -- Best Regards, Andes [Non-text portions of this message have been removed] ________________________________ This e-mail and any files transmitted with it are confidential and intended solely for the use of the individual or entity to whom they are addressed. If you have received this email by mistake please notify the sender by return e-mail and delete this message from your system. Any unauthorized use or dissemination of this e-mail in whole or in part is strictly prohibited. PT Federal International Finance, which has its seat at North of Jakarta, Indonesia, including its affiliated companies, shall not be liable for the improper or incomplete transmission of the information contained in this e-mail nor for any delay in its receipt or damage to your system. PT Federal International Finance (or its affiliated companies) does not guarantee that the integrity of this communication has been maintained nor that this communication is free of viruses, interceptions or interference. [Non-text portions of this message have been removed] ------------------------------------ -- -----------I.N.D.O - O.R.A.C.L.E--------------- Keluar: [email protected] Website: http://indooracle.wordpress.com http://www.facebook.com/group.php?gid=51973053515 ----------------------------------------------- Bergabung dengan Indonesia Thin Client User Groups, Terminal Server, Citrix, New Moon Caneveral, di: http://indo-thin.blogspot.comYahoo! Groups Links <*> To visit your group on the web, go to: http://groups.yahoo.com/group/indo-oracle/ <*> Your email settings: Individual Email | Traditional <*> To change settings online go to: http://groups.yahoo.com/group/indo-oracle/join (Yahoo! ID required) <*> To change settings via email: [email protected] [email protected] <*> To unsubscribe from this group, send an email to: [email protected] <*> Your use of Yahoo! Groups is subject to: http://docs.yahoo.com/info/terms/
