Reconstructing a database.

learn more… | top users | synonyms (1)

0
votes
1answer
62 views

Secondary data file is in 'Recovery Pending' state, but database is online

I got an issue. I have a database (Say, DBASE) which have three files - Two data files (namely D:\Data1.mdf and D:\Data2.ndf) and a log file (E:\log.ldf) and all are in different file group. The ...
0
votes
1answer
86 views

Recover innodb mysql 5.6 database WITH ib_logfile0,ib_logfile1, and ibdata1 but WITHOUT .idb files

I had a customer's computer shutdown/crash due to power going out and when mysql tried to boot they got. After I looked in data folder for database and there was just .frm files and no .idb files. ...
0
votes
1answer
107 views

ORA-01122: database file 5 failed verification check

Oracle version: 11g r2 OS: win server 2008 SQL> alter database open; alter database open * ERROR at line 1: ORA-01122: database file 5 failed verification check ORA-01110: ...
0
votes
0answers
40 views

How to recover from a wrong update query and its cascading influence

Once a mis-DML happens, the backup set and binlog may help to get back the orginal record. However, how can I eliminate the cascading influence resulting from the wrong operation at the start? For ...
1
vote
0answers
83 views

Database suddenly in recovery-pending

We have a client running 70 databases on a SQL server. Last month they called us that suddenly database wasn't accessible. Database was in recovery pending mode. Today they called us again ...
1
vote
0answers
60 views

Will I have to restore controlfile in RMAN level 1 backupset before recover database?

For example, I have a level 0 and level 1 RMAN backupset files like inr00_0413_* inr01_0413_1_* Is it necessary to do this when recover from RMAN level 1 backup: restore controlfile from ...
1
vote
1answer
139 views

systemctl startup script gives “WSREP: Failed to recover position” - manual startup works

We have a Galera crash. 3 Nodes on RHEL7. I can start one node with this command # sudo -u mysql /usr/libexec/mysqld --wsrep-cluster-address='gcomm://' 160408 13:36:24 [Warning] Could not increase ...
0
votes
0answers
33 views

Recover deleted lines in SQL

I read your answer on how to track que log from deleted lines : View delete statements in the Transaction log I can see the log, but now how do I recover the lines back to to the table? Can you help ...
0
votes
1answer
25 views

How to restore truncated MySQL table from binary logs?

I have a mysql server and while working on it I accidentlly truncated the wrong table. I do have a mysql dump wich I immediately used to restore my database structure, but I still miss some entries in ...
0
votes
0answers
35 views

How do I recover my data in Oracle

I am using Oracle 11 XE, I have some small applications on this, by mistake I have uninstalled Oracle from the system. But I can see the data files still existing in the server in this folder D:\oraxe\...
1
vote
3answers
315 views

Oracle 11g ORA-01190: control file or data file 1 is from before the last RESETLOGS

I am running Oracle 11GR2, Enterprise Edition Release 11.2.0.3.0. I got one of my Test DBs corrupted today. Luckily, I have 2 weeks of backups in the Net Backup server, so I thought, "This is easy, ...
2
votes
0answers
92 views

InnoDB crashes on trx rollback

I have InnoDB assertion failure during the trx rollback 160316 10:47:31 InnoDB: Rolling back trx with id 5ADBE4173, 1 rows to undo 160316 10:47:31 InnoDB: Assertion failure in thread ...
0
votes
0answers
29 views

How to troubleshoot ORA-00333 with NOARCHIVELOG mode

I'm getting the following errors when I try to connect to database: ORA-00333: refaire bloc 8746 d'erreur de lecture de journal compte 7562 Errors in file C:\ORACLE11G\diag\rdbms\aim51\aim51\trace\...
0
votes
2answers
70 views

SQL Server database stuck in Recovery after Restoring .BAK to same instance

We've had an issue crop up a few times -- maybe we're not using 'best practices' to restore, but appreciate any advice. We run an IIS app with a SQL Server database, and sometimes we run two+ ...
0
votes
0answers
23 views

Can I merge a newer version of a database with a backup copy

I have a backup of a database, and a newer version of the database. The newer copy, however, is does not include information that is in the older backup. I want to merge these into one - all tables. ...
2
votes
1answer
521 views

Availability Group database stuck in Not Synchronizing / Recovery Pending mode

While upgrading the storage in a SQL Server 2014 SP1 (12.0.4422.0) instance we ran in to an issue where two of the databases would not start on the secondary after restarting SQL Server. The server ...
2
votes
1answer
41 views

How do I recover my database after losing a tablespace with indexes?

I'm thinking of moving all the indexes in my PostgreSQL 9.3 database to a tablespace on an SSD for improved performance. This SSD is not in a RAID array and I need to consider a scenario where it ...
2
votes
1answer
172 views

Can I get pg_rewind to show me lost data after a Postgres failover?

Say I have Postgres setup with a warm standby using the build in replication features. Now, imagine a scenario where the data centre the master loses power and the slave is in another data centre and ...
1
vote
0answers
52 views

Three Vital Postgres Columns Corrupted

I run a small website which uses a Postgres database. There are regular back ups based on the amount of traffic we have every few days but there was a recent surge of activity just before a power cut ...
4
votes
2answers
593 views

Restore database to point in time from full backup only

I have a database with recovery mode set to FULL. It's a dev database and I have two full backups dated 19th and 27th i.e. latest. One of the developer did some changes on 26th and I want to rollback ...
2
votes
3answers
192 views

Automated regular tests of your backups

I was doing some investigation on how other DBAs go about performing automated regular tests of their database backups to ensure recoverability in case of disaster and I'm quite disappointed at what ...
0
votes
1answer
50 views

Is there any way to recover lost table data on sql server without backups?

Unfortunately some tables are completely deleted with important data. The database is hosted on azure, but there is no back up for past 1 month as well. Is there any way I can get the lost data? The ...
6
votes
1answer
824 views

Why does database recovery take so long?

On my SQL Server 2012 x64 Std instance I had a large transaction fail due to the transaction log filling up yesterday, it couldn't be rolled back and SQL Server has restarted the specific DB to ...
4
votes
0answers
61 views

VLDB is stuck in recovery state. It's a permission issue, now what should I do?

SQL Server database which is very large (4TB) is stuck in recovery state. Reason: Data center had a planned downtime and we had to turn the physical machine off and when it turned on, as I read in ...
3
votes
1answer
217 views

Reattaching MDF files recovered from RAID 5

We had been running a SQL Server 2005 server for many years at our company when just recently, we ran into some trouble. The server was configured with RAID 5 and had one hot spare disk in the array. ...
3
votes
0answers
91 views

Recovery from Live to a new Slave Server - PostgreSQL - ERROR

I've started a new SLAVE PostgreSQL server set up. master: 192.168.100.1 slave1: 192.168.100.2 slave2(NEW SLAVE) 192.168.100.3 * NOTE: I run the pg_basebackup from another STANDBY SERVER. Not ...
1
vote
0answers
156 views

How to fix postgres stuck in recovery mode?

I have Jira and Confluence installed in a server. We didn't have any free disk space one day, and these services didn't started correctly, so after deleting some files we now have some free space ...
0
votes
1answer
40 views

How to recover the data from Redo Log Group which has not been archived yet

I have a normal situation where we have 3 Redo Groups (A,B & C) with 1 member (100 MB) each and database is also in Archive log Mode. In normal scenarios whenever there is redo log switch, there ...
1
vote
0answers
48 views

mysql innodb - strange data loss

I am running a mysql database on linux with several InnoDB tables. At some point, the ibdata1 file got quite big and I wanted to delete it. So I made a dump, deleted the file and restarted the server. ...
6
votes
1answer
426 views

Database msdb stuck in recovery

I encountered a problem while testing recovering backups (Veritas BackUp Exec 2015, just for you to know). Main Problem is: I couldnt restore the databases - looking on the target Server where I want ...
1
vote
1answer
39 views

automatic innodb redo log archiving

We have an option to do recovery through bin-logs, but we thought recovery through bin-logs is not 99% consistent because there is no LSN(Log Sequence Number)/SCN (System Change Number) in bin-logs (...
7
votes
1answer
390 views

Is it possible to restore SQL Server DB from transaction log (no MDF)?

We had a SQL Server 2005 server that housed roughly 200 low/no traffic archive databases, and that server was not backed up to any other device. The database files (MDF and LDF) were stored on a RAID ...
0
votes
1answer
31 views

Raid Configuration for MS SQL server [closed]

Please Help... What are the best RAID configuration for MS SQL server. High availability, redundancy and recovery are require. All I need is best performance. cost is not a factor for me but a 500-800 ...
3
votes
2answers
43 views

Restore PostgreSQL database (or db names) to new version, from files?

Scenario in short: a development laptop broke old HDD is still readable new laptop has PostgreSQL 9.4 instead of 9.1 both laptops use a flavor of Ubuntu Linux Question 1: Is my understanding ...
3
votes
1answer
63 views

How we can recover MySQL database (Innodb,myisam)

I have found some recovery tool innodb-recovery but it works only on linux machine, I would like to know how to recover innodb tables on windows. Transaction ID based recovery Cancel based, Change ...
7
votes
1answer
371 views

Can I recover a SQL database from Standby/Read-Only without a standby file?

Is there any way to recover a SQL database from Standby/Read-Only mode if the "standby file" is missing? (I see some references calling this a TUF file in a log-shipping scenario, but in my case, it ...
0
votes
1answer
37 views

SQL Server - Recovery Pending Error

We are running a series of Delete Queries to free up space on our SQL Server (2012) I was able to recover files after the "Recovery Error", but it is very time consuming. So I keep the size of my ...
0
votes
1answer
86 views

Oracle 11 rman db restore file corruption

First to mention that I came to the need of asking help after furious research I reattempts for about 3 weeks. I checked previous threads in Oracle community but nothing works for me. I am trying to ...
1
vote
1answer
249 views

RMAN backup of RAC database failing

Backup goes through if I don’t have any explicit connection to any instance : RUN { ALLOCATE CHANNEL ch1 TYPE DISK FORMAT '\\192.168.2.11\test\DF_CH00_%U'; ALLOCATE CHANNEL ch2 TYPE DISK FORMAT '\\...
2
votes
0answers
138 views

Data Corruption - ERROR: could not open segment 2 of relation

I am getting the below error for a production database. I am new to PostgreSQL databases. I need help to get this fixed. 2015-10-28 10:25:04,154 [monitor-thread-pool1-thread-6] ERROR [org.hibernate....
0
votes
2answers
163 views

Unable to start Oracle database

We have a oracle database, one data file(users table space) of the instance got corrupt and another data file(containing application data) was deleted due to some issue. The database is in ARCHIVELOG ...
-1
votes
0answers
35 views

Unable to start Oracle database [duplicate]

I have a oracle database, one data file(users table space) of the instance got corrupt and another data file(containing application data) was deleted due to some issue. The database is in ARCHIVELOG ...
1
vote
1answer
109 views

Bringing SQL Server filegroups online

We've experienced an sql injection attack which corrupted our main db. The main db had two partitioned tables into filegroups. The corrupt database entered into Suspect mode, and it's been ...
1
vote
2answers
61 views

Oracle standby database recovery stopped

I have a primary and an standby database. Because my file-system became full in standby database, the recovery has stopped in standby. This is the present state of sequences in primary and standby: ...
1
vote
2answers
138 views

Automate - recover database using backup controfile

I am trying to automate a periodic clone of a database from one environment into another changing the database name. I have done this many times manually by doing a begin/end backup on the source ...
2
votes
1answer
75 views

Change recovery mode and enforce a transaction log backup?

I am going to do a special data deletion operation - once and during a maintenance with no user access (Sql 2008 r2). The result is a large deletion of millions of blob data from a table by re-...
2
votes
1answer
259 views

SQL Server 2012 Always On Setup with two nodes

I have AlwaysOn setup with two data nodes and one witness. I faced an issue where my PRIMARY Server restarted abruptly. Here're some issues I faced during this timeframe. Due to abrupt restart of ...
0
votes
0answers
63 views

Restore a TokuDB table from main and key files only. (Status file missing)

I have a TokuDB table that for some reason has a missing _status.tokudb file. I am not yet sure, whether the file is missing due to a TokuDB crash or not. Question is: Is there a way to recover ...
0
votes
0answers
49 views

Recovered database files can't be attached

I have recovered my hard drive with my databases mdf and ldf files. When I want to attach them I get a 9004 error: Error: 9004, Severity: 21, State: 1. An error occurred while processing the log ...
0
votes
1answer
292 views

MySQL: Recover Master from Slave after failover

I have replication running between two MySQL instances on two separate servers. Let's say M is the master and S is the slave. It's setup as one way replication M->S. I currently have S as read only ...