Mir Sayeed Hassan – Oracle Blog

Oracle DBA – Tips & Techniques | Learn with real-time examples

HOW TO INSTALL THE ORACLE LINUX 8.2 (64 bit)

Posted by Mir Sayeed Hassan on July 27th, 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)

ORA-55641: Cannot drop tablespace used by Flashback Data Archive

Posted by Mir Sayeed Hassan on July 26th, 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

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 July 25th, 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)

How to delete the backup which is no longer needed or obsolete in Oracle database using RMAN

Posted by Mir Sayeed Hassan on July 20th, 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 more..

Posted in RMAN | Comments Off on How to delete the backup which is no longer needed or obsolete in Oracle database using RMAN

How to backup Individual Database files like Tablespace, Datafiles, Archivelogs, Spfile, Controlfile by using RMAN

Posted by Mir Sayeed Hassan on July 20th, 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

How to fix “SSH – “REMOTE HOST IDENTIFICATION HAS CHANGED” in Oracle Linux

Posted by Mir Sayeed Hassan on July 16th, 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

« Previous Entries
Next Entries »