Oracle Database consistent backup using expdp

Use the following procedure to take the consistent backup using expdp (oracle’s datapump export utility) Stop application activity(transactions) against database.  This will ensure you that you don’t loose any transactions . 1. Make sure there are no pending transactions by running the following SQL: SQL> select count(*) from v$transaction; Above query should return with zero […]