To restore the archive logs from RMAN backup, we need to reset the default location of archivelogs otherwise RMAN restores it’s on the default location, to change archivelogs location we used the SET ARCHIVELOG DESTINATION command. Steps to restore archive logs from RMAN backup Your Database must be in mounted open or open mode. start RMAN …
Hello, friends in this article we are going to discussed how to Storing RMAN output in a logfile. What is the RMAN log file? RMAN log file is a just text file that stores the complete output of RMAN commands. Generally, this file is used to check the backup has …
Hello friends, in this article we learn how to check RMAN backup status and timings on the target database. Using the following command you will get the details about currently running RMAN and ARCHIVE backup. Click Here for YouTube Query to check RMAN backup status Using below query you can get …
How to Remap table during import? REMAP TABLE/SCHEMA/TABLESPACE parameter, Like you want to import a table from your existing logical backup (export backup), but the table already exists. So in this situation, how to import that table because, so in this case you can import this table with another name …
How to set limit the file size of dumpfile in Datapump ? In this article we are going to discussed how to split the datapump dumpfiles, actually the FILESIZE parameter is used to set limit the dumpfile size. For eg., if you want to limit your dumpfiles to 50m, you can issue use …
Read moreHow to split the datapump dumpfiles || limit the file size of dumpfile in Datapump
In this tutorial we are going to describe oracle data pump utility step by step. What is Data Pump Utility? Oracle Data Pump is a very fast and high-speed utility. Through the Data Pump utility, we can move data and metadata from one database to another database very fast. Oracle …
Hello friends my name is Shripal Singh and in this article, I’m going to show you three topics related to Oracle Data Pump EXPORT & IMPORT, listed below. Oracle Data Pump 10g, 11g, 12c, 18c, 19c Oracle Data Pump is an alternative to the “exp” and “imp” utilities which is …
Hello friends In this article, we going to discuss how to import view only using impdp from the old dump file. How to import view only from export backup Someone asked me how to restore a single view or all view only using impdp from any dump file. So my …
Hello, friends in this article we are going to discuss how to display all the tables in a schema with foreign key relations and the number of records for the parent and the child tables. How to Display all the tables with foreign key The following query will solve our …
Hello friends, in this article we are going to discussed how to take export backup with date and time, so follow me step by step. In Oracle the EXPORT dump file name including Date and Time. If you are taking export backup using EXP command the use below formats to …