| RMAN Duplicate taking long to finish. [message #524818] |
Tue, 27 September 2011 01:53  |
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 #524960 is a reply to message #524854] |
Wed, 28 September 2011 01:26  |
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
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
