OraFAQ Forum: Backup & Recovery

Home » RDBMS Server » Backup & Recovery » RMAN Maintenance

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

RMAN Maintenance [message #121308]

Fri, 27 May 2005 09:28

rucknrun
Messages: 26
Registered: April 2005
Location: Edgewood, MD

Junior Member

I noticed there are more and more entries in my catalog and my database controlfiles the backup process is slowing. I want to remove backups vi script for 8i databases in RMAN. When I issue the 'delete expired backup;' command it prompts me yes or no to confirm the delete. Has anyone created a maintenance script that handles the prompt? In 9i you can turn the prompt off.

rucknrun

Report message to a moderator

Re: RMAN Maintenance [message #121319 is a reply to message #121308]

Fri, 27 May 2005 10:08

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

Senior Member
Account Moderator

My apologies.
I missed your post stating that your version is 8i.

Report message to a moderator

Re: RMAN Maintenance [message #121322 is a reply to message #121319]

Fri, 27 May 2005 10:36

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

Senior Member
Account Moderator

i dont have an 8i instance around. So i cannot test anything.
Still, you can use this method.
http://download-west.oracle.com/docs/cd/A87860_01/doc/server.817/a76990/rmansy20.htm#47558

Deleting Expired Backups

The following example checks the media manager for expired backups of the tablespace USER_DATA that are more than one month old and removes their catalog records:

crosscheck backup of tablespace user_data completed before 'SYSDATE-31';
delete expired backup of tablespace user_data' completed before 'SYSDATE-31';
release channel;

[Updated on: Fri, 27 May 2005 10:37]

Report message to a moderator

Re: RMAN Maintenance [message #121361 is a reply to message #121322]

Fri, 27 May 2005 14:48

rucknrun
Messages: 26
Registered: April 2005
Location: Edgewood, MD

Junior Member

I just can't figure out how to handle the prompt in a shell script in 8i. I know the syntax if I log in and do it manually.

Report message to a moderator

Previous Topic:	Question releted to Export of full Database
Next Topic:	how to recovery database from tape to test db

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Fri Apr 26 16:03:18 CDT 2024