Re: restore asking for offsite copy instead of primary
Hi, I had a user trying to restore a database and found data unavailable to server. The restore was asking for a volume that was offsite. Why wouldn't it ask for the primary copy and how do I know what primary volume the data is on? You can use an SQL statement, like select distinct volume_name,stgpool_name from volumeusage - where node_name='YOUR_CLIENT_NODE_NAME' - order by volume_name Maybe the volume has been disabled or changed to readonly due to a write or read error. Dirk
Re: restore asking for offsite copy instead of primary
Dirk, node_name is not recognized. ANR2940E The reference 'NODE' is an unknown SQL column name. | .V. _name from volumeusage where node-name=ABC order by volume_name ANS8001I Return code 3. -Original Message- From: Dirk Kastens [mailto:[EMAIL PROTECTED]] Sent: Thursday, July 11, 2002 5:01 PM To: [EMAIL PROTECTED] Subject: Re: restore asking for offsite copy instead of primary Hi, I had a user trying to restore a database and found data unavailable to server. The restore was asking for a volume that was offsite. Why wouldn't it ask for the primary copy and how do I know what primary volume the data is on? You can use an SQL statement, like select distinct volume_name,stgpool_name from volumeusage - where node_name='YOUR_CLIENT_NODE_NAME' - order by volume_name Maybe the volume has been disabled or changed to readonly due to a write or read error. Dirk CAUTION - This message may contain privileged and confidential information intended only for the use of the addressee named above. If you are not the intended recipient of this message you are hereby notified that any use, dissemination, distribution or reproduction of this message is prohibited. If you have received this message in error please notify AMCOR immediately. Any views expressed in this message are those of the individual sender and may not necessarily reflect the views of AMCOR.
Re: restore asking for offsite copy instead of primary
node_name is not recognized. ANR2940E The reference 'NODE' is an unknown SQL column name. | .V. _name from volumeusage where node-name=ABC order by volume_name Seems, that you typed node-name instead of node_name. Dirk
restore asking for offsite copy instead of primary
I had a user trying to restore a database and found data unavailable to server. The restore was asking for a volume that was offsite. Why wouldn't it ask for the primary copy and how do I know what primary volume the data is on? Thanks, [EMAIL PROTECTED]
Re: restore asking for offsite copy instead of primary
maybe the primary copy is marked unavailable... do a q vol f=d to see.. nnn=volume number -Original Message- From: Blair, Georgia [mailto:[EMAIL PROTECTED]] Sent: Wednesday, July 10, 2002 12:28 PM To: [EMAIL PROTECTED] Subject: restore asking for offsite copy instead of primary I had a user trying to restore a database and found data unavailable to server. The restore was asking for a volume that was offsite. Why wouldn't it ask for the primary copy and how do I know what primary volume the data is on? Thanks, [EMAIL PROTECTED] Confidentiality Note: The information transmitted is intended only for the person or entity to whom or which it is addressed and may contain confidential and/or privileged material. Any review, retransmission, dissemination or other use of this information by persons or entities other than the intended recipient is prohibited. If you receive this in error, please delete this material immediately.
Re: restore asking for offsite copy instead of primary
From: ADSM: Dist Stor Manager [mailto:[EMAIL PROTECTED]]On Behalf Of Blair, Georgia I had a user trying to restore a database and found data unavailable to server. The restore was asking for a volume that was offsite. Why wouldn't it ask for the primary copy and how do I know what primary volume the data is on? Read the server activity log to see which primary pool tape it was trying to get. Once you've got the volume number, check the status and storage pool of the tape (Q VOL F=D) and its physical location (Q LIBV). If it is a primary tape pool volume, and if it is physically in the library, it may have gotten set to an incorrect status (thus the OFFSITE) designation. Update its status to READWRITE, and you should be good to go. -- Mark Stapleton ([EMAIL PROTECTED]) Certified TSM consultant Certified AIX system engineer MCSE
Re: restore asking for offsite copy instead of primary
I probably didn't make this clear I don't know the primary volume # or how to find it. The restore requested a volume that was physically offsite in the vault. I would think it would ask for the primary copy. -Original Message- From: Remeta, Mark [mailto:[EMAIL PROTECTED]] Sent: Wednesday, July 10, 2002 11:53 AM To: [EMAIL PROTECTED] Subject: Re: restore asking for offsite copy instead of primary maybe the primary copy is marked unavailable... do a q vol f=d to see.. nnn=volume number -Original Message- From: Blair, Georgia [mailto:[EMAIL PROTECTED]] Sent: Wednesday, July 10, 2002 12:28 PM To: [EMAIL PROTECTED] Subject: restore asking for offsite copy instead of primary I had a user trying to restore a database and found data unavailable to server. The restore was asking for a volume that was offsite. Why wouldn't it ask for the primary copy and how do I know what primary volume the data is on? Thanks, [EMAIL PROTECTED] Confidentiality Note: The information transmitted is intended only for the person or entity to whom or which it is addressed and may contain confidential and/or privileged material. Any review, retransmission, dissemination or other use of this information by persons or entities other than the intended recipient is prohibited. If you receive this in error, please delete this material immediately.
