rman all backup are expired

Hello,

I see that in a rman catalog all backups are expired.
Why?
Is a crosscheck command can expired all backup and the last backup?
I have to restore a db urgently.
How can I resolve it?
Thanks
Regards
bibi92Asked:
Who is Participating?

[Product update] Infrastructure Analysis Tool is now available with Business Accounts.Learn More

x
I wear a lot of hats...

"The solutions and answers provided on Experts Exchange have been extremely helpful to me over the last few years. I wear a lot of hats - Developer, Database Administrator, Help Desk, etc., so I know a lot of things but not a lot about one thing. Experts Exchange gives me answers from people who do know a lot about one thing, in a easy to use platform." -Todd S.

bibi92Author Commented:
The status of backup are available if rman not connected to the catalog but controlfile.
Is it possible to synchronize them?

Thanks

Regards
Steve WalesSenior Database AdministratorCommented:
A status of EXPIRED means that the files are not in the location that your RMAN repository (either the controlfile or a catalog database) expects them to be in.

If you are doing backups to disk, for example, and then later move those backup files to tape and remove them, then Oracle can't find them.

What are you doing to the backup files after your backups complete ?  Are you moving them somewhere else ?
bibi92Author Commented:
no only on tape for 1 month and the backup status is expired for all days in July if I connect to catalog rman but the status are avalaible if I list backup without controlfile. Thanks
Determine the Perfect Price for Your IT Services

Do you wonder if your IT business is truly profitable or if you should raise your prices? Learn how to calculate your overhead burden with our free interactive tool and use it to determine the right price for your IT services. Download your free eBook now!

Get Your eBook
Steve WalesSenior Database AdministratorCommented:
I don't understand what you mean by "List backup without controlfile" - can you clarify that please ?

Have you ever tested your restore processes before ?  There's an old saying "Your backups are only as good as the last time you tested the restore"
bibi92Author Commented:
I have to restore a database size 3tb on another server, I can't copy backup on disk :



If I connect without catalog rman target / the backup piece is AVAILABLE :
 Backup Set Copy #2 of backup set 24210
  Device Type Elapsed Time Completion Time     Compressed Tag
  ----------- ------------ ------------------- ---------- ---
  SBT_TAPE    00:00:00     15/07/2015 23:54:06 YES        BCOM1PRD_1_20150715_214741

    List of Backup Pieces for backup set 24210 Copy #2
    BP Key  Pc# Status      Media                   Piece Name
    ------- --- ----------- ----------------------- ----------
    24198   1   AVAILABLE  @aaaa2                  diqc503e_1_2

but if I try to restore ORA-27029: skgfrtrv: sbtrestore returned error
ORA-19511: Error received from media manager layer, error text:
   Backup file <50qbd6pb_1_2> not found in NetBackup catalog


I have to restore the database on another server but when I connect with catalog rman catalog rprd@rcat


BS Key  Size       Device Type Elapsed Time Completion Time
------- ---------- ----------- ------------ -------------------
21769145 1.01G      SBT_TAPE    00:00:42     15/07/2015 23:50:24
        BP Key: 21770183   Status: EXPIRED  Compressed: NO  Tag: TAG20150715T234940
        Handle: dtqc558m_1_1   Media: @aaaa2

Thanks
Steve WalesSenior Database AdministratorCommented:
It appears you're using Netbackup as your backup tool.  I'm sorry,  but I don't have any experience with that tool (nor backup directly to tape, I'm afraid).

I'm not going to be able to offer you much more help here.

My suggestion at this point, if no other experts can offer you any insight, would be to contact your backup solution vendor (Netbackup) for assistance.
bibi92Author Commented:
ok thanks
Franck PachotOracle DBACommented:
Hi,
Are you trying to access backups that have been made from another host?
Then you probably have to set the NB_CLIENT to that host.
That can be a reason why backups are not found.
Regards,
Franck.
bibi92Author Commented:
Are you trying to access backups that have been made from another host? --> yes
Then you probably have to set the NB_CLIENT to that host --> how?
I think crosscheck backup has expired backupset but I'm not sure.

Thanks
Franck PachotOracle DBACommented:
Hi,
Yes crosscheck has made them EXPIRED because they cannot be found.
You can set the NB_CLIENT withthe RMAN 'send' command such as in: http://www.orafaq.com/wiki/Veritas_Netbackup
Then crosscheck to see if it is available
Regards,
Franck.
bibi92Author Commented:
Hello,

Thanks I do it.  But do I have to configure bp.conf like its an redirect backup?

Regards
Franck PachotOracle DBACommented:
Usually only the nb_client is different and you can set it in the RMAN session
bibi92Author Commented:
I do it  but if I try to restore ORA-27029: skgfrtrv: sbtrestore returned error
 ORA-19511: Error received from media manager layer, error text:
    Backup file <50qbd6pb_1_2> not found in NetBackup catalog
Thanks
Franck PachotOracle DBACommented:
Try to find it from Netbackup GUI so that you know if it's there and where
bibi92Author Commented:
I don't know how I can do it.
msb1979Commented:
Hello,

   You can ask Storage / Tape management team with backup piece name to check if the backup is available, possibly, that particular tape where the backup is sitting, would have been rotated and not actively being written to.

you can set NB_ORA_CLIENT as below

allocate auxiliary channel c1 type 'SBT_TAPE' parms 'ENV=(NB_ORA_SERV=<netbackup server name>, NB_ORA_CLASS=<backup policy name>,  NB_ORA_CLIENT=<database hostname from where the backup was fired>)';


Cheers

Experts Exchange Solution brought to you by

Your issues matter to us.

Facing a tech roadblock? Get the help and guidance you need from experienced professionals who care. Ask your question anytime, anywhere, with no hassle.

Start your 7-day free trial
bibi92Author Commented:
Thanks the restore is running. Regards
It's more than this solution.Get answers and train to solve all your tech problems - anytime, anywhere.Try it for free Edge Out The Competitionfor your dream job with proven skills and certifications.Get started today Stand Outas the employee with proven skills.Start learning today for free Move Your Career Forwardwith certification training in the latest technologies.Start your trial today
Oracle Database

From novice to tech pro — start learning today.