Re: [Veritas-bu] RMAN crosscheck

I was on vacation last week.

Our DBA solved the problem she was having here.

It was the incorrect values for variable NB_ORA_CLIENT in the crosscheck script which used the real hostname instead of the backup LAN hostname which the backup/restore scripts use.

For most of our hosts we have a separate backup LAN. To distinguish path over the backup LAN as opposed to the primary LAN we typically suffix the hostname with a “b”. So if we had a server named tiger (used for primary LAN) we would do backups/restores using tigerb (backup LAN). In her issue the crosscheck script had “tiger” and when she changed it to “tigerb” which is what was in the backup/restore scripts then it worked properly.

From: veritas-bu-bounces AT mailman.eng.auburn DOT edu [mailto:veritas-bu-bounces AT mailman.eng.auburn DOT edu] On Behalf Of Jared Still
Sent: Tuesday, May 25, 2010 8:32 PM
To: Dean
Cc: veritas-bu AT mailman.eng.auburn DOT edu
Subject: Re: [Veritas-bu] RMAN crosscheck

On Tue, May 25, 2010 at 4:54 PM, Dean <dean.deano AT gmail DOT com> wrote:

Are you sure RMAN actually knows about the tape an image is on? If it does, that is just silly. It should just ask for a backupid, then NBU will give it the correct tape, regardless of whether it's a duped or vault copy or whatever. I've always been sure that that's the way it worked (Although, I'm not a DBA and don't know that much about RMAN).

I think you're right, it just keeps the Media ID.

It's been a few months since I have looked closely at it.

Regarding vaulted tapes: RMAN will not know that a tape has been vaulted,

so it will have the wrong media ID for requesting the tape.

If the tapes are restored into the NBU catalog, RMAN will then ask for the

correct backup pieces by name.

This not an issue with RMAN, as the API has that capability, at least

according to the docs.

It just has not been implemented by Veritas.

This would bear further investigation, as that situation may have changed

since I last looked into it.

Does RMAN also track disk STUs? I know in our environment, we write all our Oracle archive log backups to a DSSU, then they get moved out to tape and deleted from the DSSU within a day or so. We restore regularly (to development), and it always works fine, regardless of whether the archive log backups are still on disk or have been moved to tape. Does that mean RMAN is aware of the destage process? I highly doubt it.

There is a way for RMAN in later version to track backups that are staged to disk and

then backed up on to tape.

I have never used it, and don't know any details about it.

Jared Still
Certifiable Oracle DBA and Part Time Perl Evangelist
Oracle Blog: http://jkstill.blogspot.com
Home Page: http://jaredstill.com

Proud partner. Susan G. Komen for the Cure.

Please consider our environment before printing this e-mail or attachments.

----------------------------------
CONFIDENTIALITY NOTICE: This e-mail may contain privileged or confidential information and is for the sole use of the intended recipient(s). If you are not the intended recipient, any disclosure, copying, distribution, or use of the contents of this information is prohibited and may be unlawful. If you have received this electronic transmission in error, please reply immediately to the sender that you have received the message in error, and delete it. Thank you.
----------------------------------

_______________________________________________
Veritas-bu maillist  -  Veritas-bu AT mailman.eng.auburn DOT edu
http://mailman.eng.auburn.edu/mailman/listinfo/veritas-bu

Re: [Veritas-bu] RMAN crosscheck - SOLVED