Pages: 2
Rating : ⭐⭐⭐⭐⭐
Price: $10.99
Page 1 Preview
logapply services require memory the shared pool

Log-apply services require memory the shared pool


Chapter 23

begin sys.dbms_logmnr_d.set_tablespace('log_ts'); end;


create spfile from pfile;

The logical standby can be cloned from the primary either following a clean shut-down of the primary or while the primary database is up and running. If the primary is to remain up, the database Resource Manager must be running. This can be enabled using the following SQL:

Protecting Data Using Standby Databases


To ensure the fastest application of redo on the standby, log-apply services require memory in the shared pool, and the use of parallel query. By default, 25 percent of SGA memory on the standby is allocated for redo-apply operations. Therefore, considera-tion should be given to increasing the SGA on the standby instance compared with that on the primary. The APPLY_SET procedure in the DBMS_LOGSTDBY package is used to control resource allocation. The following command restricts the SGA usage for redo log application on the standby to the specified limit:



Creating the Logical Standby

The logical standby database must be based on a copy of the primary. This copy can be taken either following a clean shutdown of the primary (using either SHUTDOWN or SHUTDOWN IMMEDIATE) or while the primary database is up.

You are viewing 1/3rd of the document.Purchase the document to get full access instantly

Immediately available after payment
Both online and downloadable
No strings attached
How It Works
Login account
Login Your Account
Place in cart
Add to Cart
send in the money
Make payment
Document download
Download File

Uploaded by : Jamie Anderson

PageId: ELIADC86D9