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
oracle 12c
How To Convert A Partitioned Table To A Non-Partitioned Table Using DataPump In Oracle 11g and 12c
The Basics A new import DataPump parameter PARTITION_OPTIONS has been introduced with 11g. The allowed values are: NONE - Creates tables as they existed on the system from which the export operation was performed. This is the default value. DEPARTITION - Promotes each partition or subpartition to a new individual table. The default name of the new table will be the concatenation of the table and partition name or the table and subpartition name, as appropriate. MERGE - Combines all … [Read more...] about How To Convert A Partitioned Table To A Non-Partitioned Table Using DataPump In Oracle 11g and 12c
Step By Step Guide To Create Physical Standby On Normal File System For ASM Primary using RMAN
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
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