| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
 |
 | |||
| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
|
| |||
Home -> Community -> Mailing Lists -> Oracle-L -> RMAN question(s)
Hi all -
I inherited an RMAN environment and discovered something doing test restores to a different server that I would like to bounce off those smarter than I. The current backups do a "backup database", "crosscheck archivelog all", and then a "backup archivelog until time 'SYSDATE' delete input". This runs every night with no other backups.
What I found during testing is that the archivelog needed to make the database consistent is not backed up until the following night's backup. I added TAGs to the script to help me figure this out.
Here is the *last* piece of the database backup. Even though the database backup starts at 2:32am, it doesn't get to the last piece until 2:47. 9.2.0.6, standard edition, only one channel allowed. :-(
BS Key Type LV Size Device Type Elapsed Time Completion Time
------- ---- -- ---------- ----------- ------------ --------------------
52403 Incr 0 5G DISK 00:11:35 26-AUG-2007 02:59:22
BP Key: 52406 Status: AVAILABLE Tag:
SUN_DB_L0_AUG_26_2007_0232AM
Piece Name: /a2r1_05/backup/tiros/data/tiros_cciqan2j_1_1
List of Datafiles in backup set 52403
File LV Type Ckp SCN Ckp Time Name
---- -- ---- ---------- -------------------- ----
4 0 Incr 286426915 26-AUG-2007 02:47:47
And here is the *first* piece of the *next* night's archivelog backup:
BS Key Size Device Type Elapsed Time Completion Time
------- ---------- ----------- ------------ --------------------
53164 387M DISK 00:00:38 27-AUG-2007 03:00:45
BP Key: 53171 Status: AVAILABLE Tag:
MON_ARCH_AUG_27_2007_0232AM
Piece Name: /a2r1_05/backup/tiros/arch/tiros_cniqdc5n_1_1
List of Archived Logs in backup set 53164
Thrd Seq Low SCN Low Time Next SCN Next Time
---- ------- ---------- -------------------- ---------- ---------
1 83018 286424750 26-AUG-2007 02:38:10 286428432 26-AUG-2007
03:08:04
As noted above, the checkpoint time of the database backup is "26-AUG-2007 02:47:47" and the low time of the archivelog backup is "26-AUG-2007 02:38:10" so when I restore the database to the checkpoint time RMAN wants/needs the archivelog from the *next* nights backup. I feel this opens me up to unnecessary exposure and am thinking of changing the database backup to include "plus archivelog" so I can guarantee I can recover to a consistent state with a single night's backup. Indeed, that is what I have always done in the past. I will probably add some archivelog backups during the day, as well.
My question is what do people around here do? Backup database and backup archivelog? Backup database...plus archivelog? I realize this is somewhat "nuancy" but, personally, I like the idea of at least being able to get the database back (and opened) with a single night's backup that is copied to tape. Opinions/thoughts/experiences?
Thanks,
-joe
Confidentiality Note: This message contains information that may be confidential and/or privileged. If you are not the intended recipient, you should not use, copy, disclose, distribute or take any action based on this message. If you have received this message in error, please advise the sender immediately by reply email and delete this message. Although ICAT Managers, LLC scans e-mail and attachments for viruses, it does not guarantee that either are virus-free and accepts no liability for any damage sustained as a result of viruses. Thank you.
-- http://www.freelists.org/webpage/oracle-lReceived on Mon Aug 27 2007 - 17:15:00 CDT
 |
 |