The Problem Archives were moved from their original archivelog destination to a new location. Experienced the following errors when running RMAN backup of the archivelogs: RMAN-06059: expected archived log not found ORA-19625: error identifying file /zklpdata/archive/zkpd/arch_1_44543_466886099.arc ORA-27037: unable to obtain file status IBM AIX RISC System/6000 Error: 2: No such file or directory Additional information: 3 The Solution RMAN is attempting to backup this archivelog … [Read more...] about RMAN-06059 During RMAN Backup of archivelogs ( How to backup archivelogs moved to a different location)
oracle
Manage ASM Audit Files with syslog – configure lograte and auditing
The audit file destination directories for an ASM instance can grow to contain a very large number of files if they are not regularly maintained. Having a very large number of files can cause the file system to run out of free disk space or inodes, or can cause Oracle to run very slowly due to file system directory scaling limits, which can have the appearance that the ASM instance is hanging on startup. This post explains how to use the Linux syslog facility to manage ASM auditing records so … [Read more...] about Manage ASM Audit Files with syslog – configure lograte and auditing
How to Delete ASM Disk on Multipath Device in CentOS/RHEL
The post outlines steps to remove ASM disk on multipath device (Labeled as ASMDISK01 as an example in this post) from CentOS/RHEL server. 1. First make sure that ASM disk is no longer used by any disk group, otherwise, you might risk data integrity. The DBA can check this by using asmcmd or by logging into the ASM database. 2. Find out ASM disk mapping: # oracleasm listdisks ASMDISK01 ... # oracleasm querydisk -p ASMDISK01 Disk "ASMDISK01" is a valid ASM disk /dev/sdf: … [Read more...] about How to Delete ASM Disk on Multipath Device in CentOS/RHEL
How to set custom device names using udev in CentOS/RHEL 7
There could be a requirement from client to have custom device names such as /dev/asmdisk01 for an actual device with name /dev/sdb. Follow the steps outlined in this post to set custom device names using udev. In order to create customer name (/dev/asmdisk01p1) for /dev/sdb set udev rules as below: 1. Find UUID of device First, find the the UUID of the device with the scsi_id command as shown below. # /usr/lib/udev/scsi_id -g -u /dev/sdb 1IET_00020002 Save this UUID, as this ID … [Read more...] about How to set custom device names using udev in CentOS/RHEL 7
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
How to Split a Partition Into 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 Splitting Partition into multiple partitions You can split a partition into multiple partitions. In previous releases, you were able to split … [Read more...] about How to Split a Partition Into Multiple Partitions in Oracle 12c
How to Merge 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 Merging multiple partitions In Oracle 11g, you can merge the content of two partitions only in single DDL. However, in Oracle 12c, you can merge … [Read more...] about How to Merge Multiple Partitions in Oracle 12c
How to recreate Control file in Oracle Database
What are control files? The control file is a binary file that defines the current state of the physical database. The control file is one of the core files at the heart of the Oracle database. Together, this means that the Oracle instance itself is the only means by which the contents of the control file should ever be modified. The DBA should only modify it indirectly by means of altering the database. Loss or corruption of the control file requires a database recovery. The control file is … [Read more...] about How to recreate Control file in Oracle Database
Managing Oracle Database Backup with RMAN (Examples included)
Installed with the database, Recovery Manager (RMAN) is an Oracle database client which performs backup and recovery tasks on your databases and automates the administration of your backup strategies. It greatly simplifies backing up, restoring, and recovering the database. The RMAN environment consists of the utilities and databases that play a role in backing up your data. At a minimum, the environment for RMAN must include the following: The target database. This is the database to be … [Read more...] about Managing Oracle Database Backup with RMAN (Examples included)