Saturday, May 24, 2025

How to register database in recovery catalog ?

[oracle@orcl ~]$

[oracle@orcl ~]$

[oracle@orcl ~]$ rman target / catalog  rcatowner/oracle_4U@demopdb1


Recovery Manager: Release 19.0.0.0.0 - Production on Sat May 24 15:07:56 2025

Version 19.3.0.0.0


Copyright (c) 1982, 2019, Oracle and/or its affiliates.  All rights reserved.


connected to target database: DB1 (DBID=1788905834)

connected to recovery catalog database


RMAN> register database ;


database registered in recovery catalog

starting full resync of recovery catalog

full resync complete


RMAN>

How to create recovery catalog ?

 


[oracle@orcl ~]$

[oracle@orcl ~]$ sqlplus "/as sysdba"


SQL*Plus: Release 19.0.0.0.0 - Production on Sat May 24 14:41:25 2025

Version 19.3.0.0.0


Copyright (c) 1982, 2019, Oracle.  All rights reserved.



Connected to:

Oracle Database 19c Enterprise Edition Release 19.0.0.0.0 - Production

Version 19.3.0.0.0



SQL> show pdbs


    CON_ID CON_NAME                       OPEN MODE  RESTRICTED

---------- ------------------------------ ---------- ----------

         2 PDB$SEED                       READ ONLY  NO

         3 DEMOPDB1                       MOUNTED

SQL> alter pluggable database demopdb1 open read write ;


Pluggable database altered.


SQL> show con_name


CON_NAME

------------------------------

CDB$ROOT

SQL>





SQL> alter session set container =demopdb1;


Session altered.




SQL> create tablespace rcat datafile '/u01/app/oracle/oradata/DB2/rcat.dbf' size 15M;


Tablespace created.


SQL>



SQL>

SQL> CREATE USER rcatowner IDENTIFIED BY oracle_4U

TEMPORARY TABLESPACE temp

DEFAULT TABLESPACE rca  2    3  t

QUOTA UNLIMIT  4  ED ON rcat;


User created.




SQL> grant recovery_catalog_owner to rcatowner;


Grant succeeded.


SQL>



[oracle@orcl ~]$

[oracle@orcl ~]$

[oracle@orcl ~]$ rman


Recovery Manager: Release 19.0.0.0.0 - Production on Sat May 24 14:54:57 2025

Version 19.3.0.0.0


Copyright (c) 1982, 2019, Oracle and/or its affiliates.  All rights reserved.


RMAN> connect catalog rcatowner/oracle_4U@demopdb1


connected to recovery catalog database


RMAN> create catalog;



recovery catalog created


RMAN>

RMAN>




How to create tablespace in oracle database ?

 

SQL>

SQL>  create tablespace rcat datafile '/u01/app/oracle/oradata/DB2/rcat.dbf' size 15M;


Tablespace created.


SQL>

How to drop tablespace in oracle database ?

 



SQL> DROP TABLESPACE rcat INCLUDING CONTENTS AND DATAFILES;


Tablespace dropped.


SQL>