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. […]
Monthly Archives: August 2018
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 […]
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. […]
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 […]
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 […]
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 […]
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 […]
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 […]
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 […]
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: […]