‘3. Backup and Recovery’

Backup: Expdp/impdp database full export without password

Expdp/impdp database full export without password expdp Note: It will create a consistent dumpfile, which can be used to import full database, schema etc. expdp \”/ as sysdba\” FLASHBACK_TIME=\”TO_TIMESTAMP\(TO_CHAR\(SYSDATE,\’YYYY-MM-DD HH24:MI:SS\’\),\’YYYY-MM-DD HH24:MI:SS\’\)\” directory=DIR_NAME full=y dumpfile=full_DB.dmp logfile=full_db.log compression=all impdp Note: While importing you need not to mention the flashback option. impdp \’/ as sysdba\’ directory=DATAPUMP_DIR dumpfile=full_DB.dmp logfile=impfull_db.log […]

April 16, 2014 · Sanjay · No Comments
Posted in: 3. All Scripts, 3. Backup and Recovery

Backup: Expdp/impdp database full export.

Expdp/impdp database full export. You must ensure there is enough space to store the dump  under the mount point having directory location. expdp expdp user/pwd DIRECTORY=DIR_NAME DUMPFILE=full_db.dmp logfile=full_db.log FULL=y impdp expdp user/pwd DIRECTORY=DIR_NAME DUMPFILE=full_db.dmp logfile=imp_full_db.log FULL=y

April 16, 2014 · Sanjay · No Comments
Posted in: 3. All Scripts, 3. Backup and Recovery

Backup: Expdp/impdp estimate the dump size without real export.

Expdp/impdp estimate the dump size without real export. expdp \’/ as sysdba\’ directory=DATAPUMP_DIR full=y ESTIMATE_ONLY=y

April 16, 2014 · Sanjay · No Comments
Posted in: 3. All Scripts, 3. Backup and Recovery

Backup: Expdp/impdp directory, SCN, timestamp and consistent

Expdp/impdp directory, SCN, timestamp and consistent As you know expdp is a logical backup not the physical one. It works in same version also you can expdp/impdp from lower to higher version. Oracle is very restricted expdp/impdp from higher to lower version. There are few important things you should keep in mind. 1. Create directory, if […]

April 16, 2014 · Sanjay · No Comments
Posted in: 3. All Scripts, 3. Backup and Recovery