Drop a Oracle RAC Database

I am demonstrating how we can drop the database in RAC environment manually in Oracle12c(12.1.0.2.0) version.

I have two node RAC and the database name is TEST.  The instance names are TEST1 & TEST2.

  1. Verify the instance

[oracle@host01 ~]$ srvctl status database -d TEST
Instance TEST1 is running on node host01
Instance TEST2 is running on node host02

[oracle@host01 ~]$ crsctl status resource -t
--------------------------------------------------------------------------------
Name Target State Server State  (more...)

Oracle Cloud (DBaaS): Migration “On-prem” database to Cloud Using RMAN Cross-Platform Transportable PDB

This article was written by Skant Gupta and Joel Perez in Oracle OTN.

If you want to be updated with all our articles send us the Invitation or Follow us:

Joel Perez’s LinkedIn: www.linkedin.com/in/SirDBaaSJoelPerez

Skant Gupta’s LinkedIn: www.linkedin.com/in/skantali/

or Join our LinkedIn group: Oracle Cloud DBaaS

This method can be used only if the on-premises platform is little endian, and the database character sets of your on-premises database (more...)

How To Find DBID in NOMOUNT State

Oracle Database identifier in short DBID is an internal, unique identifier for an Oracle database. Database administrator must note down the DBID in safe place, so that any miss-happening to the database could be easily identified and recovered. In case it is required to recover SPFILE or control file from autobackup, such as disaster recovery, you will need to set DBID. So lets see how to get DBID in NOMOUNT State.
Why DBID is important? (more...)

Schema and Non-Schema Objects in Oracle Database

Oracle database contains schema objects like views, tables, triggers etc., and several other types of objects which are also stored in the database but are not contained in a schema.

A schema is a collection of logical structures of data, or schema objects which is owned by a database user and has the same name as that of the user. Schema objects can be created and manipulated with SQL and include the following types (more...)

FINDING SCHEMA SIZE FOR A ORACLE DATABASE

SQL> BREAK ON REPORT
SQL> COMPUTE SUM LABEL TOTAL OF "Size of Each Segment in MB" ON REPORT
SQL> select segment_type, sum(bytes/1024/1024) "Size of Each Segment in MB" from dba_segments where owner='SYS' group by segment_type order by 1;

 

The post FINDING SCHEMA SIZE FOR A ORACLE DATABASE appeared first on ORACLE-HELP.

ORA-00245: Control File Backup Failed; Target is Likely on a Local File System

In alert log I got an issue ORA-00245: control file backup failed; target is likely on a local file system. Regarding this issue, I checked the snapshot control file location on rman prompt and observed that it was on local file system. In RAC environment, Snapshot control file backup location should be on a shared disk group so that it can be visible or accessible to all RAC nodes.
Check the configured snapshot controlfile (more...)