DB 19 – recovery catalog

Przygotowanie home-a, rozpakowanie instalek, patchy itp. (użyszkodnik: oracle)

mkdir -p /u01/app/oracle/product/19/dbhome_1
unzip /u01/install/V982063-01-19.3_DB.zip -d /u01/app/oracle/product/19/dbhome_1/
mkdir -p /u01/app/oracle/product/19/dbhome_1/patch/RU
unzip /u01/install/p33192793_190000_Linux-x86-64_patch_RU_DB_19.13.zip -d /u01/app/oracle/product/19/dbhome_1/patch/RU
rm -rf /u01/app/oracle/product/19/dbhome_1/OPatch/*
unzip /u01/install/p6880880_210000_Linux-x86-64 -d /u01/app/oracle/product/19/dbhome_1/

Instalacja (aplikowanie RU) i tworzenie DB:

cd /u01/app/oracle/product/19/dbhome_1
./runInstaller -applyRU patch/RU/33192793
./dbca

Tworzymy schemat rcat-a:

ORACLE_HOME=/u01/app/oracle/product/19/dbhome_1
export ORACLE_SID=rcat19
sqlplus / as sysdba
SQL> CREATE TABLESPACE RECOVERY_CATALOG DATAFILE
’/u01/app/oracle/oradata/RCAT19/recovery_catalog01.dbf’ SIZE 100M AUTOEXTEND ON NEXT 100M MAXSIZE 30G
LOGGING
DEFAULT
NO INMEMORY
ONLINE
EXTENT MANAGEMENT LOCAL AUTOALLOCATE
BLOCKSIZE 8K
SEGMENT SPACE MANAGEMENT AUTO
FLASHBACK ON;
SQL> CREATE USER rman IDENTIFIED BY Passwd
DEFAULT TABLESPACE RECOVERY_CATALOG
QUOTA UNLIMITED ON RECOVERY_CATALOG;
GRANT recovery_catalog_owner TO rman;
alter user rman profile tech; — najlepiej taki, który nie wygasa

Tworzymy „katalog” rcatowy

/u01/app/oracle/product/19/dbhome_1/bin/rman
RMAN> connect catalog rman@rcat19
RMAN> create catalog;

Rejestrujemy bazę w katalogu:

RMAN> connect target /
RMAN> connect catalog rman/Passwd@rcat19

RMAN> register database;
database registered in recovery catalog
starting full resync of recovery catalog
full resync complete