07-06-2018 04:43 AM - edited 07-06-2018 04:48 AM
07-06-2018 05:45 AM
If I look at your screenshots, it seems that you specified a Daily backup policy for the control file restore, but then specified a Monthly policy for the database restore.
When did the last successful Monthly backup run?
And why do you want to restore from different backup sets?
Why even specify a policy for the restore?
In the last screenshot, we see backed-up datafiles for a Daily backup.
Please try again without the policy name.
PS:
Please try to post text output rather than screenshots?
It just makes it easier for us to copy&paste when we want to point out where the mistake might be.
07-06-2018 06:32 AM
You also use the bplist command to verify files are in place. The command is a bit picky with it arguments but command below shoudl work. Remember to be root if you run the bplist command on the oracle host itself.
e.g.:
bplist -B -C ora.acme.com -R -l -t 4 -s 01/01/2015 /
-s is the start date
-C oracle host
07-06-2018 09:32 AM
Hi
When did the last successful Monthly backup run?
-Monthly backup run successful on 01/07/2018
different backup sets?
-Sorry, the picture restores control file and picture restores datafile incorrectly.
I use the same policy restore control and datafile but still the same error.
-Why even specify a policy for the restore?
I do not specify the policy, but the same error.
and I try to test that the problem is not at policy MONTHLY.
thank you.
07-06-2018 09:35 AM
07-09-2018 07:42 AM
Hello,
some points:
- your RMAN list command above shows that only some datafiles were backed up (file numbers 3,8,11, etc., ). But maybe it is only one part of the whole backup (one stream). RMAN logs for original backups would be very useful if you have any. If it was Intelligent Oracle policy, it is contained in parent backup job. If it was not, it could be on Oracle client in NetBackup Log directories
- as above stated do not specify Policy in RMAN unless you want to restore a certain older backup
- bplist command is not very useful for this situation because it does not show backup content from Oracle point of view
- consult an Oracle DBA if you have any. Oracle restore scenarios are one of the most complex
Regards
Michal
07-09-2018 08:31 AM