[ 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