In this article, we are going to learn datapump performance tuning. The Datapump is a tool that helps us to create a database backup. There are a few ways to increase export backup performance listed below: DIRECT=Y PARALLEL=n DIRECT=Y During export backup, if we use direct=y, it’s allowed to skip …
Today we facing the ORA-19913 unable to decrypt backup error during RMAN backup restoration. After troubleshooting we found, this backup belonged to the encryption-enabled database and there is a wallet also configured. while backup restoration, open database in nomount state then check wallet status, it is showing closed. SQL> select …
how to get ddl for db_link in oracle with password, export db_link with password, drop db link, dbms_metadata.get_ddl dblink, get public db link ddl in oracle, drop db link in oracle. Viewing Information About Database Links Oracle has three data dictionary views listed below, which help us to find the …
In this article, we are going to check oracle database growth per month. Here we have to script one is for complete database growth and another one is to check growth as per tablespace level. Oracle Database Growth per month script Using the below query you can find out the …
In this article, we going to learn how to use the network_link parameter in oracle datapump export & import activity step by step. Case: Sometimes we need to move a table or schema from one database to another database but don’t have sufficient disk space on the production server. As …
Read moreData Pump Export Import Over the Network using network_link
Sometimes, we face ORA-14452 during drop or alter. SO, in this article, we are going to learn how to solve “ORA-14452: attempt to create” this error. We face this issue if the table is currently used in any other session, and we trying to drop or alter the table. Find …
Read moreORA-14452: attempt to create, alter or drop an index on temporary table already in use
In this article, we are going to discuss the oracle wait event “Streams AQ: enqueue blocked on low memory” due to this wait event we are facing a performance issue in the export backup, today my export backup was in a hung state and it takes a very long time. …
Read moreStreams AQ: enqueue blocked on low memory Oracle wait event
Applications regularly utilize some type of impermanent information store for processes that are too convoluted to finish in a solitary pass. Regularly, these transitory stores are characterized as data set tables or PL/SQL tables. From Oracle 8i ahead, the upkeep and the board of transitory tables can be assigned to …
Hello, friends in this article we are going to learn how to schedule database export backup automatically. Yes, it is possible to export backup automation with a crontab scheduler. How to schedule Export Backup Using shell scripting, we can schedule the export backup as per our convenient time. Using the …
How to automate Oracle RMAN Backup with shell script In a real environment, you obviously won’t manually trigger all of the Oracle database backups. An automated mechanism is required to enable RMAN backups. In this article, we’ll look at automating RMAN backup using a shell script. Create Backup Location On …