Dear all, terima kasih atas responnya, ternyata setelah saya coba2 lagi, memang sepertinya bila restore ke database downgrade gak bisa, karena saya coba create script backup tersebut pada database oracle 10.2.0.1 lalu saya restore ke 10.2.0.1, bisa baik controlfile maupun spfile. kemudian, gmn command klo kita mau restore database dan recover ya ? pake hasil backup yg ada. hasil backup rman .dbf dan .arch saya taro di direktory /mnt/trvl1/backupdb_orcldev/fullbackup/ berikut list db nya : -rwxrwxrwx 2 root root 742785024 Mar 17 07:12 ORCLDEV_649580409_111_1.dbf -rwxrwxrwx 2 root root 375316480 Mar 17 07:22 ORCLDEV_649581177_112_1.dbf -rwxrwxrwx 2 root root 97479168 Mar 17 07:24 ORCLDEV_649581799_115_1.arch
problem saya, ketika saya ketik di rman RMAN> startup mount Oracle instance started database mounted Total System Global Area 285212672 bytes Fixed Size 1218968 bytes Variable Size 117442152 bytes Database Buffers 159383552 bytes Redo Buffers 7168000 bytes RMAN> restore database; Starting restore at 24-MAR-08 Starting implicit crosscheck backup at 24-MAR-08 allocated channel: ORA_DISK_1 channel ORA_DISK_1: sid=156 devtype=DISK Crosschecked 11 objects Finished implicit crosscheck backup at 24-MAR-08 Starting implicit crosscheck copy at 24-MAR-08 using channel ORA_DISK_1 Finished implicit crosscheck copy at 24-MAR-08 searching for all files in the recovery area cataloging files... no files cataloged using channel ORA_DISK_1 RMAN-00571: =========================================================== RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS =============== RMAN-00571: =========================================================== RMAN-03002: failure of restore command at 03/24/2008 10:53:30 RMAN-06026: some targets not found - aborting restore RMAN-06023: no backup or copy of datafile 4 found to restore RMAN-06023: no backup or copy of datafile 3 found to restore RMAN-06023: no backup or copy of datafile 2 found to restore RMAN-06023: no backup or copy of datafile 1 found to restore mohon pencerahannya lagi.. :D 2008/3/19 Tomi Wijanto <[EMAIL PROTECTED]>: > Hi Andes, > > restore spfile pake rman agak spesial berhubung spfile > harusnya di-restore sebelum STARTUP NOMOUNT. > > Pertama musti cari dulu DBID dari database. DBID bisa > dilihat dari format controlfile autobackup, misalkan > file-nya c-194930444-20080319-00, maka dbid adalah > 194930444 (di v$database juga ada info db_id). > > # Login dulu ke rman > rman> SET DBID 194930444; > rman> STARTUP FORCE NOMOUNT; > > # Pada tahap diatas, database akan startup nomount > dengan dummy pfile > rman> RESTORE SPFILE FROM AUTOBACKUP; > rman> STARTUP FORCE NOMOUNT; > > # lalu restore controlfile kalau perlu > rman> RESTORE CONTROLFILE FROM AUTOBACKUP; > rman> ALTER DATABASE MOUNT; > > # lalu restore/recover datafile kalau perlu > rman> RESTORE DATABASE; > rman> RECOVER DATABASE; > rman> ALTER DATABASE OPEN; > > regards, > tomi > > > --- Andes Febrian <[EMAIL PROTECTED] <pejantan4u%40gmail.com>> wrote: > > > gini pak leo, setelah autobackup controlfile saya > > set on, maka controlfile > > yg ke backup file nya ini, > > o1_mf_n_649354700_3xnjpx2y_.bkp. untuk backup > > control file pake rman ini, gak ada hasil > > backup-annya, mgkn karena sudah > > autobackup itu yg ngebackup. > > > > backup current controlfile > > filesperset 5 > > format '/home/oradb/fullbackup/%d_%t_%s_%p.cf' > > > > walaupun saya backup controlfile pake syntax rman > > diatas maupun pake > > autobackup, sama2 gak bisa restore spfile. nah klo > > pak Leo lakukan, restore > > ke beda platform, nah klo beda versi db masih tanda > > tanya neh. apa iya gak > > bisa restore spfile karena beda versi db, tp knp > > restore controlfile baik2 > > saja ya ? > > > > mohon pencerahannya.. terima kasih. > > > > __________________________________________________________ > Be a better friend, newshound, and > know-it-all with Yahoo! Mobile. Try it now. > http://mobile.yahoo.com/;_ylt=Ahu06i62sR8HDtDypao8Wcj9tAcJ > > -- Cheers, ^_^ Andes ^_^ [Non-text portions of this message have been removed]
