Posts

Showing posts from December, 2023

Creating a Physical Standby database from Primary database service

RMAN 'from service' clause enables the restore and recover of primary database files to a standby database  through an Oracle Net connection. Hosts and databases used in this environment. Sites Primary Standby DR Hosts srvdb02.localdomain srvdb03.localdomain Database Unique Name orcl orcldr Action on Primary database. 1. Enable archive and force logging mode on Primary. [oracle@srvdb02 ~]$ sqlplus / as sysdba   SQL*Plus: Release 19.0.0.0.0 - Production on Sat Dec 16 15:48:06 2023 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> startup mount; ORACLE instance started. Total System Global Area   620756648 bytes Fixed Size                 ...

Recover - Dropped Pluggable database (PDB2) with an available RMAN backup

--Environment looks as below:   [oracle@srvdb01 ~]$ sqlplus / as sysdba SQL*Plus: Release 19.0.0.0.0 - Production on Sat Dec 9 18:57:10 2023 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> select name,cdb from v$database; NAME      CDB --------- --- ORCL      YES   SQL> show pdbs;     CON_ID CON_NAME                       OPEN MODE  RESTRICTED ---------- ------------------------------ ---------- ----------          2 PDB$SEED                       READ ONLY  NO          3 PDB1                           READ WR...