473,324 Members | 2,567 Online
Bytes | Software Development & Data Engineering Community
Post Job

Home Posts Topics Members FAQ

Join Bytes to post your question to a community of 473,324 software developers and data experts.

dropped table recovery /tablespace restore

1
when i am doing dropped table reccovery
step1- the tablespace should be in recovery mode is it rite
step2 - the database should be in archivelog mode is it rite
step-3 - identify the dropped table and get it's DDL and note the dropped table id.
step4 - now restore the appropriate tablespace in the which the table is dropped
step5 - rollforward the database
step6 - now create the dropped table by using the ddl generated at LIST HISTORY COMMAND
step7- now import the data into the newly re-created table from the NODE0000 folder which contains the export file

if i done the above mentioned steps i got an error
i.e
SQL3030C An I/O error (reason = "sqlofopn -2029060079") occurred while opening the input file
SQL3333C THE FILE OR DIRECTORY DOES NOT EXIST.
SQL3110N THE UTILITY HAS COMPLETED PROCESSING. "0" ROWS WERE READ FROM THE INPUT FILE.

PLEASE SEND ME THE SOLUTION FOR ABOVE MENTIONED ERROR
Apr 23 '08 #1
0 3482

Sign in to post your reply or Sign up for a free account.

Similar topics

4
by: Raquel | last post by:
How are the following two commands different as far as the 'end result' of the restores is concerned: 1. db2 RESTORE DB mydb 2. db2 RESTORE DB mydb TABLESPACE In other words, in the above...
2
by: Damir Wilder | last post by:
Hello! Is it at all possible (on DB2 V7.2, AIX) to restore a single table from a full table backup? The RESTORE DB command doesn't have this functionality - at least not according to the DB2...
7
by: cbielins | last post by:
So yea... I rm-ed a rlv that our TS_FACT2 tblspace was using. So our db went to the crapper. The tblspace didn't have any pertinent info, so I'm ok with dropping the tblspace and starting over. ...
4
by: Joachim Klassen | last post by:
DB2 V8.2 FP10 on Windows I tested the following HADR scenario: - a new tablespace on a new filesytem is created on the primary System - the replay on standby fails because of lacking permissions...
8
by: Raj | last post by:
-Is it possible to recover a tablespace just from a full offline backup and offline incremental backup? If not possible -Can we recover tablespace from Full backup , Wednesdays incremental backup...
1
by: Ravi Padmakar | last post by:
Hello, In the process of making my database work (I started with not being able to insert records because of tablespace issues) , I dropped the tablespace for it. Now I am not able to access the...
4
by: DaveL | last post by:
hi, we have a database in simple recovery mode if a table were dropped Is there a way to recover the dropped table thanks DaveL
2
by: mvsmsh | last post by:
Hi , all We have hundreds of tables in on tablespace , but I'm planning to change as one table per one tablespace. . I wonder how other shops does ? Are there any special reasons in UDB...
4
by: pinoy2ser | last post by:
hello All, im not a db2 person, please forgive me for asking a simple question.. i would like to restore a tablespace from a current database to a new database in the same server how do i...
1
isladogs
by: isladogs | last post by:
The next Access Europe meeting will be on Wednesday 6 Mar 2024 starting at 18:00 UK time (6PM UTC) and finishing at about 19:15 (7.15PM). In this month's session, we are pleased to welcome back...
0
by: jfyes | last post by:
As a hardware engineer, after seeing that CEIWEI recently released a new tool for Modbus RTU Over TCP/UDP filtering and monitoring, I actively went to its official website to take a look. It turned...
0
by: ArrayDB | last post by:
The error message I've encountered is; ERROR:root:Error generating model response: exception: access violation writing 0x0000000000005140, which seems to be indicative of an access violation...
1
by: PapaRatzi | last post by:
Hello, I am teaching myself MS Access forms design and Visual Basic. I've created a table to capture a list of Top 30 singles and forms to capture new entries. The final step is a form (unbound)...
1
by: CloudSolutions | last post by:
Introduction: For many beginners and individual users, requiring a credit card and email registration may pose a barrier when starting to use cloud servers. However, some cloud server providers now...
1
by: Defcon1945 | last post by:
I'm trying to learn Python using Pycharm but import shutil doesn't work
1
by: Shællîpôpï 09 | last post by:
If u are using a keypad phone, how do u turn on JavaScript, to access features like WhatsApp, Facebook, Instagram....
0
by: af34tf | last post by:
Hi Guys, I have a domain whose name is BytesLimited.com, and I want to sell it. Does anyone know about platforms that allow me to list my domain in auction for free. Thank you
0
isladogs
by: isladogs | last post by:
The next Access Europe User Group meeting will be on Wednesday 3 Apr 2024 starting at 18:00 UK time (6PM UTC+1) and finishing by 19:30 (7.30PM). In this session, we are pleased to welcome former...

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.