Home 2022 December

Monthly Archives: December 2022

Man in profile, hand drawn

Protected: Profiles

0
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...
photo of people engaged on their phones

User Management

0
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...
a text on a pink surface

Protected: How to Decide if column should be indexed?

0
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...
metal chain with lock on street

Protected: Database Link (DB Link)

0
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

0
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

0
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

0
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

0
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...