What is Data Guard log shipping?
Data Guard is premised on shipping the archived logs from the primary to the standby database server and applying them to the database. One of the key components of the time lag between the primary and standby is the time to transport the archived logs.
What is Oracle log shipping?
Log shipping is the process of automating the backup of transaction log files on a primary (production) database server, and then restoring them onto a standby server.
What is MRP and RFS process in Oracle?
The remote file server (RFS) process receives redo data from the primary database either in the form of archived redo logs or standby redo logs. The managed recovery process (MRP) applies information from the archived redo logs to the standby database.
How increase RFS process in Oracle?
Automatic Gap Resolution:
- Shutdown the physical standby database.
- Determine the current sequence on the primary database.
- Perform at least three log switches on the primary database.
- Verify that the logs did not get transferred to the standby archive dest.
- Start the standby database.
What are new features in 11g Data Guard?
In 11gR2, two additional features were added as part of Active Data Guard – doing incremental backups on the physical standby with block change tracking enabled and automatic corrupt block detection and recovery.
What are the benefits of log shipping?
Advantages of Log Shipping
- Easy setup. Log shipping can be configured by using the Database Maintenance Plan Wizard.
- Standby databases can be available for read-only queries. In some environments, standby servers are used for reporting.
- Low maintenance.
- Multiple standby servers can be configured.
What are the prerequisites for log shipping?
Prerequisites. The primary database must use the full or bulk-logged recovery model; switching the database to simple recovery will cause log shipping to stop functioning. Before you configure log shipping, you must create a share to make the transaction log backups available to the secondary server.
What is LSP in Oracle Data Guard?
LSP [Logical Standby ]:It comes into play for logical dataguard only. It controls the application of archived redo log information to the logical standby database. LSP process will transform redo data into sql statements and then these sql statements will be applied to logical standby database.
How do you stop RFS process in standby database?
SQL> SELECT PROCESS, STATUS FROM V$MANAGED_STANDBY; If Redo Apply is running, cancel it as shown in the following example: SQL> ALTER DATABASE RECOVER MANAGED STANDBY DATABASE CANCEL; Shut down the standby database.
What is V database?
V$DATABASE displays information about the database from the control file. If the control file was re-created using the CREATE CONTROLFILE statement, then this column displays the date that the control file was re-created.