Oracle Archives - Page 18 of 30

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 users who share theseattributes.You should assign…

asrblogger December 4, 2022No Comments

Oracle

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 accounts and grant appropriate…

asrblogger December 4, 2022No Comments

Oracle Scripts

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 query faster? Q. Which…

asrblogger December 4, 2022No Comments

Oracle Scripts

Protected: Database Link (DB Link)

This content is password protected. To view it please go to the post page and enter the password.

asrblogger December 4, 2022

Oracle SQL

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 the redundancy for…

asrblogger December 4, 2022No Comments

Oracle SQL

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 OF TABLESPCAE…

asrblogger December 4, 2022No Comments

Oracle

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 is recommended to have multiplexed copies…

asrblogger December 4, 2022No Comments

Oracle Scripts

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 specifies how many…

asrblogger December 4, 2022No Comments

Oracle RAC

How to determine what is keeping Catalog and Catproc invalid in the Registry

SQL> select comp_id, status, version from dba_registry; COMP_ID STATUS VERSION ------------ ----------- -------------- CATALOG INVALID 11.2.0.3.0 CATPROC INVALID 11.2.0.3.0 SQL> select object_name, object_type from dba_objects where owner = 'SYS' and…

asrblogger December 3, 2022No Comments

Oracle

Creating pluggable database from seed, when pdb$seed in in mount state and open state.

SQL> show pdbs CON_ID CON_NAME OPEN MODE RESTRICTED ---------- ------------------------------ ---------- ---------- 2 PDB$SEED MOUNTED 3 PDB1 READ WRITE NO 4 DEV READ WRITE NO SQL> create pluggable database PDB2…