Oracle financials backup Need help

[learner]

Sir,

Is it possible that I want to take backup of Oracle financials by Import / Export. If yes then kindly help me about this matter.

We are taking cold backup. By copy command and it take to much time approx 6 or 7 hour. And we do this activity in night.

Process of backup
1. Change Oracle services status manual.
2. Restart server.
3. Copy directories to another directories.
4. Change Oracle services status automatic.
5. Restart server.

Kindly give me some suggestion we did right or wrong.

Regards
M Asif

[admin]

AoA,
1- Import/Export will not work for Oracle Apps.
2- If you restart server daily it is risky as well as you are killing the performance so backup should be online using rman. Test the backups on another test machine frequently like weekly.

Thanks

[learner]

We did these activities in night and at that time here is no users and we take backup daily it necessary because of load our current backup folder are

<b> Folder name size </b>
OA 9.95 GB
ORADATA 58.7 GB

Thanks for your suggestion. Can you help me about rman.

Regards,
M Asif

[ahmadbilal]

Dear Admin,
one of my friend use export for Apps backup(althoush its not good practice)

[quote]AoA,
1- Import/Export will not work for Oracle Apps.
2- If you restart server daily it is risky as well as you are killing the performance so backup should be online using rman. Test the backups on another test machine frequently like weekly.

Thanks


<i><div align="right">Originally posted by admin

[smaamirj]

First of all u r taking abnormal backup if u just take the service manual and restart the server ,it means that database was shuting down in abort mode which is not consistent .

If u want to take the manual backup no need to restart the server ,just properly shutdown the services ,first of all applications services and then oracle service SID and then take the cold backup. But i still prefer to shutdown oracle database by connecting SQLPLUS as sys and using shutdown immediate. and after backup startup

To save time and space i strongly recommend RMAN because it will take block level backup in lesser time

[learner]

Can you give me one by step in detail.

Regards
M Asif

[admin]

Pl download the Apps Admin document from document section on this portal it covers full backup with RMAN. thanks

[smaamirj]

yes it is good atleast u should follow this. you can also perform incremental backup through rman to save time.

[learner]

Thanks all of you for given me a lot of useful information.

Regards,
M Asif