Home » Other » General » interview question
interview question [message #187319] Sat, 12 August 2006 00:16 Go to next message
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

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: 4569
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.

Re: interview question [message #189636 is a reply to message #187491] Fri, 25 August 2006 06:00 Go to previous messageGo to next message
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.

Re: interview question [message #189986 is a reply to message #189636] Mon, 28 August 2006 22:53 Go to previous message
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.)

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

Current Time: Tue Jul 27 04:32:18 CDT 2021