Mir Sayeed Hassan – Oracle Blog

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”...

ORA-39213/ORA-39006: Metadata processing is not available, internal error

[oracle@testdb ~]$ expdp system directory=db_dump dumpfile=full_db26feb18.dmp logfile= full_db26feb18.log full=yes

Export: Release 11.2.0.4.0 – Production on Mon Feb 26 16:03:01 2018
Copyright (c) 1982, 2011, Oracle and/or its affiliates All rights reserved.

RMAN database restore from lower version (11.2.0.1) to 11.2.0.4 by using upgrade in Oracle database 11gR2

Copy the datafiles, archivelog files and controlfile from real database to restore backup location by using the NC or Winscp or any suitable method

First verify the real database version:

[oracle@realdb backup]$ !sq
 sqlplus... 
Read more..