Dear gurus, setelah di coba2, akhir nya bisa restore dengan sukses. saya lakukan hal - hal berikut : - restore archive log dari logseq 1 sampe terakhir logseq 24
- kemudian, recover database dari tape - lalu, alter database open resetlogs dan akhir nya sudah berhasil database altered. thanks. On Wed, Nov 11, 2009 at 12:47 PM, yulius_wibowo <[email protected]>wrote: > > > Sekedar berbagi pengalaman: > > Selama ini apabila saya melakukan cloning (single to single database > instance), setelah CONTROLFILE sukses terbentuk saya tidak menjalankan > perintah RECOVER DATABASE (di skip), tapi langsung OPEN DATABASE. > > cmiiw, > bw > > > --- In [email protected] <indo-oracle%40yahoogroups.com>, Andes > Febrian <pejanta...@...> wrote: > > > > 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] > > > > > -- Best Regards, Andes [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/
