It can soud repetitive, but always good to have notes about 🙂
- Create Schema for Catalog on CatalogDB:
-- Create the user create user RMAN_MYDB identified by &PASS; -- Grant/Revoke role privileges grant recovery_catalog_owner to RMAN_MYDB; -- Grant/Revoke system privileges grant create session to RMAN_MYDB;
2. Create catalog and register database:
-- Conected to target Database via RMAN RMAN> connect catalog rman_mydb/password@catdb.grepora.net:1521/catalogdb connected to recovery catalog database RMAN> CREATE CATALOG; recovery catalog created RMAN> REGISTER DATABASE; database registered in recovery catalog starting full resync of recovery catalog full resync complete
Well done!
Matheus.