Taking backup in user managed backup

Asked By 10 points N/A Posted on -


I have oracle database. Is there any way to take incremental backup's in user managed backup's without using RMAN. Please explain with the procedure.

Answered By 0 points N/A #102662

Taking backup in user managed backup


Without using RMAN you can try with the following different methodologies.

1. Query the views dba_data_files, dba_temp_files, logfile and controlfile to find all files and back them up for a new database.

2. Use IMPDP and EXPDP found in BIN folder of Oracle to backup tables, schema,whole database.

3. Use standard feature in oracle “Enterprise Manager”.

4. In order to Import and export, Use imp & exp present in BIN directory.

The easiest method to copy Oracle Database contents to an existing instance is export/import. Export the source, drop all schemas in the target and then import.

However if you have the control, datafile, logfiles, then you can configure them any time you need.


Login/Register to Answer

Related Questions