Contact

Tag: oracle logical backup

  1. You are here »
  2. Home »
  3. Tag »
  4. oracle logical backup »

expdp as sysdba

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

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 […]

Categories