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 ALTER SYSTEM command since it permanently modifies an SPFILE parameter file. They need to know which parameter file will be … [Read more...] about Which SPFILE Parameter File is Impacted when Issuing an ALTER SYSTEM Command
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 machine. It can maintain changes to parameter values over the shutdown and startup of an instance. This last point is the important part of SPFILE. If your database is running … [Read more...] about How to Modify spfile in Oracle Database
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, if not longer. Therefore, if your backup took 10 hours to complete, it will take at least 10 hours to restore to the same host. Another good indicator is to determine the … [Read more...] about Beginners Guide to Monitoring Oracle Database Restore/Recovery Progress
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 Solution 1. ASM instances are running and available on both nodes: ora.asm 1 ONLINE ONLINE asmcloud1 … [Read more...] about 12c ASM: PRCR-1001 : Resource ora.proxy_advm Does Not Exist (Flex ASM with Cardinality = ALL)
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 parameter file (SPFILE) is stored in a disk group. The password file (ORAPWD file) is stored in a disk group. The disk group where the OCR, SPFILE, and … [Read more...] about How to Convert STANDARD ASM to FLEX ASM in 12C
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 ASM to be available, the CRS stack must have been successfully started. For the restore to succeed, the OCR also must not be in use (r/w), i.e. no CRS daemon must be running while the OCR is being restored. When … [Read more...] about How to Restore ASM Based OCR After Complete Loss of the CRS Diskgroup on Linux/UNIX
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 for whatever reason, the crsd.bin on surviving node with lowest node number will become new OCR master. Finding OCR Master Node The following method can be used to find OCR master: 1. By … [Read more...] about How to Find OCR Master Node
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 … [Read more...] about TSPITR fails With RMAN-06553
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 able to recover the dropped tablespace. From 11.2 this limitation no longer exists. We can recover the dropped tablespace using TSPITR. Example The below example … [Read more...] about How to Recover A Dropped Tablespace Using TSPITR
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> CREATE TABLE rptg_pd 2 ( 3 a varchar2(5), 4 period_dt date, 5 b number) 6 PARTITION BY RANGE (period_dt) 7 ( 8 PARTITION mv_period_dt_1994 VALUES … [Read more...] about Oracle Tablespace Transport for a Single Partition