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]
