Oracle DBA

 Steps to take backup using expdb in oracle database:

How to take the backup of a object using expdb?

Step1: created directory /data/backup using mkdir -p /data/backup


Step2: 

created directory test_dir as '/data/backup';


What is the meta data table to see details for directories?

Desc dba_directories;

select Owner,DIRECTORY_NAME from dba_directories where DIRECTORY_NAME ='DIRECTORNAME';


Step3: Taking backup using expdb in linux:

Here is the command to take the backup using expdb:

expdp tables=U1.T2 directory = TEST_DIR dumpfile = Table.dmp logfile = Table.log

Note: Two files will be created one is dump file and another one log file.

Backup successfully done as below.











Comments

Post a Comment

Popular posts from this blog

Image
Oracle Export Metadata only And Import the Metadata only Guide – Step-by-Step Tutorial Scenario : Client is wanted to export and import the metadata In this guide, we will learn how to use expdp (Data Pump Export) and impdp (Data Pump Import) in Oracle Database to back up metadata and restore the same only. To create a backup, first we have to set up a physical backup location. Creating a Backup location: On Linux server: mkdir -p /data/backup On Oracle Database: Command: create a directory TEST_DIR2 as '/data/backup'; Here, TEST_DIR2 is a logical directory pointing to the physical backup location. To verify the directory: SELECT * FROM dba_directories WHERE directory_name = 'TEST_DIR2'; Exporting a Metadata using expdp: To backup the Metadata for Schema U2,  expdp schemas=U2 directory=TEST_DIR2 dumpfile=schdata_only2.dmp logfile=schdata_only.log content=METADATA_ONLY Note:   Dump File (.dump): A binary file generated by expdp that contains exported schema objects, data...
Read more
Image
How to Delete RMAN Backups in Oracle: Step-by-Step Guide Managing Oracle RMAN backups effectively is essential for optimizing storage space and database performance . In this guide, we will explore how to delete RMAN backups , understand the role of the control file , and handle expired backups properly. 🗑 ️ How to Delete Backups in Oracle RMAN? To delete backups, follow these steps: 1️ ⃣ Deleting Backups Using RMAN (Recommended Method) ✅ First, connect to RMAN: rman traget / ✅ To delete all backups in a specific location: Delete backup; This command removes all backups from the physical storage and updates the control file accordingly. Deleting Backups Using Linux rm Command (Manual Method) Instead of using RMAN, you can delete backup files manually from the operating system: cd /your/backup/location rm -rf * or rm -rf filename. Here in this case, used only filename. 🚨 Warning : This method does not update the control file , so Oracle still thin...
Read more
Image
Oracle Export Previous SCN Data & Import into an Existing Table – Step-by-Step Guide Scenario: In this guide, we will explore how to use Oracle Data Pump Export (expdp) and Import (impdp) to back up historical data from a previous SCN (System Change Number) and restore it into an existing table. This approach is useful when you need to retrieve older data while preserving the table structure. Step 1: Setting Up a Backup Location Before exporting data, we need to create a physical backup location where the dump files will be stored. On Linux server: mkdir -p /data/backup On Oracle Database: We create a logical directory pointing to the physical backup location: Command: create a directory TEST_DIR2 as '/data/backup'; TEST_DIR2 -->  Logical directory pointing to the physical backup location. To verify the directory: SELECT * FROM dba_directories WHERE directory_name = 'TEST_DIR2'; Step 2: Checking Current Table Data Inserted few more records Before exporting, ...
Read more