expdp as sysdba

By Ravi Karamsetty | October 21, 2015 |

Here is the simple command to run expdp (data pump export) as sysdba. expdp \”/as sysdba\” parfile=exp_user.par

Read More

Oracle Database consistent backup using expdp

By Ravi Karamsetty | July 31, 2015 |

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 … Continue reading “Oracle Database consistent backup using expdp”

Read More