Maksud pak Leo adalah
Anda salah memberikan nama backup file ke RESTORE command anda.
Coba liat :
RMAN> restore spfile from
'/u01/tmp/Backup_DB_Intermas/fullbackup/%d_%t_%s_%p.dbf';
dari hasil backup Anda, adakah file dengan nama di atas???
/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
On 05/03/2008, Andes Febrian <[EMAIL PROTECTED]> wrote:
>
> 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] <leon_190699%40yahoo.com>
> >:
>
> >
> > 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><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]
>
>
>
[Non-text portions of this message have been removed]
