Video Screencast Help
Give us your opinion and win with Symantec! Please help us by taking this survey to tell us about your experience with Symantec Connect, so that we can continue to grow and improve.  Take the survey.

Missing database files from restore

Created: 20 Jun 2013 • Updated: 24 Jun 2013 | 5 comments
Andy_Cam's picture
This issue has been solved. See solution.

Please don't laugh but I need to restore some cold database files using Netbackup 3.4

Yes, I have NetBackup 3.4 running on a Master server and a client (both Solaris 2.6).

I'm being told by the DBAs that the *.dbf files they want restoring are in the following locations...

/u05/oradata/ACTEST

/u06/oradata/ACTEST

But when I go to the Restore window of the Java GUI I cant see any /oradata/ACTEST folders under /u05 or /u06.

I'm no Solaris expert but the database files must be somwhere but just not on the backup. (I don't have access to the client to check there location but I have been told it is correct.)

I can see the location is specified in the backup policy as ....

  Include:  /u05/oradata/ACTEST

            /u06/oradata/ACTEST

            /u01/apps

            /arch/apps/ACTEST

            /arch/oracle/ACTEST

            /u01/oracle

            /u01/oracle817

            /

            /var

            /esource

There is a shutdown script that runs on the client before the backup is started so the .dbf files are stopped for backup.

And the exclude_list on the client does not contain these folders.

Any ideas what the problem could be?

Operating Systems:

Comments 5 CommentsJump to latest comment

Yasuhisa Ishikawa's picture

3.4? Really?

Please try to set date range wide enough. No idea other than this for me.

Authorized Symantec Consultant(ASC) Data Protection in Tokyo, Japan

Nicolai's picture

try this command

# bplist -t 0 -s 01/01/1970 -C {client_name} -l -R /

This will list all file system backup of a client. You can modify / to e.g /u06/oradata/ACTEST to limit listing.

Assumption is the mother of all mess ups.

If this post answered your'e qustion -  Please mark as a soloution.

Andy_Cam's picture

Hi Nicolai - I found the files required using your bplist command so I now know they are getting backed up.

I still couldn't see them in the restore window of the Java GUI.

However, I've come across bpadm and can see they are available using this.

I think there must be some incompatability between NetBackup 3.4 Java GUI and the version of Java I have installed on my laptop.

Anyway, my problem is resolved.

Thanks

SOLUTION
Nicolai's picture

NBU 3.4 uses a X windows GUI. The Java GUI is not compatible.

Pls mark one of the posts as a soloution.

Assumption is the mother of all mess ups.

If this post answered your'e qustion -  Please mark as a soloution.

StefanosM's picture

really !!!!

Your post is the post that help you the most??????

OK. It a way to reward the person that help you....

I did not post just to say to you that you are wrong.
I want to suggest you to install the windows GUI. At this version it is easier than any x or java interface.

And if you have the software, to upgrade to 4.5 FP9. But I suspect that it is a solaris  OEM istallation.