Home » RDBMS Server » Backup & Recovery » RMAN Duplicate set until time using wrong backup piece name to restore. (10.2.0.4)
RMAN Duplicate set until time using wrong backup piece name to restore. [message #545032] Sun, 26 February 2012 22:01 Go to next message
dloresco
Messages: 6
Registered: February 2009
Location: Singapore
Junior Member
We are doing RMAN Duplicate set until time to refresh daily our test database for our developers and it taking long time to finish. We noticed on the restore log that RMAN was using a day old old backup pieces to refresh the test database and don't immediately use the latest backup pieces instead.

For additional details here's the rman duplicate command we are using which we run daily(mon-sat) at 4am once daily full backup on production completed.

RMAN Duplicate commands:
run
{
set until time "to_date(to_char(sysdate,'Mon DD YYYY') || ' 04:00:00', 'Mon DD YYYY HH24:MI:SS')";
allocate auxiliary channel ch1 type disk;
duplicate target database to testdb;
}
exit

Is there a way on how to let RMAN use the latest backup pieces instead?..

Best Regards,
dloresco

[Updated on: Sun, 26 February 2012 22:08]

Report message to a moderator

Re: RMAN Duplicate set until time using wrong backup piece name to restore. [message #545036 is a reply to message #545032] Sun, 26 February 2012 23:18 Go to previous message
Michel Cadot
Messages: 60016
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
Quote:
RMAN was using a day old old backup pieces to refresh the test database and don't immediately use the latest backup pieces instead.


It ony uses the backup pieces it knows.
So if it uses this one this is because it does not know the other one... unless you prove us it is wrong.

Please read OraFAQ Forum Guide and How to use [code] tags and make your code easier to read.
Make sure that lines of code do not exceed 80 characters when you format.
Indent the code, use code tags and align the columns in result.
Use the "Preview Message" button to verify.

Quote:
Is there a way on how to let RMAN use the latest backup pieces instead?..


CATALOG it.

Regards
Michel
Previous Topic: Recover Database Error
Next Topic: Oracle11gR2 not allow to open database after complete recovery, asks to specify RESETLOG/NORESETLOG?
Goto Forum:
  


Current Time: Mon Dec 22 06:48:01 CST 2014

Total time taken to generate the page: 0.07018 seconds