This post covers the detailed steps for creating a physical standby database on a normal file system using RMAN for a primary database in ASM. Overview Here the Standby database can be created using the following 2 methods: Normal Restore and Recovery using RMAN. Creating a Duplicate database for Standby using RMAN. Method 1 Perform the backup of the ASM primary database ( Datafiles, Controlfile for standby and Archivelogs ) Make the backup pieces available on the Standby … [Read more...] about Step By Step Guide To Create Physical Standby On Normal File System For ASM Primary using RMAN
oracle 12c
How To Catalog Backups / Archivelogs / Datafile Copies / Controlfile Copies in Oracle Database
The RMAN CATALOG command is used to accomplish the following: Add backup pieces and image copies on disk to the RMAN repository. Record a datafile copy as a level 0 incremental backup in the RMAN repository, which enables you to use it as part of an incremental backup strategy. Record the existence of the last user-managed datafile copies made after the final shutdown. Restrictions and Usage Notes You must be connected to the target database, which must be mounted or open. If RMAN … [Read more...] about How To Catalog Backups / Archivelogs / Datafile Copies / Controlfile Copies in Oracle Database
Script to monitor RMAN Backup and Restore Operations
RMAN is designed to complete a backup or restore as quikly and efficiently as possible. But if a job takes longer than expected to complete it can be confusing trying to determine: What precisely is RMAN doing at any particular time? Is RMAN hung or just slow? How far into the backup/restore has it got? How much more work is there to go? Knowing just how much processing has been done so far is often crucial when trying to decide whether or not to wait for job completion. RMAN … [Read more...] about Script to monitor RMAN Backup and Restore Operations
Oracle RMAN Backup Shell Script Example
Pre-requisites 1. Create a catalog database (rmancat) if one does not exist. (With additional UNDO-, USERS- and TEMP-tablespaces) 2. Configure SQL*Net to handle the catalog (rmancat) and the 'target' database connections. 3. Create a user 'RMAN' in the catalog database. SQL> create user rman identified by rman default tablespace USERS quota unlimited on users temporary tablespace TEMP; SQL> grant recovery_catalog_owner to rman; 4. Create the RMAN-catalog in the … [Read more...] about Oracle RMAN Backup Shell Script Example
How to Define PDB Listeners With Different Ports In a Oracle database Multitenant Setup
This post will discuss the necessary steps to create and configure listeners for a Pluggable Database (PDB) in a Multitenant environment. 1. Using netca create a 2nd listener on a unique port. This creates a listener.ora file in the $ORACLE_HOME/network/admin directory similar to: $ cat $ORACLE_HOME/network/admin/listener.ora PDB_LISTENER = (DESCRIPTION_LIST = (DESCRIPTION = (ADDRESS = (PROTOCOL = IPC)(KEY = test)) (ADDRESS = (PROTOCOL = TCP)(HOST = … [Read more...] about How to Define PDB Listeners With Different Ports In a Oracle database Multitenant Setup
Threaded_execution=true Prevents OS Login As Sysdba in Oracle Database 12c
Connecting "/ as sysdba" is successful if threaded_execution=false. It fails if threaded_execution=true. Lets verify this with an actual example: 1. Set the threaded_execution parameter value as true. SQL> show parameter threaded_execution; NAME TYPE VALUE ------------------------------------ ----------- ------------------------------ threaded_execution boolean FALSE SQL> connect / as sysdba Connected. SQL> alter … [Read more...] about Threaded_execution=true Prevents OS Login As Sysdba in Oracle Database 12c
Oracle 12c New Feature – Multi-Threaded architecture of processes
The Basics Oracle 12c database introduced the Multi-Threaded architecture of processes. The multi-threaded Oracle model enables Oracle processes on UNIX and Linux to run as operating system threads in separate address spaces. It applies to both BACKGROUND PROCESSES and SERVER PROCESSES. By default, some background processes on UNIX and Linux always use threaded execution; the remaining Oracle processes run as operating system processes. This feature can be helpful to reduce CPU and memory … [Read more...] about Oracle 12c New Feature – Multi-Threaded architecture of processes
New Oracle Net features in version 12c
CONCEPT Oracle Net is the communication software that enables a network session between a client application and an Oracle database. After a network session is established, Oracle Net acts as a data courier for the client application and the database. New Features The following are the new features in Oracle Net Services: Larger Session Data Unit Sizes Oracle Net 12c supports large session data unit (SDU) sizes, with a new upper limit of 2 MB. The larger SDU size can be used to achieve … [Read more...] about New Oracle Net features in version 12c
How to Disable Oracle Net Tracing on a Server Process without Stopping the Process
When Oracle Net server tracing is invoked using sqlnet.ora (see example below) tracing on the affected server processes will continue throughout the process lifetime. If tracing needs to be stopped without stopping the server process the following method can be used. Example: static server tracing using sqlnet.ora: trace_level_server = 16 trace_directory_server = /tmp diag_adr_enabled = off Dynamic Oracle Net Server Tracing Use dynamic server tracing to disable tracing without … [Read more...] about How to Disable Oracle Net Tracing on a Server Process without Stopping the Process
Dynamic Oracle Net Server Tracing
Dynamic tracing V/s Static Tracing Oracle Net tracing is controlled by sqlnet.ora parameters which are static for the lifetime of RDBMS server processes. Since there is a single sqlnet.ora file for an instance, trace settings apply to all server processes. This can pose difficulties in live production environments. Dynamic server tracing allows for tracing at a per-process level and can be enabled ad hoc on any running server process. This is useful for tracing individual server-side processes … [Read more...] about Dynamic Oracle Net Server Tracing