In Standby database, if some archive logs are missing (could not be transferred), then how do you recover?
If you are missing archived redo logs, then your Standby database will not be in a consistent state. Even if you were able to skip over the missing log files, some transactions in the new archived redo log files may have a dependency on the missing redo log files. So in this case, you should recreate your Standby from a good backup of your production database. Then apply all archived redo logs since that backup. You might need to generate a new backup of your production database if your most recent backup was taken at some point in time before your missing redo logs were generated.
Dig Deeper on Oracle database administration
Oracle expert Brian Peasland answers one reader's question about common pitfalls when connecting Oracle to outside programs.
One reader asks expert Brian Peasland a question about datafile sizes with the Oracle RMAN duplicate 10g command.
Managing parent table-child table relations in Oracle SQL environments is key to efficient programming.