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], 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] >
