If this is your first visit, be sure to
check out the FAQ by clicking the
link above. You may have to register
before you can post: click the register link above to proceed. To start viewing messages,
select the forum that you want to visit from the selection below.

Differential backup

hello all,

I have created a script for taking a full backup together with archive logs using RMAN.
Now I wish to take differential backup as well.
How do I do that? Is there any command from RMAN to take differential backup such us
RMAN> backup database with differential;

Disclaimer: Advice is provided to the best of my knowledge but no implicit or explicit warranties are provided. Since the advisor explicitly encourages testing any and all suggestions on a test non-production environment advisor should not held liable or responsible for any actions taken based on the given advice.

By having the above backups all the archivelogs after the backup will be deleted.
What about when I will need to do a restore, don't I need the archivelogs as well and how to do a restore is RMAN>restore database; is ok?

Disclaimer: Advice is provided to the best of my knowledge but no implicit or explicit warranties are provided. Since the advisor explicitly encourages testing any and all suggestions on a test non-production environment advisor should not held liable or responsible for any actions taken based on the given advice.

so the "delete all input;" at the end why is used?
does it take archive logs (to use them in case of restore/recover)?
I am asking because after the backup commands and delete all input; at the end I do not see the archivelogs just the backup files but when I do not put this at the end the archives appears.

so the "delete all input;" at the end why is used?
does it take archive logs (to use them in case of restore/recover)?
I am asking because after the backup commands and delete all input; at the end I do not see the archivelogs just the backup files but when I do not put this at the end the archives appears.

Please read the documentation; all of your questions are answered there.
You shouldn't be asking RMAN or any other tool to do stuff for you if you do not understand how they work and what are you asking for.

Disclaimer: Advice is provided to the best of my knowledge but no implicit or explicit warranties are provided. Since the advisor explicitly encourages testing any and all suggestions on a test non-production environment advisor should not held liable or responsible for any actions taken based on the given advice.