Printable View
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
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?
what the hell is differential?
you do man an incremental backup?
How about checking Oracle documentation?Quote:
Originally Posted by Mimas
You can start here...
http://download.oracle.com/docs/cd/B...7.htm#CHDECGDC
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?
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
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.Quote:
Originally Posted by Mimas
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.
Mimas,
Incremental backups are differential by default.
Check this link.....
http://download-uk.oracle.com/docs/c...92/bkup004.htm