Monthly Archives: December 2022
Protected: Profiles
A profile is a collection of attributes that apply to a user.The profile is used to enable a single point of reference for multiple...
User Management
About User Accounts:The areas in which you can configure security are as follows:
• User accounts
For users to access your database, you must create user...
Protected: How to Decide if column should be indexed?
Many people ask these Questions,
Q. How to identify which column is candidate for Index creation?
Q. How to determine index will really help to perform...
Protected: Database Link (DB Link)
A database link (DBlink) is a definition of how to establish a connection from one Oracle database to another.
Type of Database Links:Private database link...
Protected: Recovery Catalog
What is Recovery Catalog?
A recovery catalog is a database schema used by RMAN Which is used to stored Metadata of one ormore databases.
Benefits:
It creates...
Recovery of dropped tablespace with RMAN
SELECT NAME ,OPEN_MODE FROM V$DATABASE;SELECT LOG_MODE FROM V$DATABASE;SELECT NAME FROM V$DATAFILE;SELECT NAME FROM V$TABLESPACE;
CREATE TABLESPACE(TB1)
RMAN > BACKUP DATABASE PLUS ARCHIVELOG;
LIST BACKUP OF CONTROLFILE;
LIST BACKUP...
Control File and Redolog File Multiplexing
Control file and Redolog file contains crucial database information and loss of these files will lead to loss of important data about database. It...
ARCHIVE AND OLD RMAN BACKUP REMOVAL
RMAN> show all;
CONFIGURE RETENTION POLICY TO RECOVERY WINDOW OF 7 DAYS;
RMAN> CONFIGURE RETENTION POLICY TO NONE;
The REDUNDANCY parameter of the CONFIGURE RETENTION POLICY command...