Hola, mau tanya nih juragan sekalian ttg online backup di
oracle.kwkwkwkw..mbackupnya sih dah kelar skrg restorenya gagal mulu
pulak ergggh
FYI step online backup yg sy lakukan adalah sbb
1. set db jadi archive log mode
2. alter tablespace system/sysaux/users/undotbs1/ begin backup
3. copy datafile yang ada di dalam tablespace tsb ke mana terserah
4. alter tablespace system/sysaux/users/undotbs1/ end backup
5. 'alter database backup controfile to trace'
i've finished those all...
nah mau restore nih
FYI yang saya lakukan stepnya sbb
1. shutdown immediate
2. balikin datafile tadi+balikin archive lognya ( anyway archive log
itu yg ekstensinya .arc bukan sih ? )
3. startup mount
4. recover database using backup controlfile
====mulai error deh====
nah ini dia selalu gagal messagenya adalah sbb
"ORA-00279: change 572285 generated at 03/15/2010 15:00:54 needed for thread 1
ORA-00289: suggestion :
E:\ORACLE\PRODUCT\10.2.0\FLASH_RECOVERY_AREA\DATABASE\ARCHIVELOG\2010_03_15\O1_M
F_1_2_%U_.ARC
ORA-00280: change 572285 for thread 1 is in sequence #2
Specify log: {<RET>=suggested | filename | AUTO | CANCEL}
auto
ORA-00279: change 573778 generated at 03/15/2010 15:25:07 needed for thread 1
ORA-00289: suggestion :
E:\ORACLE\PRODUCT\10.2.0\FLASH_RECOVERY_AREA\DATABASE\ARCHIVELOG\2010_03_15\O1_M
F_1_3_%U_.ARC
ORA-00280: change 573778 for thread 1 is in sequence #3
ORA-00278: log file
'E:\ORACLE\PRODUCT\10.2.0\FLASH_RECOVERY_AREA\DATABASE\ARCHIVELOG\2010_03_15\O1_
MF_1_2_5SVVQ41G_.ARC' no longer needed for this recovery
ORA-00308: cannot open archived log
'E:\ORACLE\PRODUCT\10.2.0\FLASH_RECOVERY_AREA\DATABASE\ARCHIVELOG\2010_03_15\O1_
MF_1_3_%U_.ARC'
ORA-27041: unable to open file
OSD-04002: unable to open file
O/S-Error: (OS 2) The system cannot find the file specified.
"
kalo ikut yang ditutorial kan rohmad.net dengan 'alter database backup
controlfile to
'/backupdir/backupcontrol_22042008.bak'; juga gagal euy...
mohon koreksi dan pencerahannya, Terima kasih yaa
--
Regards
Dedi Caesar Humaedi
