Overview of New PULL method The original “push” process is based on image copies.With Oracle Database 12c, a “pull” (or restore) process is based on backup sets. A connection is first established with the source database. The auxiliary instance then retrieves the required database files from the source database as backup sets. A restore operation is performed from the auxiliary […]
##Connecting RMAN############## rman TARGET SYS/target_pwd@target_str # connects in NOCATALOG mode rman TARGET / CATALOG rman/rman@rcat rman TARGET / CATALOG rman/rman@rcat AUXILIARY sys/aux_pwd@aux_str ##Create user and catalog in RMAN database ######## CREATE USER rman_dba IDENTIFIED BY rman_dba TEMPORARY TABLESPACE temp DEFAULT TABLESPACE rman_dba QUOTA UNLIMITED ON rman_dba; GRANT RECOVERY_CATALOG_OWNER TO rman_dba; CREATE CATALOG; ## Register Database###### Rman target / catalog rman_dba/rman_dba@<catalog> […]
Database backup and restore after manual catalog RMAN backup 1.Please take backup of primary database ORCL rman target / nocatalog log=/tmp/rman_bkp.log << EOF1 run { backup as compressed backupset database format ‘/opt/app/oratest1/bkp/ORCL_%U’; backup as compressed backupset archivelog all format ‘/opt/app/oratest1/bkp/ORCL_ARCH_%U’; } exit; EOF1 Please copy it in backup location to /opt/app/oratest1/bkp 2.Please start nomount RCATT database. 3.Please create controlfile from […]
Cost Calculation for Full table Scan How FTS cost depends on system statistics Gather statistics manually on load: The following command will start to gather system statistics. SQL> execute DBMS_STATS.GATHER_SYSTEM_STATS (‘START’); Please wait for system warm up and stop gather system statistics after work load. This is called workload statistics. The MBRC will be calculated automatically depending on no. of […]
Prepare by: Nurullah Sharif Scope: Undo Advisor Undo Advisor help to estimate the undo tablespace size and also advise of undo retention. SQL> @db NAME OPEN_MODE ——— ——————– COLLPROD READ WRITE Undo retention is 900 sec which 15 min SQL> sho parameter undo NAME TYPE VALUE ———————————— ———– —————————— undo_management string AUTO undo_retention integer 900 undo_tablespace string UNDOTBS2 […]
Author: Saibal Ghosh About author: I am an Oracle professional with twenty plus years of experience and have deep knowledge and understanding of various facets of Oracle technology including basic Oracle Database Administration, Performance Tuning, Real Application Clusters, Data Guard and Maximum Availability Architecture. I also work a lot in the Oracle Database Cloud space, and I believe that the […]
Prepare by: Nurullah Sharif Scope: Point in Time Recovery Duplicate database until Point in Time recover, using backup location. #PointInTimeRecovery #DuplicateDatabase #RestoreDatabaseUsingBackupLocation We are using full backup of 28-11-2017 and archivelog backup of 29-11-2017 Step 1: Take full backup and archive log backup. On target database : Rman target / run { backup as compressed BACKUPSET incremental […]
Oracle introduced PDB from 12c to minimize following drawbacks in 11g In 11g,sometimes we need to create numerous databases in single host which resulted below side effects and eventually slowed down whole system. 1.Too many background processes. 2.High shared memory. 3.Many copies of oracle metadata. Now We will delve into more deeper what Oracle 12c PDB concepts bring to […]
———-Progress index creation————– set lines 200 col “Index Operation” for a60 select sess.sid as “Session ID”, sql.sql_text as “Index Operation”, longops.totalwork, longops.sofar, longops.elapsed_seconds/60 as “Runtime Mins”, longops.time_remaining/60 as “ETA Mins” from v$session sess, v$sql sql, v$session_longops longops where sess.sid=longops.sid and sess.sql_address = sql.address and sess.sql_address = longops.sql_address and sess.status = ‘ACTIVE’ and longops.totalwork > longops.sofar and sess.sid not in ( […]
Prerequisites for Upgrading to Enterprise Manager Cloud Control 13c Release 2 1.First latest PSU patch needs to be applied in GRID and ORACLE home. In my case latest patch of that time was as below Patch 24412235: GRID INFRASTRUCTURE PATCH SET UPDATE 12.1.0.2.161018 (OCT2016) Prepatch operation log file location: /u01/app/product/12.1.0/grid/cfgtoollogs/crsconfig/hapatch_2016-12-19_01-58-57PM.log CRS service brought down successfully on home /u01/app/product/12.1.0/gridStart applying binary […]