Oracle folders to backup [message #648395] |
Tue, 23 February 2016 00:47 ![Go to next message Go to next message](/forum/theme/orafaq/images/down.png) |
kilimanjaro
Messages: 151 Registered: May 2009 Location: Tanzania
|
Senior Member |
|
|
Hello Buddies
Please if someone can help.
I have installed an oracle database to a client .Now the issue is backup using Iperius backup.I know how to use Rman, but this client don't want/like the SQL stuff.MY question is which folder/Folders to backup using Iperius?
Thank you.
|
|
|
|
|
Re: Oracle folders to backup [message #648401 is a reply to message #648400] |
Tue, 23 February 2016 01:12 ![Go to previous message Go to previous message](/forum/theme/orafaq/images/up.png) ![Go to next message Go to next message](/forum/theme/orafaq/images/down.png) |
![](http://www.orafaq.com/forum/images/custom_avatars/102589.gif) |
Michel Cadot
Messages: 68650 Registered: March 2007 Location: Nanterre, France, http://...
|
Senior Member Account Moderator |
|
|
Oh, if you want to backup the database then backup all database files.
See v$datafile, v$tempfile, v$controlfile views.
Don't forget to put your database in backup mode when you backup the files, or stop the database. The former requires your database to be in ARCHIVELOG mode which should be the prime rule for, at least, all production databases.
In this case, also backup the archived logs, see v$archived_log view.
You can add the backup of password file and parameter file (most often in %ORACLE_HOME%\database or %ORACLE_HOME%\dbs).
|
|
|
|
|
|
Re: Oracle folders to backup [message #648438 is a reply to message #648402] |
Tue, 23 February 2016 06:41 ![Go to previous message Go to previous message](/forum/theme/orafaq/images/up.png) ![Go to next message Go to next message](/forum/theme/orafaq/images/down.png) |
![](http://www.gravatar.com/avatar/d29f577f753cb4b873212fd5ed0da4cd?s=64&d=mm&r=g) |
EdStevens
Messages: 1376 Registered: September 2013
|
Senior Member |
|
|
kilimanjaro wrote on Tue, 23 February 2016 01:22So Michel You mean I should backup the oradata folder and ?
Your questions suggest that you have an overly simplistic view of backing up a database. You said that you know how to use rman. But your line of questioning indicates you don't understand what rman is actually doing, and believe it is as simple as taking an OS backup of a directory. And since you are asking "what directory to backup" it strongly suggests you don't even know where oracle keeps what needs to be backed up, or understand how to find out.
I don't care if your client likes or dislikes rman. If they have an oracle database and value that database, they better learn to like it. It is the backup and recovery tool for rman databases. That's like saying "I want to be able to change a flat tire on my car, but I don't want to use the jack, lug wrench, and spare tire that the car's manufacturer placed in the trunk for that very purpose."
It would appear that they, too, have an overly simplistic view of database backup and recovery.
Are there any plans to actually prove the ability to recover from the backups with zero data loss?
|
|
|
|