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