bibi92
asked on
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
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
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 ?
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 ?
ASKER
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
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"
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"
ASKER
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
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
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.
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.
ASKER
ok thanks
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.
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.
ASKER
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
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
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.
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.
ASKER
Hello,
Thanks I do it. But do I have to configure bp.conf like its an redirect backup?
Regards
Thanks I do it. But do I have to configure bp.conf like its an redirect backup?
Regards
Usually only the nb_client is different and you can set it in the RMAN session
ASKER
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
ORA-19511: Error received from media manager layer, error text:
Backup file <50qbd6pb_1_2> not found in NetBackup catalog
Thanks
Try to find it from Netbackup GUI so that you know if it's there and where
ASKER
I don't know how I can do it.
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
Thanks the restore is running. Regards
ASKER
Is it possible to synchronize them?
Thanks
Regards