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]
