Page 1 of 1
Oracle financials backup Need help
Posted: Tue Jan 16, 2007 1:22 am
by 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
Posted: Tue Jan 16, 2007 3:39 am
by 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
Posted: Tue Jan 16, 2007 4:09 am
by 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
Posted: Tue Jan 16, 2007 6:43 am
by 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
Posted: Tue Jan 16, 2007 9:16 am
by 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
Posted: Tue Jan 16, 2007 9:42 am
by learner
Can you give me one by step in detail.
Regards
M Asif
Posted: Wed Jan 17, 2007 1:01 am
by admin
Pl download the Apps Admin document from document section on this portal it covers full backup with RMAN. thanks
Posted: Wed Jan 17, 2007 2:00 am
by smaamirj
yes it is good atleast u should follow this. you can also perform incremental backup through rman to save time.
Posted: Wed Jan 17, 2007 11:14 am
by learner
Thanks all of you for given me a lot of useful information.
Regards,
M Asif