I'm working as a DBA in a hospital. Currently there are two servers (HP Proliant ML 370 and Oracle8i), one running as a primary server and the other working as a standby server. An archive file generated in the primary server transfers automatically to the standby server. Due to a power failure in the hospital, now archive files from the primary server are not transferring to the standby server. Kindly provide me with the solution for manually transferring the archive file from the primary server to the standby server.
Note: I have already transferred total gap archive file from primary server to standby server and started the standby server in recovery mode ("Recover managed standby database"). When I have typed the following command on the SVRMGR prompt ("alter system archive log current") the archive file that is created on the primary server does not automatically tranfer to the standby server.
To manually ship archived redo logs, use any file transfer mechanism. For instance, you can copy the missing archived redo logs to the standby database with FTP. Or, you can burn the logs to a CD or DVD and use a "sneaker-net" approach. This should only be a one-time solution as your newly generated archived redo logs should be shipped to the standby database automatically.
If your newly generated archived redo logs are not automatically shipped, then it is most likely due to a network issue or a configuration issue. Verify that your LOG_ARCHIVE_DEST_n parameters are set correctly. Also verify that you have network connectivity between the servers.
Dig Deeper on Oracle database backup and recovery
Related Q&A from Brian Peasland
Oracle expert Brian Peasland answers one reader's question about common pitfalls when connecting Oracle to outside programs. Continue Reading
One reader asks expert Brian Peasland a question about datafile sizes with the Oracle RMAN duplicate 10g command. Continue Reading
Managing parent table-child table relations in Oracle SQL environments is key to efficient programming. Continue Reading
Have a question for an expert?
Please add a title for your question
Get answers from a TechTarget expert on whatever's puzzling you.