VIRTUAL PRIVATE CATALOG(11G)

VIRTUAL PRIVATE CATALOG: In   11G  oracle as introduced virtual private catalog. Prior to 11g ,A single recovery catalog can be used by multiple users to give and modified the records in the Recovery catalog. Using A single Recovery catalog by multiple users may lead to security consult .To overcome this …

Read More »

RMAN CONFIGURE IN CATALOG MODE

RMAN CONFIGURE IN CATALOGMODE :  [root@dbcentre4 ~]# su – oracle [oracle@dbcentre4 ~]$ ps -ef|grep smon oracle 19559 19524 0 10:39 pts/1 00:00:00 grep smon [oracle@dbcentre4 ~]$ ps -ef|grep pmon oracle 19561 19524 0 10:39 pts/1 00:00:00 grep pmon STEP 1:  CREATE  ONE DATABASE: STEP 3: CREATE ONE USER & BASE TABLES: …

Read More »

Loss of full database in No Catalog mode – Oracle RMAN

      RMAN> report schema; using target database control file instead of recovery catalog Report of database schema for database with db_unique_name CHEYSAR List of Permanent Datafiles =========================== File   Size(MB) Tablespace    RB segs       Datafile Name —-   ——–     ——————–    ——- ———————— …

Read More »

DELETE EXPIRE BACKUP

for  example we take any one datafile backup, after then we delete to the  that backup of datafile . RMAN; backup datafile 4; Starting backup at 03-JUL-17 using channel ORA_DISK_1 using channel ORA_DISK_2 channel ORA_DISK_1: starting full datafile backup set channel ORA_DISK_1: specifying datafile(s) in backup set input datafile file …

Read More »

RMAN configuration in No catalog mode:

RMAN  backup is  a block level  backup. ( oracle block level ). Rman is centralized backup ,restore and Recovery utility We can configure Rman in  Two modes: No catalog mode Catalog mode Recommonded to configure Rman is “CATALOG MODE”. No catalog mode: In No catalog mode , Rman keeps backup …

Read More »

PHYYCAL BACKUPS ( COLD AND HOT BACKUPS)

Physical backups: 1.Cold backup 2.Hot backup   Cold backups: A cold backup is consistent backup. A database is in No archive log mode db recovery is not possible. Restore and recover is possible in the database is in archive log mode. Oracle database having two types of recoveries 1.Incomplete recovery …

Read More »

DATA GUARD CONFIGURATION MODES

DATA GUARD CONFIGURATION MODES MAXIMUM PROTECTION MODE : if you want Architect A no data loss solution ,recommended to configure data guard in maximum protection mode. In this mode, it is  to create stand by redo logs which are of the same size of primary redo logs .In this mode, …

Read More »

DATA GUARD ARCHITECTURE

MAA (MAXIMUM AVAILABLE ARCHITECTURE) To overcome  instance level failovers oracle as introduced multi instance database , which is nothing  but RAC  database . RAC  supports  two  types of failover’s: 1 . session failover select failover   There is no concept of DML failover in RAC system. Various technologies that are …

Read More »

DATA PUMP USING BACKUP

  Backups: Oracle database backups categorized into 3 types 1.logical backups 2.physical backups 1.cold backup/offline 2.hot backup/online 3.rman backups Logical backups: 1.logical backups can be taken when the database is up and running 2.it is an alternative backup method 3.using logical backup we can be selective(we can take the backup …

Read More »

How to Recovery Redo log file

–> Open database in mount stage: SQL> shut abort; ORACLE instance shut down. SQL> startup nomount; ORACLE instance started. Total System Global Area 627732480 bytes Fixed Size 1338336 bytes Variable Size 545260576 bytes Database Buffers 75497472 bytes Redo Buffers 5636096 bytes SQL> alter database mount; Database altered. –> Identify to …

Read More »
DON’T MISS OUT!
Subscribe To Newsletter
Be the first to get latest updates and exclusive content straight to your email inbox.
Stay Updated
Give it a try, you can unsubscribe anytime.
close-link
GET OUR LATEST CONTENT IN YOUR INBOX

SUBSCRIBE 
Your information will never be shared
close-link
Enquiry
Submit
close-link
Sign-up for exclusive content. Be the first to hear about DBA Centre Blogs.
Subscribe