• Skip to primary navigation
  • Skip to main content
  • Skip to primary sidebar

The Geek Diary

CONCEPTS | BASICS | HOWTO

  • OS
    • Linux
    • CentOS/RHEL
    • Solaris
    • Oracle Linux
    • Linux Services
    • VCS
  • Database
    • oracle
    • oracle 12c
    • ASM
    • mysql
    • MariaDB
    • Data Guard
  • DevOps
    • Docker
    • Shell Scripting
  • Interview Questions
  • Big Data
    • Hadoop
    • Cloudera
    • Hortonworks HDP

oracle 12c

Oracle Database 12c2 : CPU_COUNT is Wrong

By admin

The Problem On Oracle database 12.2.0.1 version, cpu_count is not correct: OS has 128 CPU in total, however CPU_COUNT is only 104. SQL> show parameter cpu NAME TYPE VALUE ------------------------------------ ----------- ------------------------------ cpu_count integer 104 … [Read more...] about Oracle Database 12c2 : CPU_COUNT is Wrong

Filed Under: oracle, oracle 12c

Oracle Database – How to Rename a Datafile with Special Characters Created by Mistake

By admin

Question: We have mistakenly create a datafile with special charatcers. Also we get error ORA-01516 when we try to rename it using the normal method: sql> alter database rename file 'old_file_name' to 'new_file_name'; The Solution 1. Bring the Tablespace offline. sql> alter tablespace [tablespace name] offline; 2. Copy/Move the File at the OS level specifying the correct file name. 3. If there is no special character then the solution is: sql> alter database rename file … [Read more...] about Oracle Database – How to Rename a Datafile with Special Characters Created by Mistake

Filed Under: oracle, Oracle 10g, Oracle 11g, oracle 12c

Oracle Database 12c New Feature – Move a Datafile Online

By admin

In this release, a data file can now be moved online while it is open and being accessed, even for data files in system tablespace. Being able to move a data file online means that many maintenance operations, such as moving data to another storage device or moving databases into Oracle Automatic Storage Management (Oracle ASM), can be performed while users are accessing the system. This ensures that continuity of service and service-level agreements (SLA) on uptime can be met. With Oracle … [Read more...] about Oracle Database 12c New Feature – Move a Datafile Online

Filed Under: oracle, oracle 12c

How to rename database and then move datafile online in Oracle Database 12.2

By admin

This post illustrates how to rename a database in 12.2 and then move the datafiles to another location online (given the DB name is changed, we expect the datafile are moved to another directory whose directory name is the new DB name). We will rename database from ORCL122 to CDB122, and move datafiles from /refresh/home/app/oracle/oradata/ORCL122/ to /refresh/home/app/oracle/oradata/CDB122/ 1. backup database. 2. set ORACLE_SID to ORCL122. 3. shutdown database, and then start it to … [Read more...] about How to rename database and then move datafile online in Oracle Database 12.2

Filed Under: oracle, oracle 12c

How to Restore a Dropped Pluggable Database (PDB) in Multitenant Environment

By admin

Question: How to Restore Dropped PDB in Multitenant using Auxiliary instance ( For Single Instance Database)? In a multitenant container database (CDB), the metadata for data dictionary tables and view definitions is stored only in the root. However, each pluggable database (PDB) has its own set of data dictionary tables and views for the database objects contained in the PDB. So, a pluggable database (PDB) cannot be restored as a database. It must be restored as database object using an … [Read more...] about How to Restore a Dropped Pluggable Database (PDB) in Multitenant Environment

Filed Under: oracle, oracle 12c

How to Recover DROPPED PDB After Flashback of CDB

By admin

If flashback of CDB complete, there are chances to previously dropped PDB datafiles goes offline. There might be PDB dropped in past and now dropped PDB related datafiles becomes offline during flashback database. Example Backup of this database taken around scn 4700000. PDB3 was dropped at SCN 4800000. Flashback for CDB was complete until scn 4810629. Find the files those are offline (those are related to Dropped PDB i.e pdb3) sql> select file#,name from v$datafile; For this test, we … [Read more...] about How to Recover DROPPED PDB After Flashback of CDB

Filed Under: oracle, oracle 12c

Oracle RMAN 11g New Feature – MultiSection Backups

By admin

What are MultiSection Backups? By default, RMAN uses the parameters like filesize and number of available channels to decide whether to produce a single or multidatafile backupset with 1 or more backuppieces. In a multisection backup, RMAN creates a backup set in which each backup piece contains the blocks from one datafile section. A file section is a contiguous range of blocks in a datafile. The purpose of multisection backups is to enable RMAN to back up a single file in parallel. RMAN … [Read more...] about Oracle RMAN 11g New Feature – MultiSection Backups

Filed Under: oracle, Oracle 11g, oracle 12c

When to Use Startup/Shutdown Database and Alter Database Command in Oracle 12c

By admin

Before 12c there are only few commands available for startup and shutdown but if we follow that we may end up starting and stopping the PDBs and CDB as well. shutdown normal shutdown immediate shutdown abort startup startup nomount startup mount If we use one of these traditional shutdown methods at the container database (CDB) layer, we will bring down the CDB and the associated PDBs under it. This is something to be aware of when looking to reboot a container database. Let's take a … [Read more...] about When to Use Startup/Shutdown Database and Alter Database Command in Oracle 12c

Filed Under: oracle, oracle 12c

How to Startup/Shutdown PDB’s in Oracle Database 12c

By admin

Traditional startup/shutdown methods prior to 12c Traditional startup/shutdown command prior to 12c as as shown below. Shutdown Command SHUTDOWN NORMAL SHUTDOWN IMMEDIATE SHUTDOWN ABORT Startup Command STARTUP STARTUP NOMOUNT STARTUP MOUNT What happen when we execute shutdown immediate at CDB? If we use one of these traditional shutdown methods at the container database (CDB) layer, we will bring down the CDB and the associated PDBs under it. $ sqlplus / as sysdba SQL*Plus: … [Read more...] about How to Startup/Shutdown PDB’s in Oracle Database 12c

Filed Under: oracle, oracle 12c

How to upgrade RMAN catalog SCHEMA from 11g to 12.1.0.2 without upgrading the catalog database

By admin

Question: Our rman catalog database is 11.2.0.3 right now, do I need to upgrade the database to 12.1.0.2 first, and then upgrade the catalog to 12.1.0.2? The version of the RMAN catalog database does not need to match that of the recovery catalog. Therefore you can upgrade the RMAN catalog without upgrading the RMAN database. This is true of any version of the database, not only 12c. If you are intending to upgrade the catalog schema to 12c then you need to run these 2 … [Read more...] about How to upgrade RMAN catalog SCHEMA from 11g to 12.1.0.2 without upgrading the catalog database

Filed Under: oracle, Oracle 11g, oracle 12c, RMAN

« Previous Page
Next Page »

Primary Sidebar

Recent Posts

  • Failed to start LSB: Bring up/down networking – On restarting network service CentOS/RHEL (DHCP client)
  • How To Add Timestamps To dmesg Kernel Boot Log in CentOS/RHEL
  • How to disable ICMP redirects on CentOS/RHEL
  • What are Oracle Key Vault Roles
  • Archives
  • Contact Us
  • Copyright

© 2021 · The Geek Diary