DBsGuru August 1, 2021 0 Comments

Offline Restore or Clone Database on the same server or rename database in Oracle 0 (0)

Offline Restore or Clone Database on the same server or rename database in Oracle In a recent article, we have demonstrated How to Rename Database using CONTROLFILE in Oracle, click here to go through it. In this article, we will demonstrate Offline Restore or clone Database on the same server with a new name or rename database […]

 1,345 Total Views,  7 Views Today

READ MORE
DBsGuru March 13, 2021 0 Comments

Multiplexing of Control Files Using RMAN, SPFILE & PFILE in Oracle 5 (2)

Multiplexing of Control Files Using RMAN, SPFILE & PFILE in Oracle Here we are going to demonstrate multiplexing of Control Files in Oracle using available options SPFILE, PFILE & RMAN. Before moving ahead first we will have a basic understanding of Control Files in Oracle. Control File is a physical file on OS level and […]

 2,599 Total Views

READ MORE
Jamsher Khan January 21, 2021 0 Comments

Mysql Logical Backup using mysqldump – Import 0 (0)

Mysql Logical Backup using mysqldump – Import This blog post is a continuation of the previous blog post Mysql Logical Backup using mysqldump – Export Click here to read more. In the previous blog, we saw How to perform the export of the Database and Table. Now in this post, we will perform How to […]

 1,122 Total Views

READ MORE
Jamsher Khan December 22, 2020 0 Comments

How To Recover Table from Drop/Truncate/Delete done on Primary using Flashback on a Standby 5 (3)

Recover a Table from Drop/Truncate/Delete done on Primary using Flashback on a Standby In this article, we will learn steps needed to perform recovery of User wrong operation like delete/drop/truncate action on the production table without using Restore and Recover command on PRIMARY DATABASE.Recovering the table from the standby database will also eliminate any required […]

 2,499 Total Views,  8 Views Today

READ MORE
DBsGuru August 27, 2020 0 Comments

RMAN Duplicate fails to create block change tracking file in Oracle 4.4 (21)

RMAN Duplicate fails to create block change tracking file in Oracle While restoring of Oracle database on another database node than your source database, RMAN duplicate command may fail to create a block change tracking file with the following errors after restoring the database: executing Memory Script Errors in memory scriptRMAN-03015: error occurred in stored […]

 3,988 Total Views,  4 Views Today

READ MORE