Reconstructing a database.
-4
votes
1answer
39 views
Oracle database and data has been corrupted. Is there a way to get it back? [closed]
The Oracle database has been corrupted and both the data and backups were lost in the corruption. Is there anything I can do to recover my data? It would be terrible if it were all lost.
1
vote
1answer
99 views
How to recover/restore corrupted Innodb data files?
A while ago, my Windows 7 system on which a MySQL Server 5.5.31 was running crashed and corrupted the InnoDB database. The weekly backup that's available does not cover all the tables that were ...
1
vote
1answer
38 views
Table corruption: How to perform Innodb Checksum checks in MySQL 5.5 for Windows?
Having a corrupted Mysql 5.5.31 (Windows) database, my question relates to the the top solution provided in How do you identify InnoDB table corruption? , more precisely to the following script that ...
0
votes
1answer
85 views
Is it there anyway to restore updated records in Microsoft SQL Server 2008 R2?
We have an test database configured with our web application. Due to internal web application error the entries were get updated in the database. Is it there any way to recover the updated records?
...
0
votes
0answers
70 views
MySQL installation broken after Windows crash - how to repair MySQL and recover data?
recently my PC powered off abruptly for no apparent reason, leaving my Windows 7 installation severly damaged. I can still log onto the machine, but tons of Windows system files have been corrupted ...
0
votes
1answer
22 views
OK to put temp tablespace on volatile storage or to omit it from backups? (Postgresql)
I would intuit that it's fine, but I just want to make sure there are
no gotchas from a recovery point of view:
If I were to lose my temp tablespace upon system crash, would this
prevent proper crash ...
1
vote
1answer
123 views
Master updates Slave but not Master itself
I have a setup master/slave in which applications are pointed only to master. Yesterday Master had got crashed due to "multi bit error on dimm detected" in Front indication panel in orange color.
...
0
votes
0answers
28 views
Should I keep pg_xlog on the same disk as data if using disk snapshotting?
We're running on EBS volumes on EC2. We're interested in leveraging
EBS snapshotting for backups. However, does this mean we'd need to
ensure our pg_xlog is on the same EBS volume as our data?
(I ...
1
vote
1answer
46 views
Why we need auxiliary instance in TSPITR
Need help!
I've read Database Backup and Recovery User's Guide 11g but I can't uderstand why we need auxiliary instance to perform tspitr.
We can do complete recovery of tablespace within same ...
1
vote
1answer
170 views
How to recover data from corrupted innoDB table from a crashed mySQL server?
Some background:
I had a MySQL server running on Ubuntu Server. I don't remember which versions they were running but it was likely a Ubuntu 12.04 with MySQL 5.5. During the course of a day, ...
1
vote
1answer
40 views
POSTGRES DB Server Blunder
This weekend I had to rebuild my laptop which had Postgres running. For some reason, I forgot to dump the data but I did make a complete copy of the original hard drive.
Is it possible to recover ...
0
votes
0answers
118 views
MySQL Database Recovery from ibdata1 and .frm Files Fails
My MySQL database server crashed but I managed to recover copies of the ibdata1 and .frm files.
I have followed instructions, including some from this site, that say to do a clean install and ...
0
votes
0answers
54 views
Tape rotation strategies
I am trying to find a tape rotation strategy that would be optimal under the following conditions:
Backup Media Rotation strategy should support the following:
Media Archives required ...
1
vote
0answers
38 views
Will Startup Procs Run Again After Database Recovery?
We have a number of stored procedures that run on startup via the sp_procoption startup:
exec sp_procoption 'ProcName', 'startup, 'true'
A customer's server started up with a very large database in ...
0
votes
0answers
17 views
How to get details of changes in point in time recovery using mysqlbinlog
I have written a shell script for point in time recovery using binary logs( Point-in-Time Recovery Using Event Times). I'm using the start time as the previous full-backup start time and end time will ...
0
votes
0answers
58 views
How to do point in time recovery of binary log files into .sql file
I have written a shell script to do an incremental backup of MySQL database.
For point in time recovery I'm using the binary logs generated in /var/lib/mysql directory.
For point-in-time recovery, Im ...
1
vote
1answer
185 views
MySQL InnoDB logfiles resized - review mysql-err.log for potential problems
I restarted mysqld this morning, to increase the size of the innodb logs and increase the amount of memory allocated to the innodb buffer pool. (MySQL 5.1.53-Community on Ubuntu)
To increase the ...
3
votes
1answer
325 views
SQL Server - contents of transaction log file in more detail
I have a question regarding transaction log (let’s just call it LDF for short) contents. I am assuming a database with full recovery model.
I have read that LDF file contains (logs) each and every ...
4
votes
2answers
188 views
SQL Server 2008 R2 database is suspect, tried it all. Final destination?
This night my hosting provider made a "hard reset" on my VPS hosted in their farm. And one of most important databases (SQL Server 2008R2 database) is now in Suspect mode. My provider has backups ...
0
votes
3answers
71 views
Where can I learn about MySQL master/slave, master/master, or clustering setups?
What are the best resources you've read or watched about setting up master/slave or clustering for database replication?
I don't know much about this. I have a database that is getting rather large ...
2
votes
1answer
172 views
How to Recover My Oracle 9i Database From Just The Datafiles
The state of the system when I started was that there was a single, working instance of Oracle Database 9i. I proceeded to install Oracle 11g choosing to Install Software Only. Upon completion, ...
5
votes
1answer
77 views
Rebuild a table from history records
A small disaster happened to me on my PostgreSQL 8.4 database.
I follow visitors to my webpage in two tables:
History
+---------------+-------------+
| whereseenlast | varchar(50) |
| uniqid ...
2
votes
1answer
186 views
Which backup files are needed for a successful restore?
Considering the built-in 'Backup Database' script (backup.bat) that comes with a new installation of the Oracle Express 11g Edition, after finishing the script execution, what folders/files should be ...
3
votes
4answers
147 views
Does it make sense to use full recovery if the data and log files are on the same HD?
We have a database that was set up to use full recovery and my guess is that the reasoning was only to prevent data loss if a failure happened between backups.
We make daily full backups of the ...
3
votes
0answers
103 views
“InnoDB: error clustered record for sec rec not found” MySQL 5.5.28
We have a high-end server, 128GB RAM, 32 Core , Xeon, SSD RAID 10 - running Ubuntu 12.04 with MySQL 5.5.28.
During high load, randomly we got the below error.
MySQLcheck, innochecksum shows no ...
2
votes
1answer
295 views
MySQL 5.5 : (InnoDB) - Manually edited an .ibd file to test recovery, now entire MySQL installation is broken!
So I wanted to test MySQL recovery from Innodb corruption.
file-per-table is enabled.
I have a few test db's on the MySQL instance.
I shutdown mysql. Manually edited/added random characters to an ...
3
votes
1answer
528 views
Innodb, MySQL 5.5.28 - Segmentation Signal 11 faults, on high load. .. my.cnf file included
We have a high-end server,
128GB RAM, 32 Core , Xeon, SSD RAID 10 - running Ubuntu 12.04 with MySQL 5.5.28 .
Doing random imports to large InnoDB tables, over 50+ gigs, randomly after a few hours of ...
4
votes
1answer
139 views
Retrieving data if control file is lost in oracle Database
Suppose if the databases control file is lost permanently (no backup).
Can we retrieve the data from data file in Oracle database?
2
votes
1answer
490 views
Recover database until cancel without prompt?
The statement:
RECOVER DATABASE UNTIL CANCEL
prompts once to select the archive log file. Is there a way to pre specify the value so as to be able to use it in a script without prompt?
I have ...
2
votes
1answer
146 views
Recovering from a stuck query
I have a big DELETE query (deleting 20M rows from a 600M row table with condition according to indexed column) that is stuck - running already for 17hrs. Because it's an InnoDB table, killing it will ...
2
votes
3answers
2k views
ERROR Cannot find or open table?
MySQL version: 5.5.24
Due to the following problem:
mysql> desc reportingdb.v3_zone_date_cpm7k;
ERROR 1146 (42S02): Table 'reportingdb.v3_zone_date_cpm7k' doesn't exist
...
3
votes
1answer
154 views
sql server down bad things happens
Following Situation:
You have a Database with very high transactions, the Database is about 4100 GBs
The Recovery Modell from your Database is full
Every week you make a full backup from your ...
2
votes
1answer
5k views
MySQL: InnoDB keeps crashing - how to recover?
# free -m
total used free shared buffers cached
Mem: 48289 35288 13000 0 347 30399
-/+ buffers/cache: 4541 43747
...
0
votes
1answer
164 views
Salvaging data from corrupt tables PostgreSQL
Am in the process of salvaging very crucial data from a corrupted database.
Am getting the following error from a very crucial table
ERROR: invalid page header in block 94206 of relation ...
0
votes
1answer
275 views
percona mysql crashing at innodb initialization
i have a slave percona db setup that also maintains few of it's own tables
it started crashing with this in error.log:
InnoDB: In a MySQL replication slave the last master binlog file
InnoDB: ...
6
votes
2answers
290 views
PostgreSQL PITR restore
I have a PostgreSQL 9.1 server running on a CentOS 5.8 32bit OS and I have enabled WAL archiving. On this server, there are three databases: databaseA, databaseB and databaseC. Someone deletes a ...
3
votes
3answers
289 views
Is it possible to recover day's worth of queries from sql server log file?
I lost all data entered and edited in my system yesterday, and my ISP has announced to me that last night's backup is corrupt and cannot be recovered.
Is there any way to access the database's log ...
3
votes
1answer
3k views
How do I copy databases from Postgres 8.4 to Postgres 9.1?
My trac server recently started having issues. It was running a very outdated version of Ubuntu, and I was unable to properly use apt-get to correct the issues I was having. So instead I backed up the ...
4
votes
2answers
195 views
Change Location of VALIDATE RECOVERY FILES work area
Is there a way to tell the VALIDATE RECOVERY FILES command to use a different location with more available disk space?
When I run the command in RMAN, it fails with the following error stack:
...
4
votes
1answer
164 views
Electricity off while shrinking database, how can I recover my database?
While i execute shrink database, the electricity has been gone down, I can't access my database now, it is (In Recovery), how can i recover it?? Note: it is a very huge database: 25 GB.
EDIT:
My ...
1
vote
1answer
134 views
Can I recover an overwritten incident trace file?
I was looking at incident trace file in oracle database but some how that file got overwritten. As of now I have ecrep_ora_26467_i49966.trm but trhe corresponding .trc file is lost. is it possible to ...
4
votes
2answers
2k views
Recover deleted records [duplicate]
Possible Duplicate:
How do I get back some deleted records?
Our C#.NET application mistakenly deleted all records from all tables of its database.
The application automatically takes ...
0
votes
2answers
1k views
Recover from Postgres FATAL: could not open file pg_tblspc/
I have a pretty big PostgreSQL 9.1.3 running on Ubuntu 10.04. The data is spread over multiple tablespaces = physical drives.
One of these drives is gone, so the directory of that tablespace doesn't ...
4
votes
3answers
677 views
RSync Database File Deltas in SQL Server 2008
Alright, I feel like this is a terrible idea, but I need some help understanding why this is bad:
I'm still working on implementing a disaster recovery/business continuity solution for our ...
1
vote
1answer
78 views
SQL ServerRecovery Model Change Tracking
Are SQL Server recovery model changes logged anywhere...WMI, error logs...etc?
For instance, if I change from FULL to SIMPLE, is this recorded anywhere?
2
votes
1answer
175 views
Initial recovery Postgres with backup in sync commit mode
I've got a master and a slave postgres 9.1.3 database. I would like to init the backup database for the first time.
I did the following steps:
Stopped master
Copied all files to Slave
Create ...
2
votes
1answer
202 views
Postgres synchronized backup - what's with the archive?
I am setting up a Postgres 9.1 master and a hot standby-server. I read the documentation but I'm not quite sure yet what I should do with my WAL files.
Every commit is done on both servers before ...
2
votes
0answers
49 views
Can you recover to a point in time using the LDF? [duplicate]
Possible Duplicate:
How do I get back some deleted records?
A coworker accidentally ran an update statement that needs to be reverted. The last backup is about 12 hours old.
Is there any ...
9
votes
2answers
1k views
Restore bak file to smaller mdf and ldf database files
I have a legacy database whose nightmarish lack of design I will not get into here, but the files on the server are (relatively) enormous. I have:
MyDatabase.mdf: 24.8GB
MyDatabase.ldf: 114.6GB
This ...
1
vote
3answers
238 views
Is it good idea to change Simple Recover Model into Bulk-Logged on ETL system?
We are having an ETL process which inserts lots of data into tables. This database is set to Simple Recovery Model and the transaction log is growing a lot. I was thinking that would it help to set ...
