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
Oracleasm Service Fails to Start After Upgrade to oracleasm-support-2.1.11-1 RPM Package
The Problem After upgrading oracleasm-support package, unable to start the oracleasm service which was working properly before the upgrade. Attempts to start the service result in: # service oracleasm start oracleasm is not enabled, use 'service oracleasm enable' or 'oracleasm init' The Solution This is caused by a regression in oracleasm-support-2.1.11-1 where the oracleasm configuration file /etc/sysconfig/oracleasm is not marked as a configuration file in the RPM spec file and is … [Read more...] about Oracleasm Service Fails to Start After Upgrade to oracleasm-support-2.1.11-1 RPM Package
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?
What is OCFS or OCFS2
1. What is OCFS for Linux? OCFS is an open source clustered file system for Linux designed for use with Oracle RAC on Linux to store Oracle datafiles, redo logs, archive logs, voting disks, quorum files and control files. It is NOT a general purpose file system and should not be used to store a shared Oracle home. OCFS, also referred to as OCFS (Release 1), works with the 2.4 version and later of the Linux Kernel like RHEL, CentOS, SUSE. 2. What is OCFS2 for Linux? OCFS2 is the next … [Read more...] about What is OCFS or OCFS2
Script/Queries to Monitor Temporary Tablespace Usage in Oracle Database
The temporary (sort) segment of a given temporary tablespace is created at the time of the first sort operation, which has to write to disk to free up sort space in memory. The first disk sort (after instance startup) creates a sort segment in the temporary tablespace. Multiple transactions which need a sort on disk can share the same sort segment, however, they cannot share the same extent. The sort segment expands by allocating new extents. The sort extents are not de-allocated while the … [Read more...] about Script/Queries to Monitor Temporary Tablespace Usage in Oracle Database