Home » Server Options » RAC & Failsafe » RMAN Duplicate taking long to finish. (Oracle 10G, 10.2.0.4, AIX 5.3)
RMAN Duplicate taking long to finish. [message #524818] Tue, 27 September 2011 01:53 Go to next message
dloresco
Messages: 6
Registered: February 2009
Location: Singapore
Junior Member
Hi,

Just want to solicit for some expert advise on how can we tune our RMAN Duplicate as it was taking 10+ hours to finish. Here's some details which might help you analyze the issue:

Current production database size is 800GB.
Approx duration of rman online backup (FULL, including archived logs) is 4 to 5 hours.

Here's the rman backup script we used:
sql 'alter system archive log current';
list archivelog all;
run
{
show all;
report schema;
backup database plus archivelog delete all input;
}
exit

Here's the rman duplicate command we used:
run
{
set until time "to_date(to_char(sysdate,'Mon DD YYYY') || ' 02:30:00', 'Mon DD YYYY HH24:MI:SS')";
allocate auxiliary channel ch1 type disk;
duplicate target database to testdb;
}
exit

Thanks in advance..

~DLoresco
Re: RMAN Duplicate taking long to finish. [message #524830 is a reply to message #524818] Tue, 27 September 2011 02:38 Go to previous messageGo to next message
Michel Cadot
Messages: 68625
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
For 800GB and your backup time I don't see anything strange in your duplicate time.
It is even quite fast comparing to your backup time.

Regards
Michel
Re: RMAN Duplicate taking long to finish. [message #524854 is a reply to message #524818] Tue, 27 September 2011 04:11 Go to previous messageGo to next message
John Watson
Messages: 8922
Registered: January 2010
Location: Global Village
Senior Member
Do you have Enterprise Edition licenses? If so, you could try allocating several channels to do the backup and restore in parallel.
Re: RMAN Duplicate taking long to finish. [message #524960 is a reply to message #524854] Wed, 28 September 2011 01:26 Go to previous message
dloresco
Messages: 6
Registered: February 2009
Location: Singapore
Junior Member
Thanks for the reply John, it was highly appreciated.. Yes we are under enterprise edition license... We will look on it how to implement multiple channels as you have suggested.. Cheers!..

~DLoresco
Previous Topic: RAC failed during running root.sh in second node
Next Topic: racgmain process on a rac node
Goto Forum:
  


Current Time: Fri Mar 29 08:39:09 CDT 2024