Being a DBA we must have knowledge on all kind of situation come across database’s life maintenance. We all are aware that CDR (Controlfile, Datafile, Redologfile) plays a most important role in Oracle database. With the help of backup, we can restore the database . In this article, we are going to learn about the recovery from controlfile in noarchivelog mode. […]
Category: BACKUP AND RECOVERY
Restore a NOARCHIVELOG database using current control file
We are going to have a look at recovery in Oracle database. it’s time to cause a fault in the database so we need to recover it. The scenario is the following: what does it happen and how can I recover a database in NOARCHIVELOG mode when a disk failure occurs and I lost my current […]
Restore the spfile while using the FRA & not using Recovery Catalog
Today we are going to learn about recovery with rman for loss of spfile. As we know that RMAN can be used either with or without a recovery catalog. A recovery catalog is a schema stored in a database that tracks backups and stores scripts for use in RMAN backup and recovery situations. Generally, a skillful DBA […]
PDBs Backup (How to identify which PDBs a backup set belong to)
Introduction:- In this article, we are going to have look on PDBs backup. Normally we have learnt about a different kind of backup available in Oracle. In cloud computing, we have backups in PDBs. In RMAN we have a script to know about the backup history. Now we can get the information of PDB(backup). n large scale industries have […]
Monitoring RMAN Backup with QBR tools
The Quest Backup Reporter is a windows client application. It can connect too many databases at a time and reports directly from oracle data dictionary views and RMAN catalog. It does not make any modification to either database as well as RMAN configuration. It is just a read only reporting tools. Quest Backup Reporter tools […]
COMPRESSED INCREMENTAL BACKUP
We need compressed full and incremental backup to apply in standby site and for make restoration faster INCREMENTAL LEVEL 0 BACKUP RUN { BACKUP AS COMPRESSED BACKUPSET INCREMENTAL LEVEL 0 DATABASE PLUS ARCHIVELOG; DELETE NOPROMPT ARCHIVELOG ALL BACKED UP 1 TIMES TO DISK; } INCREMENTAL LEVEL 1 BACKUP RUN { BACKUP AS COMPRESSED BACKUPSET INCREMENTAL […]
RECOVER ORACLE DATAFILES WITH NO DOWNTIME
What will happen if dbf file accidentally deleted when the database is still open and how to recover it? On Unix/Linux, when a file is deleted, but a process still has the file open, the file is still there in the filesystem, and only the inode is removed. But the process can continue to use […]
Oracle Import(parameters)
In this article, we are going to learn about the parameters of Import Oracle Datapump. Parameter Description abort_step undocumented feature access_method data access method : default is automatic attach attach to existing job : default is no cluster start workers across cluster: default is y content content to import : default is ALL data_options Import data […]
Oracle Export(parameters)
11g Oracle database’s Export parameters In this article, we are going to learn about the parameters of Export Oracle Datapump. Parameter Explanation abort_step Undocumented feature access_method Data access method – default is automatic attach Attach to exiting job -default is no cluster Start work across cluster- default is yes compression Content to export, default is metadata […]
Physical Backup(User Managed )
What is a User-managed backup in oracle? User-managed backup is accomplished with whatever operating system facilities happen to be available and SQL*Plus commands. These may be as simple as the copy commands on windows or cp on Unix/Linux. The significance of archive log mode for the backup technique available is the same for user-managed backup as for server-managed […]