Tag Archives: configuration

Linux, Oracle, Single Instance

Step by Step Installation of Oracle 19c binaries in linux 7.7

Leave a comment
FacebooktwitterredditpinterestlinkedinmailFacebooktwitterredditpinterestlinkedinmail

In this Article you will se how to install oracle 19cbinaries

Step 1 :
Disable firewall and selinux:
first check the status of firewalld status weather is active or not:

[root@localhost /]# systemctl status firewalld
● firewalld.service – firewalld – dynamic firewall daemon
Loaded: loaded (/usr/lib/systemd/system/firewalld.service; enabled; vendor preset: enabled)
Active: active (running) since Mon 2021-05-03 01:47:30 IST; 4h 12min ago
Docs: man:firewalld(1)
Main PID: 957 (firewalld)
Tasks: 2
CGroup: /system.slice/firewalld.service
└─957 /usr/bin/python2 … Read more

Backup & Recovery, Linux, Oracle, pluggable database, Unpluggable database

Plugging an Unplugged Pluggable Database with copy method

3 Comments
FacebooktwitterredditpinterestlinkedinmailFacebooktwitterredditpinterestlinkedinmail

Plugging an Unplugged Pluggable Database

Unplugging the PDB

To unplug a PDB, you first close it and then generate an XML manifest file. The XML file contains information about the names and the full paths of the tablespaces, datafiles of the unplugged PDB. The information will be used by the plugging operation.

We are going to unplug the PDB to plug them with Copy methods.

[oracle@localhost pdb3]$ . oraenv
ORACLE_SID = [cdb1] ? cdb1
The Oracle base remains unchanged with value /u01/app/oracle

[oracle@localhost pdb3]$ sqlplus / as sysdba

SQL> show con_name

CON_NAME
------------------
… Read more
Database Administration, Linux, Log miner, Oracle

How to configure Logminer in oracle step by step

58 Comments
FacebooktwitterredditpinterestlinkedinmailFacebooktwitterredditpinterestlinkedinmail
LOGMINER :-

Logminer is a utility provided with the Oracle database server which mines the redologs or Archivelogs and data dictionary information to build the SQL statements and keeps the contents of the redolog file in the fixed view called ” V$logmnr_contents “.
LogMiner tool can help the DBA to the find changed records in redo log files by using a set of PL/SQL procedures and functions .
Internally Oracle uses the Log Miner technology for several other features,such as Flashback Transaction Backout,Streams, and Logical Standby Databases .Most often LogMiner is used for recovery purpo… Read more