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…
Category: Database
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…
Logging Command Line RMAN outputs
Running RMAN commands through a Command File : In the below command, there are some RMAN commands are already written in ‘/home/oracle/Desktop/rmancmd.txt’ file. RMAN read all commands from this file [oracle@localhost ~]$…
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…