cancel
Showing results for 
Search instead for 
Did you mean: 

Failing to recover a Oracle backup in solaris

Gil_Tapia
Level 3

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

 

 

1 ACCEPTED SOLUTION

Accepted Solutions

Will_Restore
Level 6

check this technote for possible solution

URL http://www.symantec.com/docs/TECH76121

 

 

View solution in original post

4 REPLIES 4

Marianne
Moderator
Moderator
Partner    VIP    Accredited Certified

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....

Nicolai
Moderator
Moderator
Partner    VIP   

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.

 

Gil_Tapia
Level 3

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

Will_Restore
Level 6

check this technote for possible solution

URL http://www.symantec.com/docs/TECH76121