What would you recommend as the software to use to backup and restore apps 10 database?
I am looking for something quick and easy to allow me to carry out ad-hoc backup and restores
Solved
IFS APPS10 database backup and restore tool
Best answer by RanukaSerasinghe
This topic has been closed for comments
+7
Thank you Ranuka, it is unusual that software comes with good recovery software. I am so used to having to use 3rd party software
thank you again
Mick
+7MickCOl wrote:
Thank you Ranuka, it is unusual that software comes with good recovery software. I am so used to having to use 3rd party software
thank you again
Mick
As described above, its always safe to go with the recommendations. 
+15It is always better and recommended to use Oracle utility to do the actions required on the database end. So that if any problems come up we could get help from Oracle Support according to the support agreement. When you use third-party tools we cannot even get help from Oracle if something goes wrong. So both IFS and Oracle recommend using Oracle utility to do any action on the database end.
In your scenario, RMAN is the oracle utility used for Backup and Restoration.
Ragaventhan S - https://www.linkedin.com/in/ragaventhan-sathananda/
+18MickCOl wrote:
What would you recommend as the software to use to backup and restore apps 10 database?
I am looking for something quick and easy to allow me to carry out ad-hoc backup and restores
Hi,
Recovery Manager (RMAN) is an in-built command line based utility recommended for DB backups and Recovery. Almost all third party DB backup tools which provide a GUI interface, invoke RMAN commands in the background to perform the backups.
Oracle exclusively developed RMAN for backup and recovery purposes and it is already included as part of your DB license.
It is also cost effective to learn RMAN backup and restore commands, instead of paying for a third party tool, unless you are looking for a GUI interface.
There are lot of self-learning resources available online.
Following URL seems as a useful resource to take the database backup using RMAN. It is taken from the official Oracle website.
https://docs.oracle.com/cd/E11882_01/backup.112/e10642/rcmquick.htm#BRADV90059
It is always better and safe to try this in a test environment first.
+12
According to above documentation there is two main ways of taking Oracle DB backups and below are the articles for restoring them.
Online Backup (RMAN) restoration: Using RMAN to Back Up and Restore Files (oracle.com)
Offline Backups (Data file copy): https://docs.oracle.com/cd/E29597_01/backup.1111/e10642/osadvsce.htm
Chathuranga Samarakoon
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.