Home » Other » General » interview question
interview question [message #187319] Sat, 12 August 2006 00:16 Go to next message
kal_youssef
Messages: 25
Registered: September 2005
Location: canada
Junior Member

Dear Gurus
i need your help
i was asked this question in an interview and i need a good answer to compare to my answers.

4. Common issues faced during daily Database Backup (RMAN/Netbackup).
(Scheduled backups and major failure reasons..)
Any ideas would be greatly appreciated

regards
K.
Re: interview question [message #187491 is a reply to message #187319] Mon, 14 August 2006 04:05 Go to previous messageGo to next message
Frank Naude
Messages: 4502
Registered: April 1998
Senior Member
Here are some:

- Archiver stuck if archlog destination reaches 0% free - backup more frequently or write script to start backup, i.e. at 20% free/ 80% used.

- Ensure backups run after hours or when the database is not as busy.

- Ensure a RMAN catalog is used and that the catalog is NOT within the same target DB.

- Monitor RMAN and Netbackup logs daily to pick up problems proactively.

- Ensure sufficient tapes are available for the backups.

- Replace old tapes as soon as they start giving errors.

- Test backups frequently by performing test/mock restores.

Etc.
Re: interview question [message #189636 is a reply to message #187491] Fri, 25 August 2006 06:00 Go to previous messageGo to next message
sunil_v_mishra
Messages: 506
Registered: March 2005
Senior Member
kal_youssef question which was asked to you, was to know that what type of problem you had generally faced while taking backup....

As per my experience...

Most of time i got error related to Media (MML)(i.e Tape), but what frank has said is also correct.

Regards
Sunilkumar
Re: interview question [message #189986 is a reply to message #189636] Mon, 28 August 2006 22:53 Go to previous message
ashish.mishra
Messages: 1
Registered: August 2006
Location: Mumbai
Junior Member
Dear kal_youssef,

As per my Experience 95% I got Error Msg regarding Media.

Some Problems are as follows-


Checking label on volume in device /dev/nmt0 failed


>> It happens when wrong Media Found inside Backup Drive( It may be that Internal Label is Diffnt from what expected)

Winding tape volume in device /dev/nmt0 failed

>> i.e. media is not inserted inside Tape drive or inserted media is corrupted.

(These are only manually fault,As per the technical Error,I never faced any technical issue during backup.)

Regards,
Ashish
Previous Topic: Oracle Architecture
Next Topic: Retrieving java classes bytecode
Goto Forum:
  


Current Time: Thu Dec 08 00:02:23 CST 2016

Total time taken to generate the page: 0.27219 seconds