Differential backup

[Mimas]

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;

thanks

[Mimas]

I have tried :
RMAN> backup database with differential;

RMAN-00571: ===========================================================
RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
RMAN-00571: ===========================================================
RMAN-00558: error encountered while parsing input commands
RMAN-01005: syntax error: found "identifier": expecting one of: "archivelog, backup, backupset, channel, controlfilecopy, current, database, datafile, datafilecopy, delete, diskratio, filesperset, format, force, include, keep, (, maxsetsize, noexclude, nokeep, not, parms, pool, plus, ;, skip, spfile, setsize, tablespace, tag"
RMAN-01008: the bad identifier was: with
RMAN-01007: at line 1 column 17 file: standard input

WITH is not correct.

Does anyone knows the syntax of this command?

[davey23uk]

what the hell is differential?


you do man an incremental backup?

[PAVB]

Does anyone knows the syntax of this command?

How about checking Oracle documentation?

You can start here...

http://download.oracle.com/docs/cd/B...7.htm#CHDECGDC

[Mimas]

If I have the following:
--Weekly full backup--
backup incremental level 0 database plus archivelog delete all input;
-- Daily backup --
backup incremental level 1 database plus archvielog delete all input;

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?

[PAVB]

About archivelogs...
Yes, you will need your archivelogs during a restore... that's why you are backing them up.

About RMAN Restore syntax...
Why don't you check Oracle documentation? http://www.acs.ilstu.edu/docs/Oracle...1.htm#RCMRF149

[Mimas]

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.

[PAVB]

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.

[gopu_g]

Mimas,

Incremental backups are differential by default.

Check this link.....

http://download-uk.oracle.com/docs/c...92/bkup004.htm