OraFAQ Forum: Backup & Recovery » Delete obsolete backups

Home » RDBMS Server » Backup & Recovery » Delete obsolete backups (Oracle 10g - AIX)

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

Delete obsolete backups [message #500085]

Thu, 17 March 2011 13:06

prashanthgs
Messages: 89
Registered: May 2005
Location: chennai

Member

Hi,

We observed that our RMAN backup was taking more time to complete. CROSSCHECK is the main culprit as because of having data in the catalog for more than 3 years.

So in the part of script we added delte obsolete recovery windoe of 14 days. (Redundancey 1).

Here the problem is we are getting error as

RMAN-03002 - failure of delete command
RMAN-06091 - NO channel allocated for maintenance (of an appropriate type).

Reason: Till 2 years back the backup was stored in tape and after that it got changed to disk. So allocating channel disk to delete obsolet is not working. How we can over come this.

We tried like allocating channel tape sbt_type. It got failed as no media manager information configured. We dont have that information.

How we can overcome this.

Oracle 10g
AIX 5.1

Thanks

Report message to a moderator

Re: Delete obsolete backups [message #500090 is a reply to message #500085]

Thu, 17 March 2011 13:25

Michel Cadot
Messages: 68716
Registered: March 2007
Location: Saint-Maur, France, https...

Senior Member
Account Moderator

Call Oracle and ask it the statements to execute on the catalog to purge it.

By the way, "recovery windoe of 14 days. (Redundancey 1)" is not possible you have either window or redundancy policy not both at the same time.

Regards
Michel

Report message to a moderator

Re: Delete obsolete backups [message #500092 is a reply to message #500085]

Thu, 17 March 2011 13:29

Mahesh Rajendran
Messages: 10708
Registered: March 2002
Location: oracleDocoVille

Senior Member
Account Moderator

You can always allocate a dummy channel by using the sbt Library (dummy API).
Something like this

allocate channel for maintenance device type sbt parms 'SBT_LIBRARY=oracle.disksbt, ENV=(BACKUP_DIR=/tmp)';

More examples in docos.
http://download.oracle.com/docs/cd/B19306_01/backup.102/b14191/rcmconfg.htm#sthref406

Quoting docs

# sbt channel configuration
CONFIGURE DEVICE TYPE sbt PARALLELISM 3;
CONFIGURE CHANNEL DEVICE TYPE sbt 
      PARMS='SBT_LIBRARY=oracle.disksbt, ENV=(BACKUP_DIR=?/oradata)';
CONFIGURE CHANNEL 3 DEVICE TYPE sbt 
      PARMS='SBT_LIBRARY=oracle.disksbt, ENV=(BACKUP_DIR=/tmp)';

[Updated on: Thu, 17 March 2011 13:38]

Report message to a moderator

Re: Delete obsolete backups [message #500096 is a reply to message #500092]

Thu, 17 March 2011 13:51

Michel Cadot
Messages: 68716
Registered: March 2007
Location: Saint-Maur, France, https...

Senior Member
Account Moderator

Quote:

You can always allocate a dummy channel by using the sbt Library (dummy API).

Good to know! /forum/fa/2115/0/

Regards
Michel

Report message to a moderator

Re: Delete obsolete backups [message #500107 is a reply to message #500096]

Thu, 17 March 2011 15:02

prashanthgs
Messages: 89
Registered: May 2005
Location: chennai

Member

thanks for the reply. I tried the option but giving the below error.

RMAN> configure channel 1 device type sbt parms 'SBT_LIBRARY=/backup/lib/libobk.so, ENV=BACKUP_DIR=/backup)';

new RMAN configuration parameters:

CONFIGURE CHANNEL 1 DEVICE TYPE 'SBT_TAPE' PARMS 'SBT_LIBRARY=/backup/lib/libobk.so, ENV=BACKUP_DIR=/backup)';
new RMAN configuration parameters are successfully stored
starting full resync of recovery catalog
full resync complete

RMAN> delete noprompt obsolete recovery window of 14 days;
RMAN-00571: ===========================================================
RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
RMAN-00571: ===========================================================
RMAN-03009: failure of delete command on ORA_MAINT_SBT_TAPE_2 channel at 03/17/2011 15:44:14
ORA-27191: sbtinfo2 returned error

Additional information: 2

Referrring to the error, its asking any media manager software got installed on this.

Any Inputs please

Report message to a moderator

Re: Delete obsolete backups [message #500109 is a reply to message #500107]

Thu, 17 March 2011 15:07

Michel Cadot
Messages: 68716
Registered: March 2007
Location: Saint-Maur, France, https...

Senior Member
Account Moderator

Quote:

Any Inputs please

Did you try what Raj mentioned?

Regards
Michel

Report message to a moderator

Re: Delete obsolete backups [message #500114 is a reply to message #500109]

Thu, 17 March 2011 15:15

prashanthgs
Messages: 89
Registered: May 2005
Location: chennai

Member

Yes. I tried that also. Got the same error.

RMAN> allocate channel for maintenance device type sbt parms 'SBT_LIBRARY=oracle.disksbt, ENV=(BACKUP_DIR=/backup)';

allocated channel: ORA_MAINT_SBT_TAPE_3

channel ORA_MAINT_SBT_TAPE_3: sid=5420 instance=instance1 devtype=SBT_TAPE

channel ORA_MAINT_SBT_TAPE_3: WARNING: Oracle Test Disk API

NetWorker: Reverse DNS lookup failed for address 192.168.58.72

RMAN-00571: ===========================================================

RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============

RMAN-00571: ===========================================================

RMAN-03009: failure of delete command on ORA_MAINT_SBT_TAPE_2 channel at 03/17/2011 16:13:05

ORA-27191: sbtinfo2 returned error

Additional information: 2

Report message to a moderator

Re: Delete obsolete backups [message #500115 is a reply to message #500114]

Thu, 17 March 2011 15:20

Mahesh Rajendran
Messages: 10708
Registered: March 2002
Location: oracleDocoVille

Senior Member
Account Moderator

Are you using Oracle Secure Backup?

Update:
Seems irrelevant.

Did you just try this?

allocate channel for maintenance device type sbt parms 'SBT_LIBRARY=oracle.disksbt, ENV=(BACKUP_DIR=/tmp)';

[Updated on: Thu, 17 March 2011 15:26]

Report message to a moderator

Re: Delete obsolete backups [message #500121 is a reply to message #500114]

Thu, 17 March 2011 16:16

Michel Cadot
Messages: 68716
Registered: March 2007
Location: Saint-Maur, France, https...

Senior Member
Account Moderator

Raj is right because "Additional information: 2" means RMAN was unable to reach the directory.

Regards
Mchel

Report message to a moderator

Re: Delete obsolete backups [message #500122 is a reply to message #500115]

Thu, 17 March 2011 16:25

prashanthgs
Messages: 89
Registered: May 2005
Location: chennai

Member

Thank you very much Mahesh. It worked. I missed to give force prompt last time.

Report message to a moderator

Previous Topic:	Query on Cloning DB across Platform
Next Topic:	Removing rman backup only

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Sun Nov 24 19:16:17 CST 2024