View previous topic :: View next topic
|
Author |
Message |
sankarmf
New User
Joined: 17 Mar 2009 Posts: 7 Location: chennai
|
|
|
|
Hi all,
Is there any possibilty to recover a deleted dataset?
Thanks,
Sankar |
|
Back to top |
|
|
himanshu7
Active User
Joined: 28 Aug 2007 Posts: 131 Location: At Desk
|
|
|
|
Use HRECOVER and the DSN for the deleted DSN |
|
Back to top |
|
|
sankarmf
New User
Joined: 17 Mar 2009 Posts: 7 Location: chennai
|
|
|
|
May i request you to provide a sample JCL for that..
Sankar |
|
Back to top |
|
|
enrico-sorichetti
Superior Member
Joined: 14 Mar 2007 Posts: 10888 Location: italy
|
|
|
|
You can recover only if You have a backup
we do not know anything about Your environment, the product installed, Your organization standards
ask Your storage support |
|
Back to top |
|
|
sankarmf
New User
Joined: 17 Mar 2009 Posts: 7 Location: chennai
|
|
|
|
I wish i could..but i inadvertently deleted the dataset, which i am not supposed to ..I may have to face some serious consequences, if i let them know..
I request you provide the JCL..Pleassssssssssssse!
Sankar |
|
Back to top |
|
|
expat
Global Moderator
Joined: 14 Mar 2007 Posts: 8796 Location: Welsh Wales
|
|
|
|
Unfortunately, when you get it wrong, you need to take the consequences of your actions.
The first priority, to your employer and yourself, is to get the data recovered rather than cover your tracks, which is virtually impossible to do with SMF data recording everything that you do.
As suggested, have you tried the HRECOVER command |
|
Back to top |
|
|
sankarmf
New User
Joined: 17 Mar 2009 Posts: 7 Location: chennai
|
|
|
|
No..i am not sure how to use Hrecover.. Please suggest me where should i try that from?
Thanks,
Sankar |
|
Back to top |
|
|
expat
Global Moderator
Joined: 14 Mar 2007 Posts: 8796 Location: Welsh Wales
|
|
|
|
Well, as it is a command, may I suggest from the terminal ........
HRECOVER 'dataset name' |
|
Back to top |
|
|
sankarmf
New User
Joined: 17 Mar 2009 Posts: 7 Location: chennai
|
|
|
|
I get the following msg..
ARC1001I P421.SCN.AW.DXON.D140309 RECOVER FAILED, RC=0028, REAS=0000
ARC1128I BACKUP/DUMP COPY DOES NOT EXIST
What does this mean?
Sankar |
|
Back to top |
|
|
expat
Global Moderator
Joined: 14 Mar 2007 Posts: 8796 Location: Welsh Wales
|
|
|
|
It is written in plain English, there is no known HSM backup or dump of the dataset that you want to recover.
You need to talk to your storage people quickly, as there may be an offsite backup of the dataset which may be used, and will cause HSM to issue that message if the DUMPCLASS is set to NORESTORE.
Also you need to investigate any batch backups that may be executed within the application to use to recover from.
If all else fails, you are going to have to come clean with the boss. |
|
Back to top |
|
|
sankarmf
New User
Joined: 17 Mar 2009 Posts: 7 Location: chennai
|
|
|
|
I jsut talked to my storage admin..
Thanks much for all your assistance.. |
|
Back to top |
|
|
Anuj Dhawan
Superior Member
Joined: 22 Apr 2006 Posts: 6248 Location: Mumbai, India
|
|
|
|
sankarmf wrote: |
I jsut talked to my storage admin.. |
and then just what happened? |
|
Back to top |
|
|
sankarmf
New User
Joined: 17 Mar 2009 Posts: 7 Location: chennai
|
|
|
|
They were able to recover the dataset. not sure how
Thanks,
Sankar |
|
Back to top |
|
|
Terry Heinze
JCL Moderator
Joined: 14 Jul 2008 Posts: 1248 Location: Richfield, MN, USA
|
|
|
|
Anuj D. wrote: |
sankarmf wrote: |
I jsut talked to my storage admin.. |
and then just what happened? |
Sankar will be moved from the Intensive Care Unit to the recovery section in a week or two. |
|
Back to top |
|
|
dick scherrer
Moderator Emeritus
Joined: 23 Nov 2006 Posts: 19243 Location: Inside the Matrix
|
|
|
|
Hello,
They retrieved it from a backup using methods typically not available to the developers/users of the system.
Be kind to your storage admins - they can save your butt. . .
d |
|
Back to top |
|
|
Anuj Dhawan
Superior Member
Joined: 22 Apr 2006 Posts: 6248 Location: Mumbai, India
|
|
|
|
sankarmf wrote: |
They were able to recover the dataset. not sure how |
Lucky You . . . .
Once this happend to me, DSN was not deleted by mistake but it was "removed" by the regular "archiving activity" and then it was not recovered. It was a back-up of some table in production and luckily I had it availble image-copy which was implemented just few days ago. . . |
|
Back to top |
|
|
Anuj Dhawan
Superior Member
Joined: 22 Apr 2006 Posts: 6248 Location: Mumbai, India
|
|
|
|
Terry Heinze wrote: |
Sankar will be moved from the Intensive Care Unit to the recovery section in a week or two. |
heh heh . . . but he had a narrow escape. . .
Quote: |
They were able to recover the dataset. |
just kidding . . . |
|
Back to top |
|
|
vasanthz
Global Moderator
Joined: 28 Aug 2007 Posts: 1744 Location: Tirupur, India
|
|
|
|
I like happy endings |
|
Back to top |
|
|
|