Recovery Catalog: RMAN metadata is stored in a different database instead of the control file. That database works as a repository. Follow the given steps to create a recovery catalog database Step 1: Connect to the target database which you want to use as a recovery catalog. Here in my case, I am using pdb […]
Category: BACKUP AND RECOVERY
Enable block change tracking
In this article we will enable block change tracking Now, what is block change tracking? Block change tracking is a mechanism of Oracle database to record changed blocks in a file. It helps us in taking incremental backups. While tracking incremental backups, instead of scanning all datafiles for changed blocks RMAN can simply read change […]
KEEP FOREVER Database Backup
We know that when we take backup using RMAN it has its configuration for Retention Policy. Every backup has its retention policy either in days or in a number of back-ups. And backups are stored in the Fast recovery area. Once a backup exceeds from its retention policy it becomes obsolete. But today we will […]
Backup Archive log files
We know that archive logs are very important files of a database when it comes to recovery. Let’s see how we can take backup of archive log files. Step 1: Connect to RMAN [oracle@localhost ~]$ rman target / Recovery Manager: Release 12.2.0.1.0 – Production on Mon Jan 7 11:23:15 2019 Copyright (c) 1982, 2017, Oracle […]
Backup the Control File
We can set CONTROLFILE AUTOBACKUP on to make a backup of control file every time we take backup using RMAN. But today we will see how we can manually make a backup of controlfile. Step 1: Login to SQL prompt of database [oracle@localhost ~]$ export ORACLE_SID=demo [oracle@localhost ~]$ sqlplus / as sysdba SQL*Plus: Release 12.2.0.1.0 […]
Configuring setting in RMAN
Recovery Manager [RMAN] is a very powerful tool when it comes to Backup, Restore or recovering your database. Today we will see Configuration of RMAN and how we can set them. Let’s start from scratch. 1: Connecting to RMAN To connect with rman we need to specify a target database name, username and password. [oracle@dbatesting […]
RMAN backup in Noarchive log mode
Today we will see how to take backup of Oracle Database when your database is in NOARCHIVELOG mode. Step 1: Check your database details [oracle@dbatesting ~]$ export ORACLE_SID=orcl [oracle@dbatesting ~]$ sqlplus / as sysdba SQL*Plus: Release 12.2.0.1.0 Production on Wed Dec 19 21:44:57 2018 Copyright (c) 1982, 2016, Oracle. All rights reserved. Connected to: Oracle […]
Change Default Temporary Tablespace in Oracle
Being Oracle DBA we all are well known about the tablespace. Oracle RDBMS have multiple kinds of a tablespace with a different kind of purpose. We are going to have look on steps use for “Change Default Temporary Tablespace”. Check the current default temporary tablespace SQL> column property_value format a25 SQL> SELECT property_name,property_value FROM DATABASE_PROPERTIES where PROPERTY_NAME=’DEFAULT_TEMP_TABLESPACE’; […]
Incomplete Time Based Recovery in Oracle
Oracle provides different multiple options to have a “backup& recovery” as per the organization’s requirements. Incomplete recovery is one of the types of recovery. Let’s have look on the incomplete recovery. Check the archive log status SQL> archive log list; Database log mode Archive Mode Automatic archival Enabled Archive destination USE_DB_RECOVERY_FILE_DEST Oldest online log sequence 7 Next […]
Hot Backup with RMAN in Oracle
We are going to have look on the backup of Oracle, Which is common in DBA’s life. HOT Backup is the most common way to have a backup. Let’s have look on the steps of Oracle’s HOT Backup. Check the archive status SQL> archive log list; Database log mode Archive Mode Automatic archival Enabled Archive destination […]