[ owner @ 25.03.2010. 08:21 ] @
Pozdrav, problem je u sledecem.Na masini na kojoj se nalazi produkt baza odradim Full Backup pomocu sledeceg skripta: connect target sys/abcd@ow spool log to 'K:\oracle\oradata\ow\backup\backup_ow.log'; change archivelog LIKE 'H:\ORACLE\ORADATA\OW\OW\ARCHIVELOG\%' AVAILABLE; change archivelog LIKE 'H:\STANDBY_ARCHIVES\%' UNCATALOG; configure retention policy to redundancy 1; CROSSCHECK BACKUP; DELETE NOPROMPT EXPIRED BACKUP; CROSSCHECK archivelog all; DELETE NOPROMPT EXPIRED archivelog all; configure controlfile autobackup on; configure controlfile autobackup format for device type disk to 'K:\oracle\oradata\ow\backup\B_%d_%F'; run { allocate channel c1 type disk; allocate channel c2 type disk; allocate channel c3 type disk; allocate channel c4 type disk; backup database format = 'K:\oracle\oradata\ow\backup\B_%I_%d_%t_%s_%p' plus archivelog format = 'K:\oracle\oradata\ow\backup\B_LOG_%I_%d_%t_%s_%p' delete input; release channel c1; release channel c2; release channel c3; release channel c4; } CROSSCHECK BACKUP; DELETE NOPROMPT EXPIRED BACKUP; CROSSCHECK ARCHIVELOG ALL; DELETE NOPROMPT EXPIRED ARCHIVELOG ALL; RESTORE DATABASE CHECK LOGICAL VALIDATE; exit; Na drugoj masini zelim klonirati tu bazu pomocu RMAN_a, medutim vec u nekoliko pokusaja mjenjanja Backup skripta uvek dobijam istu gresku ali samo sa ralicitim log seqvencama: Oracle Error: ORA-01547: warning: RECOVER succeeded but OPEN RESETLOGS would get error below ORA-01194: file 1 needs more recovery to be consistent ORA-01110: data file 1: 'F:\ORACLE\ORADATA\SWTEST\SYSTEM01.DBF' released channel: c1 released channel: c2 RMAN-00571: =========================================================== RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS =============== RMAN-00571: =========================================================== RMAN-03002: failure of Duplicate Db command at 03/24/2010 18:04:11 RMAN-03015: error occurred in stored script Memory Script RMAN-06053: unable to perform media recovery because of missing log RMAN-06025: no backup of log thread 1 seq 226894 lowscn 496251760 found to restore RMAN-06025: no backup of log thread 1 seq 226893 lowscn 496250786 found to restore RMAN-06025: no backup of log thread 1 seq 226892 lowscn 496249758 found to restore RMAN-06025: no backup of log thread 1 seq 226891 lowscn 496248885 found to restore RMAN-06025: no backup of log thread 1 seq 226890 lowscn 496247744 found to restore RMAN-06025: no backup of log thread 1 seq 226889 lowscn 496246667 found to restore RMAN-06025: no backup of log thread 1 seq 226888 lowscn 496245307 found to restore RMAN-06025: no backup of log thread 1 seq 226887 lowscn 496244435 found to restore RMAN-06025: no backup of log thread 1 seq 226886 lowscn 496243127 found to restore RMAN-06025: no backup of log thread 1 seq 226885 lowscn 496242304 found to restore RMAN-06025: no backup of log thread 1 seq 226884 lowscn 496241284 found to restore RMAN-06025: no backup of log thread 1 seq 226883 lowscn 496240643 found to restore Recovery Manager complete. Ako je vec neko imao iskustva sa ovom greskom voleo bih da mi napise u cemu je problem. Unapred zahvaljujem |