Question: You maintain several SPFILE files: $ ls -l spfile* -rw-r—– 1 sme dba 2560 Mar 20 08:20 spfile.ora -rw-r—– 1 sme dba 2560 Mar 20 08:20 spfileRel14.ora Which one is modified when you run the “ALTER SYSTEM” SQL command to permanently change parameter values in the spfile? The DBAs must be cautious when using […]
oracle
How to Modify spfile in Oracle Database
SPFILE: The Server Parameter File Beginning with Oracle9i, Oracle introduced the concept of the server parameter file. This file, known as SPFILE , differs from the standard INIT.ORA file in a number of ways: It is a binary file, rather than a text-based file. It is stored on the server, rather than on a client […]
Beginners Guide to Monitoring Oracle Database Restore/Recovery Progress
In an production environment, it is a common task to take backup and restore it using RMAN. So it is important to know the Tips and techniques for monitoring a restore/recovery operation and determine whether it is indeed working, slow or hung. In general, a restore should take approximately the same time as a backup, […]
12c ASM: PRCR-1001 : Resource ora.proxy_advm Does Not Exist (Flex ASM with Cardinality = ALL)
The Problem This a RAC cluster configuration composed of 2 nodes. Clusterware was upgrade from 11.2.0.4 to 12.1.0.2 release. And ASM was converted to “Flex ASM” with “Cardinality = ALL”. Validating the “ora.proxy_advm” resource state reports the below error: $ srvctl status asm -proxy -n asmcloud2 -verbose PRCR-1001 : Resource ora.proxy_advm does not exist The […]
How to Convert STANDARD ASM to FLEX ASM in 12C
You can convert an Oracle ASM configuration to an Oracle Flex ASM using ASMCA. This functionality is only available in an Oracle Grid Infrastructure 12c configuration. Before you convert an Oracle ASM configuration to an Oracle Flex ASM, you must ensure the following: Oracle Cluster Registry (OCR) is stored in a disk group. The server […]
How to Restore ASM Based OCR After Complete Loss of the CRS Diskgroup on Linux/UNIX
It is not possible to directly restore a manual or automatic OCR backup if the OCR is located in an ASM disk group. This is caused by the fact that the command ‘ocrconfig -restore‘ requires ASM to be up & running in order to restore an OCR backup to an ASM disk group. However, for […]
How to Find OCR Master Node
Function of OCR Master Node OCR master is in charge of OCR update and is the only one that’s allowed to update, the post shows a way to find OCR master. 1. The default OCR master is always the first node that’s started in the cluster. 2. When OCR master (crsd.bin process) stops or restarts […]
TSPITR fails With RMAN-06553
The Problem TSPITR fails With RMAN-06553 when the tablespace (using OMF files) is dropped including contents and datafiles: RMAN-00571: =========================================================== RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS =============== RMAN-00571: =========================================================== RMAN-03002: failure of recover command at 10/22/2015 16:43:08 RMAN-03015: error occurred in stored script Memory Script RMAN-06553: DB_CREATE_FILE_DEST must be set for SET NEWNAME … TO […]
How to Recover A Dropped Tablespace Using TSPITR
The Basics RMAN automatic Tablespace Point-In-Time Recovery ( TSPITR) enables you to quickly recover one or more tablespaces in an Oracle database to an earlier time, without affecting the state of the rest of the tablespaces and other objects in the database. Prior to the 11.2 version, the TSPITR had a restriction of not being […]
Oracle Tablespace Transport for a Single Partition
Prior to 11g, there is a restriction on transporting tablespaces for a single partition. Starting in RDBMS version 11g, transport of a tablespace for a single partition and plugging it into another database is now supported. This note shows the process to follow in order to achieve this. Steps 1. Create the partitioned table: SQL> […]