83 lines
2.3 KiB
Plaintext
Executable File
83 lines
2.3 KiB
Plaintext
Executable File
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
|
|
~~ configurable spfile parameters
|
|
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
|
|
COLUMN name FORMAT A35
|
|
COLUMN value FORMAT A35
|
|
|
|
SELECT name, value
|
|
FROM v$system_parameter
|
|
WHERE ispdb_modifiable = 'TRUE'
|
|
ORDER BY name;
|
|
|
|
~~~~~~~~~~~~~~~~~~
|
|
~~ Rename of a PDB
|
|
~~~~~~~~~~~~~~~~~~
|
|
~~ rename PDB database from JABBAPRD to ZAX
|
|
alter pluggable database JABBAPRD close immediate;
|
|
alter pluggable database JABBAPRD open restricted;
|
|
alter session set container=JABBAPRD;
|
|
alter pluggable database rename global_name to ZAX;
|
|
alter pluggable database ZAX close immediate;
|
|
alter pluggable database ZAX open;
|
|
alter pluggable database ZAX save state;
|
|
|
|
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
|
|
~~ Switch a CDB in LOCAL_UNDO mode
|
|
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
|
|
|
|
~~ check if LOCAL_UNDO is enable
|
|
COLUMN property_name FORMAT A30
|
|
COLUMN property_value FORMAT A30
|
|
|
|
SELECT property_name, property_value
|
|
FROM database_properties
|
|
WHERE property_name = 'LOCAL_UNDO_ENABLED';
|
|
|
|
|
|
|
|
~~ disable cluster_database and stop the database
|
|
alter system set cluster_database=false scope=spfile sid='*';
|
|
srvctl stop database -db HUTTPRD
|
|
|
|
~~ start just one instance in upgrade mode
|
|
startup upgrade;
|
|
~~ enable LOCAL_UNDO
|
|
alter database local undo ON;
|
|
|
|
~~ enable cluster_database and start the database
|
|
alter system set cluster_database=true scope=spfile sid='*';
|
|
|
|
~~ stop the instance and start database
|
|
srvctl start database -db HUTTPRD
|
|
|
|
~~~~~~~~~~~~~~~~~~
|
|
~~ Refreshable PDB
|
|
~~~~~~~~~~~~~~~~~~
|
|
|
|
~~ context
|
|
~~ source ZAX@HUTTPRD(on vortex-scan)
|
|
~~ target HARRA@BOTHAN(on kessel-scan)
|
|
|
|
~~ on source HUTTPRD
|
|
CREATE USER c##kaminoan IDENTIFIED BY secret CONTAINER=ALL;
|
|
GRANT CREATE SESSION, CREATE PLUGGABLE DATABASE TO c##kaminoan CONTAINER=ALL;
|
|
|
|
~~ on target BOTHAN
|
|
CREATE DATABASE LINK kaminoan_link
|
|
CONNECT TO c##kaminoan IDENTIFIED BY secret USING 'vortex-scan/HUTTPRD';
|
|
|
|
select * from dual@kaminoan_link;
|
|
|
|
create pluggable database HARRA from ZAX@kaminoan_link parallel 2 refresh mode manual;
|
|
alter pluggable database HARRA open read only instances=ALL;
|
|
|
|
SELECT status, refresh_mode FROM dba_pdbs WHERE pdb_name = 'HARRA';
|
|
|
|
~~ to perform a refresh
|
|
alter pluggable database HARRA close immediate instances=ALL;
|
|
alter pluggable database HARRA refresh;
|
|
alter pluggable database HARRA open read only instances=ALL;
|
|
|
|
|
|
|