Day: October 18, 2022

Monitor Standby Database with Lag Time Report

by

vi /home/oracle/scripts/lag_time_report_and_diskgroup_space.ksh To save the script and change its permissions, follow these steps:1. Save the script by typing `:wq` in the editor.2. Change the file permissions using the `chmod` command. Add this entry to the crontab for the oracle user:

Configure MRP in Standby

by

Add the Target Database TNS entry to the Source’s tnsnames.ora file(s) (all of them if it’s a clustered Source) Set the log_archive_dest_<#> parameter on the Source Database, as Oracle: Then enable the log_archive_dest_state_ parameter on the Source Database, as Oracle: Set fal/standby_file_management parameters on the Target Database, as Oracle: Using the db_unique_name, set log_archive_config parameter … Read more

RollForward Standby Database using rman service

by

Overview: As we are already aware that the rolling forward an physical standby database via an incremental SCN based backup method is one of the easiest way of getting your standby database with lag into sync with the primary database.The lag can be due to missing archives on the primary which haven’t been shipped or applied on the standby. In 12c, this procedure has been dramatically simplified. You can use the RECOVER … FROM SERVICE command to synchronize the physical standby database with primary database. … Read more