Taking backup in user managed backup

Asked By hudson davila 10 points N/A Posted on - 03/08/2012

Hi,

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.

• Status: Open
• Question Views: 797
• Answer Count: 1
• Vote Up 0 Vote Down

• Answer Accepted: No
• Question Category: Oracle Database

Answered By Kanhai Else 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.

Thanks.

About Kanhai Else

Questions
0

Answers
56

Best Answers
8

• Vote Up 0 Vote Down

• Posted on - 03/18/2012
• Question Category: Oracle Database