Cold Backup and Recovery From Archivelog

Let’s have look on the steps used for Cold Backup and Recovery From Archivelog. Check the archive log status SQL> archive log list; Database log mode              No Archive Mode Automatic archival             Disabled Archive destination            USE_DB_RECOVERY_FILE_DEST Oldest online log sequence     6 Current log sequence           8 Enable the archive logs SQL> shutdown immediate; Database closed. Database dismounted. […]

Read More

Managing Tablespace in Multi-Tenant Environment Part – I

In this article, we will see how tablespaces are managed in a Multi-tenant architecture. Mainly we have 4 types of tablespaces System Tablespace. User permanent tablespace. Temporary tablespace. Undo tablespace. System tablespace must be created while creating a database using either DBCA or manually. SQL> select name,con_id from v$datafile where name like ‘%system%’; NAME CON_ID […]

Read More

Explore Instance of PDB

In a previous post, we have seen the creation of Container database and pluggable database Manually Create and configure CDB database and PDB database In this post, we will explore data dictionary views of CDB and PDB. We all are aware of DBA_, ALL_, and USER_ views.   USER_ views show information about user-specific metadata. […]

Read More

Cold Backup with Rman in Oracle

Today we are going to have look on Cold Backup. Being DBA we are aware of the importance of Backup in Oracle. Different kind of backup has a different kind of uses. Let’s have look on Cold Backup. Steps for Cold Backup SQL> create table cold_back(name varchar(100)); Table created. SQL> insert into cold_back values(‘********* DATA INSERTED […]

Read More

Convert Regular PDB to Application PDB

In this article, we will see converting regular PDB to Application PDB. Step 1: Check regular PDB SQL> SELECT con_id, name, open_mode, application_root,application_pdb, application_seed from v$containers where application_root = ‘NO’ and application_PDb = ‘NO’ and application_seed = ‘NO’; 2 3 4 CON_ID NAME OPEN_MODE APP APP APP ———- ——————————————————————————————————————————– ———- — — — 1 CDB$ROOT […]

Read More

Plugging Non-CDB to CDB

In this article, we will see how we can plug the Non-CDB database as a Pluggable Database in a Container Database. Step 1: Check non-cdb Database SQL> SELECT NAME,OPEN_MODE,CDB FROM V$DATABASE; NAME OPEN_MODE CDB ——— ——————– — NCDB READ WRITE NO Step 2: Gracefully shut down Non-CDB database and open it in READ ONLY stage […]

Read More

RMAN Recovery From Missing All Control File

Today we are going to have look on the steps which are used by “DBA” for RMAN Recovery From Missing All Control File. SQL> select dbid from v$database; DBID ———- 847839442 RMAN> show all; using target database control file instead of recovery catalog RMAN configuration parameters are: CONFIGURE RETENTION POLICY TO REDUNDANCY 1; # default […]

Read More

RMAN Backup With Archivelog

This post is  about how to take RMAN Backup With Archivelog RMAN> run { allocate channel c1 type disk; backup database; backup(archivelog all); } RMAN> backup archivelog all delete input; Note: This will backup all archivelog file and delete those from a target location. If we physically delete some archivelog file before backup then we have […]

Read More

Delete applied archivelog script

We need to delete archivelogs which are applied on standby servers. Following script will do the job for you. vi /home/oracle/crons/remove_applied_archivelog.sh #!/bin/ksh # # # Remove applied archivelog all; # # ORACLE_SID=ORCL; export ORACLE_SID ORACLE_BASE=/u01/app/oracle; export ORACLE_BASE ORACLE_HOME=$ORACLE_BASE/product/12.2.0/db_1; export ORACLE_HOME tmpfile=/tmp/arch_id.tmp $ORACLE_HOME/bin/sqlplus -S /nolog <<EOF > $tmpfile connect / as sysdba set head off set […]

Read More

PreBuilt Oracle Database 18c with Docker

In this post, we can use Docker service to pull the prebuilt Oracle Database 18c. Docker must be installed and running for this feature prerequisite. In your VM or Bare Metal, check the status and version of Docker if it is installed. [root@docker ~]# docker info [root@docker ~]# docker version Client: Version: 18.06.0-ce API version: […]

Read More