RE: [QUAR] RE: What are the common mistakes DBA do retarding backup & Recovery?
- From: Joseph Amalraj <joseph@xxxxxxxxxxxxxx>
- To: Mark.Bobak@xxxxxxxxxxxxxxx, randyjo@xxxxxxxxxxxxx, ORACLE-L <oracle-l@xxxxxxxxxxxxx>
- Date: Wed, 4 Jul 2007 10:01:35 -0700 (PDT)
Have found the following "interesting" cases -
1. For cold backups; DBAs were providing a list of files to the unix team to
backup and would shut down the database. The List of files wasn't updated
though more datafiles were added to the database.
2. Controlfile was not being backed up after a rman backup.
3. While using conventional backup; After end backup command, no log switch
and no archive log backup was taken.
Joseph
"Bobak, Mark" <Mark.Bobak@xxxxxxxxxxxxxxx> wrote:
This is less common, as more and more folks move to RMAN, but, for
conventional backups, don't backup the online redo logs!
-Mark
-----Original Message-----
From: oracle-l-bounce@xxxxxxxxxxxxx on behalf of Randy Johnson
Sent: Wed 7/4/2007 9:45 AM
To: 'ORACLE-L'
Subject: [QUAR] RE: What are the common mistakes DBA do retarding backup &
Recovery?
Putting it in and knowing how to backup but not knowing how to use it to
recover.
Also, I would think the "backup database" command might be misleading to
most DBA's. It does not do a "switch logfiles" for you at the end of your
backup. Better to use command "backup database plus archivelog [all] [delete
input]". Or just know that you must "switch logfile" at the end to flush
remaining transactions out of your redo log files.
Randy Johnson
Sr. Technical Consultant
Enkitec, LLP
Office ..... 817-255-3580
Mobile .... 817-564-6583
Email ..... HYPERLINK
"mailto:randy.johnson@xxxxxxxxxxx"randy.johnson@xxxxxxxxxxx
_____
From: oracle-l-bounce@xxxxxxxxxxxxx [mailto:oracle-l-bounce@xxxxxxxxxxxxx]
On Behalf Of Syed Jaffar Hussain
Sent: Wednesday, July 04, 2007 7:23 AM
To: ORACLE-L
Subject: What are the common mistakes DBA do retarding backup & Recovery?
Hello List,
I would like hear from you about the common mistakes by most of the DBAs do
regarding the backup and recovery. I would think of the following:
1. Never testing their backups.
2. No good backup and recovery policies.
3. Afraid of using RMAN or Making benefits of RMAN
I would really like to know if there are any other points than what I
specified above.
--
Best Regards,
Syed Jaffar Hussain
Oracle ACE
8i,9i & 10g OCP DBA
HYPERLINK "http://jaffardba.blogspot.com/"http://jaffardba.blogspot.com/
HYPERLINK
"http://www.oracle.com/technology/community/oracle_ace/ace1.html#hussain"htt
p://www.oracle.com/technology/community/oracle_ace/ace1.html#hussain
----------------------------------------------------------------------------
------
"Winners don't do different things. They do things differently."
No virus found in this incoming message.
Checked by AVG Free Edition.
Version: 7.5.476 / Virus Database: 269.9.14/885 - Release Date: 7/3/2007
10:02 AM
No virus found in this outgoing message.
Checked by AVG Free Edition.
Version: 7.5.476 / Virus Database: 269.9.14/885 - Release Date: 7/3/2007
10:02 AM
--
//www.freelists.org/webpage/oracle-l
Other related posts:
