A database of that size shouldn't take more than an hour or two to
backup to disk.
Some suggestions:
1. As per Joaquin's comment, set-up multiple channels to maximize your
disk throughput.
2. Your FORMAT clause appears malformed. The "Oracle " before the
directory destination should be removed.
3. Check that "/backup" is on a different filesystem and disk group to
your datafiles. Not only is there little point backing up onto the same
disks, it can hurt your performance badly.
Also, do a "SHOW ALL" from RMAN to show all your parameters and post
them here...
Peter Moore
Oracle DBA
Tel: +44 (0)1784 447329
Del Monte UK, Del Monte
-----Original Message-----
From: YIF
[mailto:oracledba-ezmlmshield-x30809244.[Email address protected]
Sent: 24 September 2007 19:52
To: LazyDBA Discussion
Subject: RMAN Question
Dear All
I'm trying to take full rman backup of my Database, but the Backup takes
4
days to complete, the size of my database is 113GB.
the backup is going on the same sun machine which hosts the database.
Here is my RMAN script.
I very much appreciate any input
rman target/ nocatalog
backup device type disk format 'Oracle /backup/%U' database plus
archivelog;
Thanks in advance
---------------------------------------------------------------------
TO REPLY TO EVERYBODY , PLEASE CLICK REPLY-ALL, NOT JUST REPLY
To post a dba job: http://jobs.lazydba.com
To Subscribe : http://www.LazyDBA.com
To unsubscribe: http://www.lazydba.com/unsubscribe.html
______________________________________________________________________________________
The information contained in this message may be privileged
and confidential and protected from disclosure. If the reader
of this message is not the intended recipient, or an employee
or agent responsible for delivering this message to the
intended recipient, you are hereby notified that any reproduction,
dissemination or distribution of this communication is strictly
prohibited. If you have received this communication in error,
please notify us immediately by replying to the message and
deleting it from your computer. Thank you.
Oracle LazyDBA home page