Avatar of eugeneca
eugeneca
 asked on

Oracle RMAN

Plan to use Oracle 11g R2 on SUSE Linux 11 r2.  For now, I'll use an external hard drive for backup.  Say, I attach the HD via a USB to the database server.  

Can I use RMAN to schedule a backup that will copy the data over to the external HD (from the FRA)?  For instance, I schedule 2:00am daily, to transfer the incremental data, and 2:00am weekly, transfer the full backup copy to the external HD, etc.


Thanks to help.
Oracle DatabaseStorage Software

Avatar of undefined
Last Comment
Praveen Kumar Chandrashekatr

8/22/2022 - Mon
SOLUTION
Praveen Kumar Chandrashekatr

Log in or sign up to see answer
Become an EE member today7-DAY FREE TRIAL
Members can start a 7-Day Free trial then enjoy unlimited access to the platform
Sign up - Free for 7 days
or
Learn why we charge membership fees
We get it - no one likes a content blocker. Take one extra minute and find out why we block content.
Not exactly the question you had in mind?
Sign up for an EE membership and get your own personalized solution. With an EE membership, you can ask unlimited troubleshooting, research, or opinion questions.
ask a question
Gerwin Jansen

Well, it should be possible but your backup will be very slow depending your database size, see this reference: https://forums.oracle.com/forums/thread.jspa?threadID=1129681

I'd think you better create the backup on a local disk and move the backup to your USB device after the backup has finished.
eugeneca

ASKER
Quote:"I'd think you better create the backup on a local disk".

Q: Is the FRA sufficient to serve the purpose?

(I would like the ORACLE to first automatically back it up to the FRA, then use RAMN to transfer it to the external HD via USB.)
ASKER CERTIFIED SOLUTION
Praveen Kumar Chandrashekatr

Log in or sign up to see answer
Become an EE member today7-DAY FREE TRIAL
Members can start a 7-Day Free trial then enjoy unlimited access to the platform
Sign up - Free for 7 days
or
Learn why we charge membership fees
We get it - no one likes a content blocker. Take one extra minute and find out why we block content.
Not exactly the question you had in mind?
Sign up for an EE membership and get your own personalized solution. With an EE membership, you can ask unlimited troubleshooting, research, or opinion questions.
ask a question
All of life is about relationships, and EE has made a viirtual community a real community. It lifts everyone's boat
William Peck