Reconstructing a database.

learn more… | top users | synonyms (1)

3
votes
1answer
2k 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
652 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
987 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
329 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 ...
3
votes
3answers
8k 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
183 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
8k 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
284 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
524 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: ...
7
votes
2answers
581 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 ...
5
votes
3answers
443 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
2answers
7k 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
388 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: ...
5
votes
1answer
209 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
220 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 ...
1
vote
2answers
5k 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
4answers
1k 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
131 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
253 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
247 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
51 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
3k 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 ...
2
votes
3answers
1k 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 ...
1
vote
2answers
978 views

MySQL Database and Table Loss

I have installed mysql and XAMPP on my system. I wanted to remove the mysql service of XAMPP. After removing it, I tried to install the new service for mysql using "MySQLInstanceConfig.exe". but now I ...
3
votes
1answer
948 views

recover broken msde 2000 8.0 database

i have a msde (mssql) 2000 / v8.0 database that has one corrupted table. Microsoft SQL Server Management Studio Express can see the database STRUCTURE, but not the data. i can see the DATA of the ...
4
votes
1answer
603 views

Mysql crashed once with an “Assertion failure” this morning, how worried should I be? best way to diagnose this?

So for the first time our production system produced the below assertion failure. The system came up without issues after mysqld automatically restarted itself and rolled back some transactions.. ...
1
vote
1answer
1k views

Recover PostgreSQL database data

I am using PostgreSQL in my project, Now by mistake I have deleted some records of one of my tables. Now is there any way to recover deleted Records in PostgreSQL?
7
votes
1answer
8k views

How can I recover data from the LDF file?

We are using SQL 2005 Express Edition. We want to read the data from the LDF file in order to restore some deleted records. We tried using a trial version of ApexSQL which helped us a lot. Instead of ...
4
votes
2answers
1k views

What is a good way to verify that a restore completed successfully in SQL Server?

Right now, we test our SQL backups once a month by pulling the most recent backup file and restoring it onto a test database. If SQL Server says the restore is successful, we spot-check a few tables ...
6
votes
1answer
8k views

Database 'MyDb' is being recovered. Waiting until recovery is finished

I got so error: Database 'MyDb' is being recovered. Waiting until recovery is finished. I have had a critical operation at that time. What is the cause of this situation? And how can it be ...
3
votes
1answer
4k views

RMAN-06054: media recovery requesting unknown archived log, Where is SCN kept?

I have the following situation: Backups of DB1(located on srv1 server) database are taken everyday at 1:00 AM. I took backed up files(datafile,archivelog,controlfile,spfile) of 24/10/2011 and ...
2
votes
2answers
256 views

SQL Server recovery with LVM snapshot as base

Is it possible to fully recover a database from a snapshot plus transaction log backups? By snapshot I mean a crash-consistent clone of the Server - in this case an LVM snapshot that is shipped ...
6
votes
2answers
3k views

Recover accidentally deleted rows from a table

My client has accidentally deleted all the records of a table from a test database. This test database is in SQL Server 2005 Express and we don't have a backup. Is it possible to restore the deleted ...
2
votes
1answer
756 views

How to disable instance recovery in ORACLE?

I want my DB to stop instance recovery during opening, how to do it? I want it because it crashes when trying to do instance recovery, I am testing some cases and want to disable it Is there any ...
2
votes
2answers
3k views

Is there any way to recover a database after dropping from phpmyadmin?

I was planning to drop all the tables from a test account, but unfortunately, I didn't notice that I was in the production account when I chose to drop all the tables of my db from phpmyadmin ...
1
vote
1answer
152 views

Oracle Backup/Recovery architecture

When we write the following: allocate channel ch1_tape type sbt; set controlfile autobackup format for device type sbt to '%F'; restore controlfile from autobackup; RELEASE CHANNEL ch1_tape; By ...
2
votes
1answer
138 views

Oracle Backup and Recovery Issue

I have backed up database located on Host1 and restored/recovered it on Host2. After a while, I backed up DB on Host1 again. Now I want DBs on Host1 and Host2 be the same using last backup. How can ...
2
votes
3answers
675 views

Oracle get sql redo from log_history

I run into a problem with a customer which had no proper backup. His last backup (meaning exp-dump) is from 1st Aug 2011. However he lost due to batch DELETE statements all data. My plan was now to ...
0
votes
3answers
214 views

What all are the recoverable points of failure in an Oracle database?

I am testing a product against an Oracle database for failure scenarios. The product talks to Oracle through a session and maintains a few tables. I want to make sure that whenever Oracle recovers ...
3
votes
2answers
18k views

SQL Server shows database in recovery

Today, after a power failure, one database (with Recovery: full) shows "In Recovery" in SSMS. So: myDatabase (In recovery) (database status: recovery, Shutdown) After finish, the "recovery ...
22
votes
3answers
26k views

How do I get back some deleted records?

I mistakenly deleted around 2,000,000 records from a remote SQL Server 2008 table. The server is not granting me access to the backup files on the server side. Is there any way to get back these ...