Hi, I'm on Oracle 10g with Solaris 10
I had successfully cloned a prod database to a new server but the underlying SAN had to be reconfigured, so I am trying to clone it down again.
To backup, I am using:
backup database tag='SBX_PROD_DBNAME' format '/archive/stage/PROD_DBNAME/%U';
backup archivelog all format '/archive/stage/PROD_DBNAME/%U';
sql "alter system archive log current";
backup current controlfile format '/archive/stage/PROD_DBNAME/%U';
Then to clone:
set until time ...
duplicate taget database to "SBX"
Nothing too complex, and we have successfully run it before. I look at the backup log and it ran successfully with all of the same information as the one that worked previously.
However, when I run the clone script I recieve:
ORA-19870 error reading backup piece /archive/flash_recovery_area <-- This should be /archive/stage
ORA-19505 failed to identify (same as above, wrong location)
The strange thing is, the only thing I have changed in the scripts is the set until time. Everything else is the same as what ran successfully before as far as I can tell.
If anyone could tell me what I should be looking at, I would really appreciate it. I apologize if it's something obvious but I am stumped/at a loss. A direction would really help me out because right now I have none.