06-08-2012 05:19 PM
Hi ,
We are recovering an Oracle database in another machine but when trying to recover with rman
the script is:
run{
ALLOCATE CHANNEL ch00 TYPE 'SBT_TAPE' PARMS='';
set until time "to_date('07/06/2012 03:00:00','DD/MM/YYYY HH24:MI:SS')";
set newname for datafile 1 to '/u02/app/oracle/oradata/watts/system.dbf';
set newname for datafile 2 to '/u02/app/oracle/oradata/watts/sysaux.dbf';
set newname for datafile 3 to '/u02/app/oracle/oradata/watts/undotbs1.dbf';
set newname for datafile 4 to '/u02/app/oracle/oradata/watts/users.dbf';
set newname for datafile 5 to '/u02/app/oracle/oradata/watts/undotbs2.dbf';
set newname for datafile 6 to '/u02/app/oracle/oradata/watts/tsd_autorizador.dbf';
set newname for datafile 7 to '/u02/app/oracle/oradata/watts/tsi_autorizador.dbf';
set newname for datafile 8 to '/u02/app/oracle/oradata/watts/tsi_autorizadoridx.dbf';
set newname for datafile 9 to '/u02/app/oracle/oradata/watts/tsi_watts_mx_rpt.dbf';
set newname for datafile 10 to '/u02/app/oracle/oradata/watts/tsd_watts_mx_alert.dbf';
set newname for datafile 11 to '/u02/app/oracle/oradata/watts/tsi_watts_mx_alert.dbf';
set newname for datafile 12 to '/u02/app/oracle/oradata/watts/tsd_watts_streams.d3> bf';
set newname for datafile 13 to '/u02/app/oracle/oradata/watts/tsd_rep_01.dbf';
restore database;
switch datafile all;
recover database;
RELEASE CHANNEL ch00;
}
we get error at recover database step, however these logs were creater later than the backup was taken.
RMAN-00571: ===========================================================
RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
RMAN-00571: ===========================================================
RMAN-03002: failure of recover command at 06/08/2012 11:44:22
RMAN-06053: unable to perform media recovery because of missing log
RMAN-06025: no backup of archived log for thread 2 with sequence 35818 and starting SCN of 6650423762895 found to restore
RMAN-06025: no backup of archived log for thread 2 with sequence 35817 and starting SCN of 6650423757281 found to restore
RMAN-06025: no backup of archived log for thread 2 with sequence 35816 and starting SCN of 6650423751459 found to restore
RMAN-06025: no backup of archived log for thread 2 with sequence 35815 and starting SCN of 6650423745746 found to restore
RMAN-06025: no backup of archived log for thread 2 with sequence 35814 and starting SCN of 6650423728252 found to restore
RMAN-06025: no backup of archived log for thread 1 with sequence 16637 and starting SCN of 6650423728255 found to restore
Any help ? can it be a configuration information in Netbackup server?
Thanks
Solved! Go to Solution.
06-22-2012 11:25 AM
06-08-2012 10:41 PM
Using Control file or Rman catalog?
I believe archive log recovery is determined by Rman catalog, not NBU.
I have seen Oracle dba's using 'recover until' to recover to specific point in time.
I am not an Oracle/rman expert - Oracle forums might be of better assistance with required syntax....
06-09-2012 02:25 AM
You need to talk with the DBA, but I have incuded some hint here anyway
It does not look like a Netbackup configuration issues to me.
It seems Oracle can't find the archive files needed to recover the database. Try to list all oracle files backed-up and look for archive files with sequence (35818, 2517 etc) number stated in the RMAN output:
bplist -C host_name -R -l -t 4 -s 01/01/2012 /
From RMAN try the following:
RMAN:> LIST BACKUP OF ARCHIVELOG FROM SEQUENCE 35814;
If RMAN can't find the files it means they where never backed up by Netbackup. However if RMAN can find the files but bplist doesn't list the files they may have expired in Netbackup.
06-22-2012 09:48 AM
Hi,
Thank you for your response.
I have some extra information:
We are using RMAN catalog and we are trying with 'recover until' clause but the requested archive log
recovery files have a later date that the requested so we think NBU is ignoring the clause 'recover until'.
Thanks
06-22-2012 11:25 AM