I have this question, it sound not too wise but I want to prove it to someone it's not right. Any way, I took over this client and I asked them how they run their back up. The answer I got from them is they backup the whole server every Sunday, and incremental every night. Is that right to do ??? I thought we have to backup the database to somewhere say a disk on different location and then backup that disk.
Please let me know it's right to backup the whole server. What is the advantage& disadvantage of backing up the whole server ??? What is the consequence when we try to recover ??? Please give me as much senerios as possible.
OFF-LINE backups are simple and provide limited recovery, you can only recover up to point of your last backup. If they are backing up the server whilst the database is shutdown this is ok.
ON-LINE backups are so called because they are performed whilst the database is open. If your company is 'backing up' the whole server whislt the database is open then this back up is useless as your datafiles will not be consistent. An actual on-line backup procedure is needed where you place each tablespace into backup mode individually and copy the files.
INCREMENTALS are database exports, only of the data that hasd changed since the last incremental export.
The correct type of backup must be decided and implemented.
For me I backup the database off-line every weekend and take a full export daily. I could then restore the datafiles and import the latest data I have if necessary.
If your company are not shutting down oracle whilst they back up there server then they have no usable backups.