CODEWITHSUNDEEP
oracle-databaseoracle11gdatabase-administration
WayneVig
WayneVig

Reputation: 60

Is there any other way that we can take auto backup in oracle 11g apart from RMAN?

I have tried with RMAN. But is there any other possible way that we can backup database and tables. backup using queries or stored procedures is possible?

Upvotes: 1

Views: 330

Answers (3)

doc123
doc123

Reputation: 106

You can take logical backup like export utility and latest one datapump. Using datapump if you want to take backup (query based) then you can use "expdp" utility as following....

expdp scott/password@tstdb schemas=SCOTT include=TABLE:"IN ('DEPT')" query=emp:"where deptno > 10" directory=TESTDP_DIR dumpfile=SCOTT-expdp.dmp logfile=SCOTT-expdp.log

After taking backup of DEPT table you can import in your database any time using utility of "impdp".

Upvotes: 1

mmmmmpie
mmmmmpie

Reputation: 3029

Yes there is a way but in my opinion its a bad one.
Investigate the DBMS_BACKUP_RESTORE package:
Example control-file recovery: 

DECLARE
devtype varchar2(256);
done boolean;
BEGIN
devtype := dbms_backup_restore.DeviceAllocate (type => '',ident => 'FUN');
dbms_backup_restore.RestoreSetDatafile;
dbms_backup_restore.RestoreDatafileTo(dfnumber => 1,toname => 'D:\ORACLE_BASE\datafiles\SYSTEM01.DBF');
dbms_backup_restore.RestoreDatafileTo(dfnumber => 2,toname => 'D:\ORACLE_BASE\datafiles\UNDOTBS.DBF');
--dbms_backup_restore.RestoreDatafileTo(dfnumber => 3,toname => 'D:\ORACLE_BASE\datafiles\MYSPACE.DBF');
dbms_backup_restore.RestoreBackupPiece(done => done,handle => 'D:\ORACLE_BASE\RMAN_BACKUP\MYDB_DF_BCK05H2LLQP_1_1', params => null);
dbms_backup_restore.DeviceDeallocate;
END;
/

RMAN is Oracle's recovery management tool and it should be used to take and validate your backups. If you are using a expdp method to backup your database you are simply taking a snapshot and snapshots are not backups.

Upvotes: 1

Sabe
Sabe

Reputation: 176

You can use Oracle SQL Developer to do a database backup. Go to Tools ---> Database Export...

Upvotes: 1

Related Questions