Mir Sayeed Hassan – Oracle Blog

Script to check the tablespace size used in Oracle database

[oracle@testdb scripts]$ pwd
 /home/oracle/scripts

[oracle@testdb scripts]$ cat checktbs.sql
 set linesize 180
 set pagesize 30
select
 fs.tablespace_name "Tablespace",
 (df.totalspace - fs.freespace) "Used MB",
 fs.freespace "Free MB",
 df.totalspace... 
Read more..			

Shutdown and Startup the Oracle RAC Database Manually

=============================

Shutdown the RAC Database Manually

================================

The below scenario is tested in our test env, below are the steps as followed:

Check the status of database

[oracle@test-rac2 ~]$... 
Read more..			

ORA-19504/ORA-17502/ORA-15005 – RMAN Backup Failed to create the file in +ORADATA

The below scenario occur in one of my RAC Production database.

We would like to take the backup of the full database/incremental database by using the user defined location in +ORADATA

[oracle(af2db2)@afcdb2]$ . oraenv
ORACLE_SID = [afcdb2] ?... 
Read more..			

Login with Oracle user & create the mnt directory

[oracle@testdb ~]$ pwd
/home/oracle

[oracle@testdb ~]$ mkdir mnt

[oracle@testdb mnt]$ pwd
/home/oracle/mnt

Login as the root & create the mount_nas.sh file

[root@testdb scripts]# cd /home/oracle/scripts/

Configure multiple IP Address with single default port 1521

sys@TESTDB> select INSTANCE_NAME,VERSION,STATUS from v$instance;

INSTANCE_NAME    VERSION           STATUS
---------------- ----------------- ------------
testdb           11.2.0.4.0        OPEN

Configure the listener

Recycle bin concept in Oracle database 11gR2

Recycle bin is similar to windows recyclebin in Oracle database & here the entire drop object is stored in FLASHBACK Area

As per my recycle bin its a virtual where all the dropped objects reside in it, It occupy the exact space as when they are created in database, In case if the table “test”...