Home » RDBMS Server » Backup & Recovery » Delete obsolete backups (Oracle 10g - AIX)
Delete obsolete backups [message #500085] Thu, 17 March 2011 13:06 Go to next message
prashanthgs
Messages: 83
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
Re: Delete obsolete backups [message #500090 is a reply to message #500085] Thu, 17 March 2011 13:25 Go to previous messageGo to next message
Michel Cadot
Messages: 58632
Registered: March 2007
Location: Nanterre, France, http://...
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

Re: Delete obsolete backups [message #500092 is a reply to message #500085] Thu, 17 March 2011 13:29 Go to previous messageGo to next message
Mahesh Rajendran
Messages: 10615
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 Go to previous messageGo to next message
Michel Cadot
Messages: 58632
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
Quote:
You can always allocate a dummy channel by using the sbt Library (dummy API).

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

Regards
Michel
Re: Delete obsolete backups [message #500107 is a reply to message #500096] Thu, 17 March 2011 15:02 Go to previous messageGo to next message
prashanthgs
Messages: 83
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

Re: Delete obsolete backups [message #500109 is a reply to message #500107] Thu, 17 March 2011 15:07 Go to previous messageGo to next message
Michel Cadot
Messages: 58632
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
Quote:
Any Inputs please

Did you try what Raj mentioned?

Regards
Michel
Re: Delete obsolete backups [message #500114 is a reply to message #500109] Thu, 17 March 2011 15:15 Go to previous messageGo to next message
prashanthgs
Messages: 83
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

Re: Delete obsolete backups [message #500115 is a reply to message #500114] Thu, 17 March 2011 15:20 Go to previous messageGo to next message
Mahesh Rajendran
Messages: 10615
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 Go to previous messageGo to next message
Michel Cadot
Messages: 58632
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
Raj is right because "Additional information: 2" means RMAN was unable to reach the directory.

Regards
Mchel
Re: Delete obsolete backups [message #500122 is a reply to message #500115] Thu, 17 March 2011 16:25 Go to previous message
prashanthgs
Messages: 83
Registered: May 2005
Location: chennai
Member
Thank you very much Mahesh. It worked. I missed to give force prompt last time.
Previous Topic: Query on Cloning DB across Platform
Next Topic: Removing rman backup only
Goto Forum:
  


Current Time: Thu Jul 31 08:45:17 CDT 2014

Total time taken to generate the page: 0.11166 seconds