DNS Configuration: IP Addresses and other settings: DNS Server Details: 3 Nodes Details: Node1: Node2: Node3: Work To be performed on Machine on which DNS to be configure: Orignal “/etc/named.conf” file :…
Database Replay Workflow in Enterprise Manager-II
Database Replay Workflow in Oracle 11g Enterprise Manager: Part-II : Replay using Enterprise Manager As with the PL/SQL API replay example, we must create a directory and directory object on the test…
Database Replay Workflow in Enterprise Manager-I
Database Replay Workflow in Oracle 11g Enterprise Manager: Part-I : Capture using Enterprise Manager : As you might expect, the capture processing using Enterprise Manager is similar to that of using the…
Database Replay PL/SQL Procedures – II
Replay using the DBMS_WORKLOAD_REPLAY Package The DBMS_WORKLOAD_REPLAY package provides a set of procedures and functions to control the replay process. In order to replay the logs captured on the “ORCL” system, we need to…
Database Replay PL/SQL Procedures -I
Capture using the DBMS_WORKLOAD_CAPTURE Package The DBMS_WORKLOAD_CAPTURE package provides a set of procedures and functions to control the capture process. Before we can initiate the capture process we need an empty directory on the…
Database Replay System Architecture
How to Use Database Replay: The new Database Replay tool works like a DVR inside the database. Using a unique approach, it faithfully captures all database activity beneath the level of SQL…
Using Database Replay
Database Replay in Oracle Database 11g Release 1: What is your biggest concern when you need to make a change in the database—be it some minor change, such as altering initialization parameters…
Using New SET NEWNAME Clauses
Restoring Data Files to Nondefault Locations:– Using SET NEWNAME for Switching Files :– The SET NEWNAME command can be used only inside a RUN block. It prepares a name mapping for subsequent…
Problem in dropping UNDO Tablespace
Error: ORA-01548: active rollback segment ‘_SYSSMU1_3780397527$’ found, terminate dropping tablespace : When, I was taking RMAN backup in my test environment I feel that, backupset size is very large and because I…
Storing RMAN Output in a log file
Storing RMAN Output in a log file: – [oracle@localhost ~]$ rman target / log=”/home/oracle/Desktop/rman_log.log” RMAN> BACKUP DATABASE TAG ‘FULL’; RMAN> BACKUP DATABASE PLUS ARCHIVELOG; RMAN>BACKUP DATABASE PLUS ARCHIVELOG DELETE ALL INPUT; The…