Posted by Mir Sayeed Hassan on 27th July 2020
HOW TO INSTALL THE ORACLE LINUX 8.2 (64 bit) Step by step procedure to perform the Installation of the ORACLE LINUX 8.2 (64 bit). Oracle ISO can be downloaded from edelivery: https://edelivery.oracle.com/osdc/faces/Home.jspx & To download this Create an account or use… Read more..
Posted in DB Install & Create | Comments Off on HOW TO INSTALL THE ORACLE LINUX 8.2 (64 bit)
Posted by Mir Sayeed Hassan on 26th July 2020
ORA-55641: Cannot drop tablespace used by Flashback Data Archive I was trying to drop the tablespace from the test database & got the below error LOGIN TO DATABASE [oracle@testdb ~]$ sqlplus / as sysdba SQL*Plus: Release 11.2.0.4.0 Production on Sun Jul 26 05:17:21 2020 Copyright (c) 1982, 2013, Oracle. All rights reserved. Connected… Read more..
Posted in ORA-Error | Comments Off on ORA-55641: Cannot drop tablespace used by Flashback Data Archive
Posted by Mir Sayeed Hassan on 25th July 2020
How to export the data of 1 week by using the expdp in Oracle database 11gR2(11.2.0.4) To perform this 1 week of export of data between the given date, fallow the below procedure. CREATE A DIRECTORY AT OS LEVEL [oracle@testdb_new backup]$ mkdir dumpbkp CREATE A DIRECTORY AT DB LEVEL SQL> create directory… Read more..
Posted in Datapump (Expdp/Impdp) | Comments Off on How to export the data of 1 week by using the expdp in Oracle database 11gR2(11.2.0.4)
Posted by Mir Sayeed Hassan on 20th July 2020
How to delete the backup which is no longer needed or obsolete in Oracle database using RMAN Note: You can delete the backup which is not needed as per the rman configuration policy set Check the RMAN Configuration policy RMAN> show all; using target database control file instead of recovery catalog RMAN configuration parameters… Read Read More
Posted in RMAN | Comments Off on How to delete the backup which is no longer needed or obsolete in Oracle database using RMAN
Posted by Mir Sayeed Hassan on 20th July 2020
How to backup Individual Database files like Tablespace, Datafiles, Archivelogs, Spfile, Controlfile by using RMAN BACKUP OF ALL ARCHIVELOG RMAN> backup archivelog all; Starting backup at 20-JUL-20 current log archived using channel ORA_DISK_1 channel ORA_DISK_1: starting archived log backup set channel ORA_DISK_1: specifying archived… Read more..
Posted in RMAN | Comments Off on How to backup Individual Database files like Tablespace, Datafiles, Archivelogs, Spfile, Controlfile by using RMAN
Posted by Mir Sayeed Hassan on 16th July 2020
How to fix “SSH – “REMOTE HOST IDENTIFICATION HAS CHANGED” in Oracle Linux This Warning has occur in one of our database while trying to connect by using SSH General Information: The SSH/Secure shell is to securely login to the remote machine by using the SSH & ensuring that our connection is secure. Warning message… Read More
Posted in ORA-Error | Comments Off on How to fix “SSH – “REMOTE HOST IDENTIFICATION HAS CHANGED” in Oracle Linux