In Oracle 12.2 a lot of new features are introduced for Multitenant 12.2 environments
One of the possibility is to clone a pluggable databases while they are open for read/write operations.
When we want to do this in a MAA environment this will introduce some problems
Data Guard Impact on Oracle Multitenant Environments (Doc ID 2049127.1)
For this Oracle has some new parameters which can be used to overcome these problems
the parameter "standby_pdb_source_file_dblink"
Showing posts with label MAA. Show all posts
Showing posts with label MAA. Show all posts
Monday, September 24, 2018
Wednesday, November 4, 2009
Installing and Using Standby Statspack in 11g (by active Data Guard)
Statspack cannot be executed on a standby Database due to its read-only nature therefore tuning the performance of the apply process involves manually collecting statistics.
In the new Active Data Guard option, users can now use statspack from the primary database to collect data from a standby database that is opened read-only and performing recovery. The standby statspack is installed in a separate schema on the Primary database, STDBYPERF which is then propagated to the standby. This user "STDBYPERF" user does not have DBA privileges and has no access to local V$ tables.
In the new Active Data Guard option, users can now use statspack from the primary database to collect data from a standby database that is opened read-only and performing recovery. The standby statspack is installed in a separate schema on the Primary database, STDBYPERF which is then propagated to the standby. This user "STDBYPERF" user does not have DBA privileges and has no access to local V$ tables.
Subscribe to:
Posts (Atom)