Home » RDBMS Server » Backup & Recovery » rman crosscheck (11.2.3 RHEL5.5)
rman crosscheck [message #623757] Sun, 14 September 2014 03:21 Go to next message
smunir362
Messages: 305
Registered: September 2007
Senior Member
I have a question....
I scheduled backup scripts.. full,incremental, archivelog on my 11g database.
Backup works fine....But
When I crosscheck for sbt channel then some backups are not available and marks it expired...
I want to know how MML be configured to backup available for cross-check..
Re: rman crosscheck [message #623760 is a reply to message #623757] Sun, 14 September 2014 04:26 Go to previous messageGo to next message
John Watson
Messages: 7212
Registered: January 2010
Location: Global Village
Senior Member
One explanation would be that your tape library is deleting stuff, in which case you need to DELETE EXPIRED BACKUPSET;. What does your system administrator say?
Re: rman crosscheck [message #623774 is a reply to message #623760] Sun, 14 September 2014 09:49 Go to previous messageGo to next message
smunir362
Messages: 305
Registered: September 2007
Senior Member
yes I think rman cannot see the tapes that contain backups...So it mark it expire while running crosscheck..
Sysadmin says they did not delete backup from tapes at their end....
Re: rman crosscheck [message #623775 is a reply to message #623774] Sun, 14 September 2014 09:52 Go to previous messageGo to next message
John Watson
Messages: 7212
Registered: January 2010
Location: Global Village
Senior Member
You can believe RMAN or you can believe your System Administrators.

By the way, your keyboard is faulty: it inserts multiple "....." characters which make your posts painful to read.
Re: rman crosscheck [message #623776 is a reply to message #623775] Sun, 14 September 2014 09:57 Go to previous messageGo to next message
smunir362
Messages: 305
Registered: September 2007
Senior Member
Thanks for quick reply.
So I would say to sys admin for review the policies at tsm server.
Re: rman crosscheck [message #623777 is a reply to message #623776] Sun, 14 September 2014 10:20 Go to previous message
Michel Cadot
Messages: 65317
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator

Quote:
So I would say to sys admin for review the policies at tsm server.


Indeed, this is the main reason a backup could disappear from the tapes.
Review your tdpo option to check the class in which your RMAN backups are taken and with your sysadmin to know the retention for this class.

Previous Topic: ORA-19554: error allocating device, device type: SBT_TAPE, device name
Next Topic: Recover dropped table from rman backup
Goto Forum:
  


Current Time: Wed Jan 17 15:10:54 CST 2018

Total time taken to generate the page: 0.02820 seconds