The below process works only for an ocfs2 file-system created on whole device (with no partitions used): 1. Make sure that an ocfs2 backup is present before continuing. 2. Prepare global outage to extend the ocfs2 fs. 3. Unmount the share on all nodes using it (for safety reasons, such as avoiding data corruption if a node writes to the device when the disk extend is being performed) 4. Make sure that the new LUN size is visible under OS (using any scsi rescan command) on all … [Read more...] about How to Extend ocfs2 Filesystem with tunefs.ocfs2 Command (Whole device used without partitions)
oracle 12c
Oracle ASM 12c – New Features with examples
This post discusses a few 12C ASM new features with examples: Failgroup_repair_time Online disk replace Estimate Work V$ASM_OPERATION view 1. FAILGROUP_REPAIR_TIME For earlier ASM versions, we had disk_repair_time, from 12C onwards we have failgroup_repair_time at the ASM level. Because failure group outages are more likely to be transient in nature and because replacing all the disks in a failure group is a much more expensive operation than replacing a single disk, it would … [Read more...] about Oracle ASM 12c – New Features with examples
Oracle Database 12c New Feature – RMAN “RECOVER TABLE”
Table recovery Table recovery was possible in earlier releases as well. Until previous releases, if we wanted to recover a table, we had the following options: Database point in time recovery (DBPITR) Tablespace point in time recovery (TSPITR) Flashback technology The RECOVER TABLE command is a new feature in 12C that allows a point in time recovery of a table or a table partition. The table is recovered into an auxiliary instance and there is the option to: import the recovered … [Read more...] about Oracle Database 12c New Feature – RMAN “RECOVER TABLE”
Interview Questions : Oracle Flex ASM 12c
What is Oracle Flex ASM? Oracle Flex ASM is an ASM instance which will be running in the cluster based on cardinality defined. The default cardinality is three, but you can change it using srvctl modify asm command. It means that ASM is not required to run on each node in the cluster. In the previous release, ASM will be running on each node in the cluster and ASM clients (Database, ACFS, ADVM) can only access ASM by using an ASM on the same host. With Oracle Flex ASM, the clients can … [Read more...] about Interview Questions : Oracle Flex ASM 12c
Oracle sql script to report the list of files stored in ASM and CURRENTLY NOT OPENED
Purpose One of the features of ASM is databases consolidation. A single diskgroup will be the repository for multiple databases. The result, having a large number of datafiles. If the files were created using OMF (Oracle Managed Files) format, when the datafile is deleted on the database side, it is also deleted on the ASM side. There may be situations when the datafiles are not deleted on the ASM side, particularly when not using OMF format. With large diskgroups holding large number of … [Read more...] about Oracle sql script to report the list of files stored in ASM and CURRENTLY NOT OPENED
How to move ASM spfile from External Redundancy To Normal Redundancy in version 12.1.0.2 and above
The Ask While Installing the 12c Grid Infrastructure (GI) with the intention of having 3 copies of voting disks and OCR files, we created +GRID diskgroup with 3 underlying luns. However, because we chose "external redundancy" for the diskgroup ended up having just one copy of voting disk and OCR files with no option of multiplexing them in the same group. The Solution Before we get into the solution to this ask, lets first see what exactly is "external", "normal" and "high" … [Read more...] about How to move ASM spfile from External Redundancy To Normal Redundancy in version 12.1.0.2 and above
How To Disable Advanced Analytics in Oracle Database 12c?
The Ask The Advanced Analytics is eanbled on the oracle database 12c as shown below. SQL> select * from v$option where PARAMETER like '%Advanced Analytics%'; PARAMETER VALUE CON_ID ---------------------------------------- -------------------- ---------- Advanced Analytics TRUE 0 User wants to disable this option from database. The Solution In Oracle 12c, Oracle Advanced Analytics is a combination of … [Read more...] about How To Disable Advanced Analytics in Oracle Database 12c?
Script To Get Tablespace Utilization In Oracle Database 12c
This is a script to get the tablespace utilization in Oracle Database 12c. You can use this script to get the tablespace utilization ALLOCATED(MB), USED(MB) and Used parentage for all containers tablespaces. sqlplus -s / as sysdba set pages 80 set lin 120 set echo off set feed off column PCT format 999.99 column tbspce format A30 col container for a30 select substr(f.tablespace_name,1,30) tbspce, round(f.tsbytes/(1024*1024),0) "ALLOCATED(MB)", … [Read more...] about Script To Get Tablespace Utilization In Oracle Database 12c
Oracle database 12c : How to Drop Partition(s)
Dropping a Partition Dropping a partition will discard the rows stored in that partition as a DDL statement. This cannot be rolled back. It executes quickly and uses few system resources (Undo and Redo). You must be the owner of the table or have the DROP ANY TABLE privilege to drop a partition. You cannot drop a partition of a hash-partitioned table. You cannot drop a partition from a reference-partitioned table. If a drop partition is performed on a parent table, this operation cascades to … [Read more...] about Oracle database 12c : How to Drop Partition(s)
How to Drop/Truncate Multiple Partitions in Oracle 12C
The following are the partitioning related enhancements introduced in Oracle 12c: Online partition operations Reference partitioning enhancements Multi-partition maintenance operations Adding multiple partitions Truncating multiple partitions Merging multiple partitions Splitting into multiple partitions Dropping multiple partitions Dropping a Partition Dropping a partition will discard the rows stored in that partition as a DDL statement. This cannot be rolled back. It … [Read more...] about How to Drop/Truncate Multiple Partitions in Oracle 12C