OraFAQ Forum: Backup & Recovery » what diffrence between 'delete input' and 'change xxx delete'

Home » RDBMS Server » Backup & Recovery » what diffrence between 'delete input' and 'change xxx delete' (9i to 11g)

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

what diffrence between 'delete input' and 'change xxx delete' [message #476288]

Wed, 22 September 2010 09:10

edgefree
Messages: 30
Registered: July 2010
Location: Toronto

Member

Hi Gurus,

I have a question about delete archived log in RMAN after backed up them. I found at least 2 methods to do it.
1. RMAN > Backup archive log xxxx;
RMAN > Change archived log from xxx until xxx delete;
2. RMAN > Backup archive log all delete input;

What is the difference of them? If they do same job, which one is better during backup?

Thanks!
Edgy

Report message to a moderator

Re: what diffrence between 'delete input' and 'change xxx delete' [message #476291 is a reply to message #476288]

Wed, 22 September 2010 09:12

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

Senior Member
Account Moderator

1. backup log(s) you mentioned, 2. backup all archived logs and then delete them.

No one is better, each one does something different.

Regards
Michel

Report message to a moderator

Re: what diffrence between 'delete input' and 'change xxx delete' [message #476303 is a reply to message #476291]

Wed, 22 September 2010 09:51

edgefree
Messages: 30
Registered: July 2010
Location: Toronto

Member

Thank you Michel for explanation. So that means no any prefeable solution from Oralce view, as I prefer to the 2nd one since it does deletetion job on one statement and ganrentee that deleted files are backed up.

Report message to a moderator

Re: what diffrence between 'delete input' and 'change xxx delete' [message #476307 is a reply to message #476303]

Wed, 22 September 2010 09:58

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

Senior Member
Account Moderator

It guarantees that RMAN receives an acknowlegment from the target "device" that the logs are backed up.
It does not guarantee that the backup itself is correct.

Regards
Michel

Report message to a moderator

Re: what diffrence between 'delete input' and 'change xxx delete' [message #476319 is a reply to message #476307]

Wed, 22 September 2010 10:22

edgefree
Messages: 30
Registered: July 2010
Location: Toronto

Member

Yes, you are right. Only ganrantee is the file is backed up.

If wants to know if the backup itself is correct, the only way is do validation, right?

Report message to a moderator

Re: what diffrence between 'delete input' and 'change xxx delete' [message #476325 is a reply to message #476319]

Wed, 22 September 2010 10:41

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

Senior Member
Account Moderator

Afaik, the two ways are use VALIDATE command and really restore the backup.

Regards
Michel

Report message to a moderator

Previous Topic:	control file autobackup format changing
Next Topic:	Rman Backup

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Sun Dec 22 12:43:13 CST 2024