Questions tagged [recovery]

Reconstructing a database.

Filter by
Sorted by
Tagged with
0
votes
1answer
34 views

Corruption of files in postgres: The database subdirectory “base/13067” is missing

Right, my PostgreSQL database 11.1 is on top of a GlusterFS. My GlusterFS break, my backup was being done on another table and I don't have backups anymore. I started the database on a docker ...
0
votes
2answers
43 views

SQL Server 2019 Database stuck In Recovery state after restart [duplicate]

SQL Server was restarted by mistake, when it came online, database came back in "In Recovery" mode. Check from error it says "Recovery of database 'DB1' (5) is 8% complete (...
0
votes
0answers
9 views

mongo replica is down

I have A mongo replica with 6 nodes, not sure why but 4 of them went down and two entered to recovery state. each time I tried to start the service of one of the down nodes it fails with error there ...
0
votes
1answer
46 views

What is difference between starting Instance with -T3608 and with -f?

I simulated a corruption of model database on test environment just for learning purposes. While reading others blogs and articles about it I stuck on the question, what is difference between starting ...
0
votes
1answer
44 views

SQL Server database tries to restore itself automatically (and gets stuck)

I currently run into an issue, that a SQL Server Database has the state 'recovery pending' every morning. No one has started a database recovery, the server itself decides to do it. The recovery ...
1
vote
1answer
58 views

Oracle 12c recovery without system file

Scenario: Deleted system files (dbf files); and trying to recover database back to normal using available control files, and some redo logs. Backup is not available, nor are archived redo log files ...
-1
votes
1answer
28 views

Does SQL Server perform instance recovery after clean shutdown compared to Oracle Database?

If Oracle detects that an instance recovery is needed (like issuing shutdown abort command or crash happens), it will initialize recovery process. What about SQL Server? Does it behave in the same way?...
0
votes
0answers
37 views

PITR Restore on Postgresql Windows

I have Postgresql 11 running on Windows server and master/slave replication working perfectly. I have enable the wal_archiving and also i have enabled automatic backups using pg_dump I need to ask if ...
1
vote
0answers
70 views

Database in suspect mode

I'm experiencing a tough issue for me. When I was updating some columns into the database I have previously installed, the main memory corruption led the database jump into the suspect mode. I follow ...
0
votes
0answers
13 views

Point-In-time-recovery in Greenplum Database

We have recently setup greenplum. Now the major concern is to setup strategy for PITR. Postgres provides PITR capability but I am a little confused as how will it work in greenplum as each segment ...
0
votes
0answers
20 views

High RAM usage during Postgres PITR

We're currently running Postgres 10 in our infrastructure with Barman managing weekly full backups and holding onto the WALs. Because of the size of our DB, the WAL volume, and resource constraints ...
0
votes
1answer
48 views

Postgres Server staying in read only mode after a barman recover command is executed

All, I am trying to perform a PITR restore using barman using recover command. The problem is that the server remains in the read-only state once the barman recover is done. Is there a way by which ...
2
votes
2answers
316 views

Database cannot be opened. It is in the middle of a restore

I have executed these two commands: USE master GO RESTORE DATABASE test FROM Kingston WITH NORECOVERY GO USE master GO RESTORE LOG test FROM Kingston WITH STOPAT = '2020-05-13 14:05:25', RECOVERY; ...
3
votes
0answers
55 views

Why recovery took longer time even though analysis phase is not that long

We are doing Volume Snapshot restoration from Production to Warm Stand-By Server on daily basis. Daily it takes around 10 mins for DB to recover. But yesterday it took 44 mins to recover. I am ...
1
vote
2answers
50 views

Is it possible to restore a database with database backups starting on top of a restored server point in time snapshot that is out of date?

If I regularly backup my whole server where a SQL instance and database lives, and restore it to a different machine, can I use the database backups that have occurred (on the original server) after ...
0
votes
0answers
293 views

Why can mysqlfrm not read from my .frm file? See debug output

I'm working on a project at home and learning databases as I go. Because of my inexperience I've just learned the hard way that cut/pasting .ibd files is an extremely bad idea. The tables have ...
1
vote
2answers
51 views

Associate BAK file with SQL Server database

One of our users deleted a lot of data from one of our database applications, and I need to find a way to restore it. I have a bak file and full recovery mode, but there is a catch. This bak file is ...
0
votes
1answer
62 views

Is accelerated database recovery available in SQL Server 2019?

SQL Server 2019 CTP introduced a new feature – accelerated database recovery. But then something strange started to happen: If we look at doc page about this feature, we would see no mention of SQL ...
0
votes
2answers
51 views

Why does SQL Server start REDO phase from minLSN instead of last CHECKPOINT?

while reading an article from BOL, I stuck on the picture which explains the recovery process of database (without ADR): Shouldn't Phase 2:Redo start from Last CHECKPOINT as till that point ...
0
votes
0answers
25 views

Carving deleted records from MyIsam Engine

I researched on the internet for a long time. According to my research, I found that it is not possible to bring back the deleted row in MyIsam. MYD, MYI, FRM files are available. I can only repair ...
0
votes
1answer
23 views

Recover raw Databases from corrupted MySQL 8 + Windows Server Implementation

I have a (Virtualized/Hyper-V) MySQL 8 (8.0.16.0) DB server whose installation has become corrupt and will no longer start the service, or report any errors as to why it won't start (this is a virtual ...
0
votes
0answers
104 views

Import Sybase SQL Anywhere 8 DB into SQL Server without access to Sybase

This is my first post here and its a doosy. I am facing what seems to be a unique situation at the moment. I am in the process of moving my client to a new environment which includes decommissioning ...
0
votes
3answers
63 views

Why does InnoDB corrupt tables upon recovery?

When setting innodb_fast_shutdown=0 MySQL drops all incomplete transactions before shutting down/crash. The default value is 1, which is understandable to preserve incomplete transactions. However, ...
0
votes
0answers
23 views

Restoring MySQL databases from var directory files backup?

I have no known sqldumps of these databases but have the files recovered from my AMPPS installation on a crashed computer. I cannot recover them in AMPPS on this one as I have Laravel Valet installed (...
1
vote
2answers
231 views

How to restart MS SQL server right, what is best practice to do that?

I`m quite new to DB administration. I have a problem when I restart SQL server, one of the databases goes into Recovery mode and automatically repairs the DB in 30 min. I don't know why this happens....
0
votes
0answers
72 views

Attempting to Restore Database From ibd Files but Receiving Errors on Tablespace Import

Recently, a customer (who didn't take backups of their system for whatever reason) had a database disaster so their production database had all of its files removed EXCEPT its ibd files. I have ...
5
votes
5answers
550 views

Is there a way to reduce the amount of time spent on a point in time recovery?

I'm pretty sure I know the answer to this, but the limitations of a point in time recovery blows my mind. Say I have a 2TB database set to FULL recovery mode. I diligently take weekly full backups, ...
0
votes
1answer
85 views

How to resynchronize replica in Postgresql

I have a server with Centos6 and Postgresql 9.2, I have set up a replica in postgresql to another server of the same characteristics, today in the morning I have an error in the archiver process on ...
0
votes
0answers
205 views

SQLite: Extract data from the `-wal` file

Yesterday I accidentally deleted an SMS banking notification thread on my Android device. A classic case: I didn't backup the messages for very long time. After flashing the recovery and rooting the ...
-2
votes
1answer
75 views

Deleted oradata folder under oracle home by accident

While setting up a new server, I accidentally deleted the oradata folder in the working Database server. I have no backup of the working database, I googled and found flashback option to recover, but ...
0
votes
1answer
103 views

Oracle Can a Dropped View Be Recovered?

I dropped a view 20 minutes ago. Can I recover it? If yes, how?
0
votes
0answers
83 views

Is it possible to extract text from an .ibd file?

I had a small mediawiki installation that became corrupt. The MySQL installation is no more, I only have the data directory. Long story short, I'd like to dump the raw page content from the text.ibd ...
0
votes
1answer
45 views

Restore from .db folder for Analysis Services

There is an objective to recover cube from long time ago retired MSAS instance. Issue I'm currently standing with is that actual .abf backups are now in a cold storage and recovering them would take a ...
3
votes
1answer
109 views

Decrypt T-SQL log backup header and read LSN

For some reason I need to read the LSN from the T-SQL logs backups without restoring them or even their headers (I assume even restoring only their headers will change the LSN on the database side too,...
8
votes
1answer
583 views

Database Stuck 'In Recovery' with command XTP_DB_RECOVERY

We recently converted a table to memory optimized data. Our backups have all ballooned (3x300GB files to 3x600GB files for Full, 3x50GB to 3x250GB for Diffs), and startup has been getting ...
0
votes
0answers
96 views

Recover InnoDB tables with FRM, ibdata1 and log files, but without ibd files (innodb_file_per_table = OFF)

I have spent three days investigating how to recover my database. I have the ibdata1, the FRM, and the ib_logfile0 and ib_logfile1 files (It seems I don't have the ibd files since my configuration ...
1
vote
0answers
165 views

MySQL Won't Start - InnoDB Table Corruption

I've found lots of articles and questions related to this issue, but none that seem to apply or work in my situation. MySQL will not start after I had to do a fsck repair on my server's hard drive (...
1
vote
0answers
67 views

Unable to recover MySQL 5.6 (InnoDB) database

I've tried multiple different suggestions from other questions on here, with no luck... This is a MySQL database running version 5.6.41, using the InnoDB engine, and the instance is running out of a ...
1
vote
3answers
260 views

Lost data, how to recover (sql server)

We currently have a db that the backup has been set to Simple that is being backed up every night (we have backups for last 7 days), is it possible to find records that were deleted in say June? The ...
0
votes
1answer
14 views

How do I know which binary log file to open for continous backup?

This really has me confused, I want to have point in time recovery so I plan to take occasional full database dumps, and then between those dumps I plan to use stop-never with mysqlbinlog. But I'm ...
0
votes
1answer
122 views

How do I recover deleted rows from one table while having Recovery SIMPLE Model? I am using Microsoft SQL Server 2014 [duplicate]

How do I recover deleted rows from a table while having Recovery SIMPLE Model? Database is in Microsoft SQL Server 2014. I have managed to find them in fn_dblog table before data is overwritten with a ...
1
vote
1answer
368 views

Why do we add NO_TRUNCATE and NORECOVERY options while taking tail log Backup?

Assume that my mdf file is deleted and I set my database into single user mode. The first thing that I do is take tail log backup. My question is do I need to add NORECOVERY option while taking tail ...
1
vote
1answer
136 views

How to recreate Oracle db from .ora and .dbf?

I have a number of files left from a previous Oracle db and I would like to create a new one from the files. The files include: init_locdb.ora 16 .dbf files spfilelocdb.ora log files .ctl Could you ...
5
votes
1answer
169 views

Checkpoints on secondary replica AlwaysOn AG

Setup 3 Node Alwayson cluster - 1 sync and 1 async secondary replica - SQL Server 2012 Situation We are witnessing PageIOLatches when reading from the asynchronous secondary replica. This is ...
0
votes
0answers
95 views

Problems connecting to database

I have a user experiencing problems with mounting/contacted a database. I work in infrastructure so very very little knowledge on db's -- guess I was first/only port of call, so any advice would be ...
0
votes
1answer
44 views

How to verify data integrity of data folders after data recovery in MySQL and PostgreSQL?

I wonder if there is a way to verify data integrity of data folders from a data-recovered hard disk, both MySQL and PostgreSQL?
0
votes
1answer
143 views

MongoDB stuck in startup2 state

I have a Mongo replica set (MongoDB server version: 4.0.3) with primiry, secondary and arbiter. Size of database is about 7 Tb. I add a member to replica set. It stucks in sturtup2 mode for a month! ...
0
votes
1answer
2k views

Mysql innodb recover from frm and ibd

There are numerous question (in this site and elsewhere on the internet) about how to recover innodb database from *.frm and *.ibd file (the point: when you have the undamaged ibdata1). Situation: I ...
1
vote
1answer
42 views

Access oracle database from control file

When I asked a client for a copy of his database he sent me a .ctl file, it seems it is a control file of an Oracle database. I have no experience in Oracle, I'm a SQL Server guy. I have installed an ...
2
votes
0answers
507 views

Database stuck in recovery pending but can't set to ONLINE or EMERGENCY

We have a database server who's data drive filled up see error log: Error: 17053, Severity: 16, State: 1. D:\Program Files\Microsoft SQL Server\MSSQL11.MSSQLSERVER\MSSQL\DATA\MyDb_log.ldf: Operating ...

1
2 3 4 5
8