asrblogger, Author at ASRblogger

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…

asrblogger November 30, 2022No Comments

Oracle

12cR1 to 19C upgradation with auto upgrade feature

Advantages of AutoUpgrade Utility: ========================== 1. Time saving method (completes the upgrade in a short time) 2. can upgrade multiple Oracle Database deployments at the same time, using a single…

asrblogger November 20, 2022No Comments

Oracle

Upgrade Oracle Database from 12.1.0.2 to 12.2.0.1 using DBUA

Supported Upgrade PathsDirect upgrades are possible from existing databases with the following versions.Destination Source=========== ======12c Release 1 (12.1.0.2) 10.2.0.5+, 11.1.0.7+, 11.2.0.2+ or 12.1.0.112c Release 2 (12.2.0.1) 11.2.0.3+ or 12.1.0.1 or…

asrblogger November 19, 2022No Comments

ASM Oracle RAC

Step by Step ASM/ Grid Installation in Oracle Standalone

Prerequisite. Add below OS groups Add asmdba as secondary group to Oracle user Create Grid User [root@dg11 /]# useradd -u 54331 -g oinstall -G dba,asmdba,asmoper,asmadmin,racdba grid Change the password for…

asrblogger November 19, 2022No Comments

Oracle

Common User Vs Local User In 12c

COMMON USER: 1.A common user is a Database user, which perform an activity in all the containers including root container of the CDB. 2.A common user can only be created…

asrblogger November 12, 2022No Comments

Oracle

How To Rename A Pluggable Database ( PDB)

The following explains how to rename a container (pluggable databases). Step-By-Step 1. Shutdown the pluggable database (PDB). SQL> show pdbs; CON_ID CON_NAME OPEN MODE RESTRICTED ---------- ------------------ ---------- ---------- 3…