Database Reference
In-Depth Information
■
ALTER DATABASE [START|STOP] LOGICAL STANDBY APPLY
■
ALTER DATABASE GUARD
(Oracle strongly recommends you do
not
use it on a logical
standby).
Standby Considerations When Removing or Renaming a PDB at a Primary
If the primary database is a CDB and you're renaming or removing one of its PDBs, the
PDB must be closed on the primary and all standby databases to perform
UNPLUG
and
DROP
.
To
RENAME
a PDB it must first be put in open restricted mode on the primary and closed on
all standby databases. In the following code example,
LNE6
is a PDB in the primary CDB.
SQL> alter pluggable database open restricted;
Pluggable database altered.
SQL> alter pluggable database lne6 rename global_name to lne7;
Pluggable database altered.
SQL> show con_name
CON_NAME
------------------------------
LNE7
SQL> select name, open_mode from v$pdbs;
NAME OPEN_MODE
------------------------------ ----------
LNE7 READ WRITE
Before removing or renaming a PDB at the primary database, you must close the PDB
at the standby. Otherwise, the standby will stop recovery for all PDBs, and you will need to
close the dropped PDB at the standby and recover the standby database from the
CDB$ROOT
,
as in this example:
SQL> ALTER DATABASE RECOVER MANAGED STANDBY DATABASE;
Using LogMiner to Analyze Redo Log Files
Oracle LogMiner is a tool you use as a SQL interface to query online and archived redo log
files, which contain information about the history of activity on a database. The redo log
files record all changes made to data or to the database dictionary. The purpose of the redo
log files is to enable database recovery operations. LogMiner can be used as a powerful
Search WWH ::
Custom Search