Take the 2-minute tour ×
Database Administrators Stack Exchange is a question and answer site for database professionals who wish to improve their database skills and learn from others in the community. It's 100% free, no registration required.

I'm trying to learn RMAN but getting confused everytime I read Oracle docs!

Can someone help me what are the differences and when to use the following?

BACKUP DATABASE PLUS ARCHIVELOG DELETE INPUT

BACKUP FULL

Which came from:

run{
backup full tag='INC000000325026'
(database format='/u04/backups/paris/rman/%d_%U_%T' include current controlfile);
}


run{
ALLOCATE CHANNEL d1 DEVICE TYPE DISK FORMAT '/u01/backups/rman/%d_%U_%T';
BACKUP DATABASE PLUS ARCHIVELOG DELETE INPUT TAG ='FRISK_DB';
}

I want/need to take a cold full backup of a database in a simple way, so which one is suitable?

share|improve this question

1 Answer 1

up vote 3 down vote accepted

A Cold Backup is making a copy of the files with the database closed. These commands are both for hot backups using RMAN. They are both preferred over cold backups due to their flexibility.

The difference between the two commands is whether or not archive logs are backed up. If you need be able to recover to any point between your backups or anytime after your most recent backup, then you will need to be in archivelog mode. If you are in archivelog mode then something needs to be done to backup those archive logs and use should use the PLUS ARCHIVELOG syntax.

It is advisable to periodically test a recovery as well to make sure your backups are working and you can recover.

share|improve this answer

Your Answer

 
discard

By posting your answer, you agree to the privacy policy and terms of service.

Not the answer you're looking for? Browse other questions tagged or ask your own question.