Pak Leo, jadi maksudnya saya gak bisa restore dari file backup-an RMAN ini ?
atau gmn ?
trs klo saya mau restore ke server yg baru saya install software oracle, gmn
pak ? saya gak nemu2 caranya ?
bukan berarti saya gak bisa restore kan ? karena saya backup oracle db dgn
format ini. terima kasih.
2008/3/5 Leonard Sukendro <[EMAIL PROTECTED]>:
>
> to pak andes...
>
> moga2 saya gk salah liat :), tp
> '/u01/tmp/Backup_DB_Intermas/fullbackup/%d_%t_%s_%p.dbf'
> --> ini bukan nama file hasil backup-an RMAN, boss...
> "%d_%t_%s_%p.dbf" ini masi dalam bntuk format
> backup-an RMAN, bkn hasil backup-an RMAN itu ndiri...
>
> coba liat hasil backup-an ctlfile nya:
> '%d_%t_%s_%p.cf'--> ini format backup-an ctlfile RMAN
> 'ITTDB_648328222_25_1.cf' --> ini file OS hasil
> backup-an ctlfile dr RMAN
>
> CMIIW,
> [L]
>
>
> --- Andes Febrian <[EMAIL PROTECTED] <pejantan4u%40gmail.com>> wrote:
>
> > Dear gurus,
> >
> > Saya mau restore database dari file backup yg ada.
> > file backup tersebut saya
> > backup online dgn rman. tp ketika saya restore,
> > sepertinya syntax saya
> > salah, ada kah yg bisa beri saya pencerahan.
> > saya jalankan crontab script yg memanggil file
> > backupdb.rman ini. kemudian
> > saya ingin restore ke server baru, sama2 linux RHEL
> > 4, sama2 oracle db 10g
> > R2 tp gak sama versi - yg backup versi 10.2.0.3
> > 64bit, yg baru saya install
> > 10.2.0.1 32bit -
> > ketika saya restore control file, berjalan lancar,
> > tp ketika saya mau
> > restore spfile, terjadi eror,
> >
> > 1. saya copykan hasil backup server lama ke server
> > baru (beda direktori)
> > 2. connect rman target / (tanpa catalog)
> > 3. rman>startup force nomount
> > 4. rman>restore controlfile from
> >
> '/u01/tmp/backupdb/full_backup/ITTDB_648328222_25_1.cf';
> > (berjalan lancar)
> > 5. rman>restore spfile from
> > '/u01/tmp/backupdb/full_backup/%d_%t_%s_%p.dbf';
> > (muncul eror)
> > eror sebagai berikut :
> > RMAN> restore spfile from
> >
> '/u01/tmp/Backup_DB_Intermas/fullbackup/%d_%t_%s_%p.dbf';
> > Starting restore at 05-MAR-08
> > allocated channel: ORA_DISK_1
> > channel ORA_DISK_1: sid=36 devtype=DISK
> > RMAN-00571:
> >
> ===========================================================
> > RMAN-00569: =============== ERROR MESSAGE STACK
> > FOLLOWS ===============
> > RMAN-00571:
> >
> ===========================================================
> > RMAN-03002: failure of restore command at 03/05/2008
> > 14:26:56
> > RMAN-06172: no autobackup found or specified handle
> > is not a valid copy or
> > piece
> >
> >
> > berikut contoh script backup saya :
> >
> >
> > # Full backup of datafiles, control files, and
> > archived log
> >
> > #
> >
> > run {
> >
> > allocate channel ch1 type disk;
> >
> > backup
> >
> > database
> >
> > tag = 'full_backup'
> >
> > filesperset 5
> >
> > format
> >
> '/home/oracle/OraHome01/flash_recovery_area/full/%d_%t_%s_%p.dbf'
> >
> > ;
> >
> > # archives current redo log
> >
> > sql 'ALTER SYSTEM ARCHIVE LOG CURRENT';
> >
> > # archives all un-archived redo logs
> >
> > #sql 'ALTER SYSTEM ARCHIVE LOG ALL';
> >
> > backup
> >
> > current controlfile
> >
> > filesperset 5
> >
> > format
> >
> '/home/oracle/OraHome01/flash_recovery_area/full/%d_%t_%s_%p.cf'
> >
> > ;
> >
> > backup
> >
> > filesperset 10
> >
> > format
> >
> '/home/oracle/OraHome01/flash_recovery_area/full/%d_%t_%s_%p.arch'
> >
> > archivelog all
> >
> > delete input
> >
> > ;
> >
> > release channel ch1;
> >
> > }
> > dan hasil backup format nya sebagai berikut :
> > /u01/tmp/backupdb/full_backup/
> > -rwxr-xr-x 1 oracle dba 877305856 Mar 5 10:59
> > ITTDB_648327603_21_1.dbf
> > -rwxr-xr-x 1 oracle dba 1215291392 Mar 5 11:06
> > ITTDB_648327818_22_1.dbf
> > -rwxr-xr-x 1 oracle dba 1159831552 Mar 5 11:12
> > ITTDB_648328033_23_1.dbf
> > -rwxr-xr-x 1 oracle dba 8617984 Mar 5 11:12
> > ITTDB_648328222_25_1.cf
> > mohon pencerahannya, terima kasih.
> >
> > --
> > Cheers,
> > ^_^ Andes ^_^
> >
> >
> > [Non-text portions of this message have been
> > removed]
> >
> >
>
> __________________________________________________________
> 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]
