RMAN ANS1302E (RC2) No objects on server match query

[CarlosJ]

Hello,
I have a big trouble because our backups RMAN-TDP are working very well (it seems) but we are trying to restore the database in another server (same configuration files) and now RMAN can find the controlfile and spfile but not remaining objects! The DBA and me have checked the configuration many many times and we haven't found answers Unfortunately I don't know a lot of RMAN, but my partner thinks that TSM is the problem. We are really worried about this and our boss is asking for a response as soon as possible. We really will appreciate all your help! Thank you.

It is a Tivoli Data Protection for Oracle: version 5.2.0.0.

Starting restore at 18-OCT-08
channel t1: starting datafile backupset restore
channel t1: specifying datafile(s) to restore from backup set
restoring datafile 00027 to /u02/oradata/qlcnt/QLEMS7.dbf
channel t1: reading from backup piece qlcnt_df_dia_20081016_jijt93qh
ORA-19870: error reading backup piece qlcnt_df_dia_20081016_jijt93qh
ORA-19507: failed to retrieve sequential file, handle="qlcnt_df_dia_20081016_jijt93qh", parms=""
ORA-27029: skgfrtrv: sbtrestore returned error
ORA-19511: Error received from media manager layer, error text:
ANS1302E (RC2) No objects on server match query
channel t1: starting datafile backupset restore
channel t1: specifying datafile(s) to restore from backup set
restoring datafile 00007 to /u01/app/oracle/oradata/qlcnt/ql2_02.dbf
restoring datafile 00010 to /u01/app/oracle/oradata/qlcnt/ql03.dbf
restoring datafile 00012 to /u01/app/oracle/oradata/qlcnt/ql2_04.dbf
restoring datafile 00016 to /u01/app/oracle/oradata/qlcnt/QLEMS1.dbf
restoring datafile 00017 to /u01/app/oracle/oradata/qlcnt/QLEMS2.dbf
restoring datafile 00018 to /u01/app/oracle/oradata/qlcnt/QLEMS3.dbf
channel t1: reading from backup piece qlcnt_df_dia_20081016_jjjt94k1
ORA-19870: error reading backup piece qlcnt_df_dia_20081016_jjjt94k1
ORA-19507: failed to retrieve sequential file, handle="qlcnt_df_dia_20081016_jjjt94k1", parms=""
ORA-27029: skgfrtrv: sbtrestore returned error
ORA-19511: Error received from media manager layer, error text:
ANU2508E Wrong write state
channel t1: starting datafile backupset restore
channel t1: specifying datafile(s) to restore from backup set
restoring datafile 00004 to /u01/app/oracle/oradata/qlcnt/qlcnt/users01.dbf
restoring datafile 00019 to /u01/app/oracle/oradata/qlcnt/QLEMS4.dbf
restoring datafile 00020 to /u01/app/oracle/oradata/qlcnt/QLEMS5.dbf
restoring datafile 00021 to /u01/app/oracle/oradata/qlcnt/ql2_06.dbf
restoring datafile 00022 to /u01/app/oracle/oradata/qlcnt/QLEMS6.dbf
restoring datafile 00023 to /u03/oradata/qlcnt/users02.dbf
channel t1: reading from backup piece qlcnt_df_dia_20081016_jkjt9578
ORA-19870: error reading backup piece qlcnt_df_dia_20081016_jkjt9578
ORA-19507: failed to retrieve sequential file, handle="qlcnt_df_dia_20081016_jkjt9578", parms=""
ORA-27029: skgfrtrv: sbtrestore returned error
ORA-19511: Error received from media manager layer, error text:
ANU2508E Wrong write state

It's impossible to find information about that last message... just "Report to your vendor"

 

[cheffern]

don't think you can just restore a database to another server...
there is a unique ID to each RMAN instance -
you would have to first get that ID and log in to RMAN using it to see if it will let you see the data on the other server.

there are various other posts on this site on the issue -
just do a search (upper left of the main page) and you should be able to pull some good info up that will help...

good luck -
-Chef.

 

[CarlosJ]

Solved!

Chef, thank you for your comment... we solved the problem, it was a RMAN policy that had been bad configurated and it was erasing the info from the day before... it means, files couldn't be restaured because RMAN had erase them! It was a RMAN problem, not a TSM problem. Thank you.

 

[cheffern]

wow. glad you figured that out! that could have spilled out into a really big disaster!!!