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 want to change to another drive due to lack of disk space.

How can I change the default location of backup files used by oracle to another drive using RMAN?

By default it's in the folder ORACLE_HOME from variables.

edit:

Found some links with problems like mine here, but they didn't help.

My script looks like this one:

run {
allocate channel d1 type disk;
allocate channel d2 type disk;
backup
format 'd:/backups/%U.bkp'
database plus archivelog;
release channel d1;
release channel d2;
}

This backup never finishes.

share|improve this question
add comment

1 Answer 1

up vote 1 down vote accepted

Some things which might help:

Don't backup into a single file.

allocate CHANNEL d1 DEVICE TYPE disk maxpiecesize 32768M format some_backup_path

Use as many channels as you can stand.

allocate CHANNEL d2 DEVICE TYPE disk maxpiecesize 32768M format some_backup_path

allocate CHANNEL d3 DEVICE TYPE disk maxpiecesize 32768M format some_backup_path

allocate CHANNEL d4 DEVICE TYPE disk maxpiecesize 32768M format some_backup_path

RMAN parallelizes based on the number of channels you allocate; each channel takes part of the work to do.

Have faster disks - both on the system being backed up AND on the system to which backups are being written. Are you backing up the database over the network? If so, you're limited by the transmission speed of the network and competing network traffic - probably database-related activity.

share|improve this answer
add comment

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.