Oracle DBA (12c/19c) Articles and Scripts

  Hello Friend's, In This Post we will discuss about how to migrate database from 12.2 Noncdb to 19c PDB So let's get started Source : Hostname : dm01db12c.database.com Database : OTM8P Version : 12.2.0.1 CDB/PDB : NON CDB/PDB Oacle_Home : /oracle/app/orawork/product/12.2.0.1/db_1 Target : Hostname : dm01db12c.database.com Database : CDBOTM8P Version : 19.0.0.0 CDB/PDB : Yes Oacle_Home : /oracle/app/orawork/product/19.0.0.0/db_1 Create Tables to check after the migration : [oracle@dm01db12c ~]$ sqlplus / as sysdba SQL*Plus: Release 12.2.0.1.0 Production on Fri Jul 10 19:33:15 2020 Copyright (c) 1982, 2016, Oracle. All rights reserved. Connected to: Oracle Database 12c Enterprise Edition Release 12.2.0.1.0 - 64bit Production SQL> set pages 9999 lines 300 col OPEN_MODE for a10 col HOST_NAME for a30 select name DB_NAME,HOST_NAME,DATABASE_ROLE,OPEN_MODE,log_mode,version DB_VERSION,LOGINS,to_char(STARTUP_TIME,'DD-MON-YYYY HH24:MI:SS') "DB UP TIME...

Hello Friend's In this post we will discuss about  Switchover and Switchback procedure simplified in Oracle 12c. Check the below link for steps to create Standby for 2 node rac : CREATING SINGLE INSTANCE PHYSICAL STANDBY FOR A RAC PRIMARY The following is used in the Switchover scenario: 2 instances Oracle 12c RAC primary database (Findb) Single instance Oracle 12c RAC Standby database (Findr) Step 1 : Status of database (Primary & Standby) SQL> select status,instance_name,database_role from v$database,v$instance; STATUS INSTANCE_NAME DATABASE_ROLE ------------ ---------------- ---------------- OPEN Findb1 PRIMARY SQL> select status,instance_name,database_role from v$database,v$instance; STATUS INSTANCE_NAME DATABASE_ROLE ------------ ---------------- ---------------- OPEN Findr PHYSICAL STANDBY 1.1) Check the log diff : SQL> SELECT ARCH.THREAD# "Thread", ARCH.SEQUENCE# "Last Sequence Received",...