Database Cloning without RMAN on windows

CREATE INITSRDB.ORA PFILE IN D:\DATABASE\APP FOLDER

2. CREATE DESTINATION FOLDER DATAFILES FOLDER ONLINE REDOLOGS FOLDER CONTROLFILE FOLDER 3. CREATE SERVICE USING ORADIM

NOTE: CHECK WHETHER THE SERVICE IS RUNNING OR NOT. 4. COPY ALL THE DATAFILES, REDOLOGS TO DESTINATION FOLDER AS IT IS THE CASE OF DATABASE CLONING WITHOUT RMAN 5. GO TO […]

Read More

Oracle 18c: RMAN New Features

This article was written by Skant Gupta and Joel Perez in Oracle OTN. Full Index of Oracle Cloud Articles: Sir.CloudDBaaSjoelperez Before starting to read, if you want to access others Oracle RMAN Cloud Articles, you can go here: #6 Oracle Cloud (DBaaS): Migrating Databases to Oracle Cloud Using RMAN Backup #11 Oracle Cloud (DBaaS): Migration “On-prem” database to Cloud Using […]

Read More

RMAN Active Cloning From RAC TO RAC

Being an Oracle DBA we know that what is cloning? This technical definition gives you a correct idea of the cloning. RMAN has the ability to duplicate, or clone, a database from a backup or from an active database. It is possible to create a duplicate database on a remote server with the same file structure, […]

Read More

Categories of Failures in Oracle Database

Today we are going to have look on Categories of Failures in Oracle Database.  This information helps to DBA solve the issue as soon as possible.   Statement Failure Statement failure transpires when there is a logical failure in the handling of a statement in an Oracle program. If a statement failure occurs, then the Oracle software or operating […]

Read More

Recover corrupted data blocks using DBVERIFY

As we know that SYSTEM – stores the data dictionary.  Being an Oracle DBA we all know the importance of SYSTEM tablespace.  In these below lines, we can have actual technical knowledge about system’s information. SYSTEM – a tablespace that is always used to store SYSTEM data that includes data about tables, indexes, sequences, and other objects – this metadata […]

Read More

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 […]

Read More

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 […]

Read More

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 […]

Read More

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 […]

Read More