Backup Solution ???

[antilles]

i am relatively new to the Oracle backup scene and I need to get some ideas and clarification on a few things. Any help would be appreciated.

1st. During a Hot Backup what actually occurs? Does oracle release the online redologs to be backed up?

2nd. If I had a database failure and I had a full (Oracle_Home) backup from Monday and all of the Archive logs from Tuesday night at 1100 pm Then the Database blewup on Wednesday morning at 600 am. Could I theoritically restore the database to the way it was at 1100 pm on Tuesday with my archive logs and the Monday full backup.

Thanks

[marist89]

1. online redo logs don't get backed up in a hot backup. See http://www.dbasupport.com/oracle/scr...ckup_Recovery/ for scripts, http://www.dbasupport.com/oracle/faq...ckup_Recovery/ for questions, and http://technet.oracle.com/docs/produ...a76993/toc.htm for details.

2. Yup, that's the way it works.

[antilles]

So let me get this straight for #2

I get a full Cold backup on the entire Oracle_home on, lets say, Saturday night. The every Sunday Through Friday night, all I have to copy is the new archive logs.

3. How do I know which logs to copy every night?

[gopi]

I believe you can also do better than that (the 1100 recovery) if the 1100 archive log was the last archived log.

If you multiplexed the online redo logs and were able to salvage one of them, you would be able to recover to the last committed transaction. (again the 1100 archive log was the last archived log and you were able to get your hands on one of the multiplexed redo log).

Jeff, I'm learning too.. please help and correct where necessary.

thanks!

[marist89]

Originally posted by antilles
So let me get this straight for #2

I get a full Cold backup on the entire Oracle_home on, lets say, Saturday night. The every Sunday Through Friday night, all I have to copy is the new archive logs.

In theory, yes. However, understand that if you backup on Saturday night and have a failure on Saturday morning, you will be recovering a whole weeks worth of transactions. If this is compatible with your Mean Time To Recovery (MTTR) window, then go for it.

3. How do I know which logs to copy every night?

[/B]
either by the timestamp of the file or v$archived_log.

[stecal]

Some technical clarification is in order here--

When you say a "full (Oracle_Home)" backup, what exactly do you mean?

You do not need to backup the Oracle program files (which are found under Oracle_Home). You do need to backup the datafiles - are they under your Oracle_Home directory and that is why you are saying Oracle_Home?

If you placed your datafiles under $ORACLE_HOME, shame on you. Flog yourself for ten minutes, then go look up information on Oracle's Optimal Flexible Architecture (OFA). One of the main points of OFA is to keep your program files (executables, libraries, Oracle-supplied scripts, etc.) separate from your datafiles.

[antilles]

I did not place the data files under the Oracle Home. The are under oracle\proddb on 4 separate drives. Is there good documentation on how to recover and set which archive logs to execute.

[Tarry]

query v$log_history to see which logfiles to use.
but if you automate the recovery, oracle will suggest itself which logfiles to use. you can(if not automating the recovery) set the recovery(incomplete) to until time/scn/cancel/logseq(rman).
that way you can bring the db to a certain point in time(DBPITR).
Read more about it in the.................
http://otn.oracle.com/docs/products/...a76993/toc.htm
I suggest you read this book completly.
also read the rman....
http://otn.oracle.com/docs/products/...a76990/toc.htm

It'll help explain things better.......

cheers!!!