what backup solution do you use?

[marist89]

Originally posted by TheSlob

Jeff, do you use a shell script to do hot backups of datafiles and archived redo logs or do you use veritas?

I use RMAN to backup the database and archived logs. That way I don't have to worry about which media manager (Veritas, Brightstor) I am using.

[grjohnson]

We have a 1/2 TB Datawarehouse in which we Hot backup daily and Cold Backup on Sundays. Also run exports on a number of schemas.

[Kumud]

1. Hot backup full every day
2. Archive log transfer to standby database every two hrs.
3. ORACLE HOME backup every day

[ronnie]

Originally posted by marist89

If you lose the filesystem that contains the Oracle software, your choices are:
1. restore the previous working software from tape.
2. re-install oracle

I prefer to restore the working software so I don't have to remember what options I had installed for this instance.

Is backing up only the oracle Home sufficient for this.

Dont we have to backup the registry (in case of windows) also because it has all the parameters.

Just restoring the software from the backup wont be enough.

Correct me if I am wrong.

Thanks

[marist89]

Originally posted by ronnie
Dont we have to backup the registry (in case of windows) also because it has all the parameters.

I don't know. I don't do Windoz.

[ronnie]

Originally posted by marist89

Originally posted by ronnie
Dont we have to backup the registry (in case of windows) also because it has all the parameters.

I don't know. I don't do Windoz.

I am sure that there must be something like the registry in unix also where information regarding oracle homes created on the server is stored along with lots of other info on the installed Home.

[pando]

there is no registry in unix, install linux in your PC and you will see

[Kishore]

Full Export every night
Hotbackup every night
Cold backup 15 days
Archivelog backup every 1 hour

[ronnie]

Originally posted by Kishore
Full Export every night
Hotbackup every night
Cold backup 15 days
Archivelog backup every 1 hour

Any advantage of taking a cold backup everyday when you take a Kot Backup everyday.

Originally posted by marist89
[Yes, Full Hot backup every day. In my environment, my Mean Time To Recovery (MTTR) is so short it doesn't make sense to use Incrementals.

How do you determine what your MTTR is and at what MTTR does a incemental backup makes sense.



[Edited by ronnie on 05-08-2002 at 12:55 PM]

[Kishore]

I mentioned that I am taking cold backup every 15 days not every day