Questions tagged [recovery]

Reconstructing a database.

Filter by
Sorted by
Tagged with
2
votes
1answer
32 views

Compensation Log Records (CLR) in UNDO-Phase of Database Recovery

The compensation logs' redo-information corresponds to the undo-information of the log entry that made their creation necessary during the undo-phase. That sounds to me like the CLRs redo information ...
1
vote
2answers
24 views

recovery stopping before commit of transaction- Postgres 11 PITR

I am trying for PITR on a duplicate node. Here are the steps I am following. Start backup on source node. select pg_start_backup('backup') Copy all the files on destination node using these rsync ...
0
votes
0answers
40 views

Best RMAN Strategy for Oracle VLDB 30TB in NOARCHIVELOG mode

I would like to have your ideas regarding how to optimize backup/restore in a VLDB Oracle Database Environment: RAC 19c 4 Nodes Version 19c Size: 32TB Mode: NOARCHIVELOG Let me explain some ...
1
vote
1answer
46 views

Starting SQL server Database in forced recovery mode

I would like to force SQL Server database to go in recovery mode when restoring from disk image snapshot. Any suggestions to force a single or group of databases in recovery so that additional ...
0
votes
1answer
87 views

Recovering InnoDB database from backed up “data” folder in XAMP in Windows 10

I copied the data directory from mysql folder and uninstalled the XAMPP as the MariaDB was not starting. I installed XAMPP same version and backed up the data folder into mysql data directory. At ...
0
votes
1answer
29 views

Restoring a MySQL database

My Ubuntu 16.04 server was recently hacked and my host allowed me to recover the file system via FTP, closing all other ports thus disabling me from logging in and stopping any services. I have the ...
2
votes
1answer
94 views

Strategy on Standby restore option for hourly log shipping file

I am trying to come up with a strategy of keeping up with daily database update process using "standby" restore mode. I am getting 24 log shipping files (for the previous day's each hour ...
0
votes
1answer
21 views

Is possible to restore BD SQL Server without key encryption from 2008 R2?

I have a database that has an encryption. The encryption key was lost. This database is on a SQL Server 2008 R2 server, and my mandate is to migrate this database on a more recent server. Is there a ...
1
vote
1answer
130 views

How do I recover data from the postgres data directory on my hard drive?

I had an old iMac which stopped working a while ago I take weekly backups of the database I was updating which contains feed items from several rss feeds I am still missing the data for the last week ...
2
votes
2answers
145 views

Fast recovery vs Accelerated database recovery in SQL server 2019

while comparing the features available in different SQL server editions, i see that Fast recovery and Accelerated Database recovery are 2 separate features. I am unable to find any documentation ...
0
votes
0answers
173 views

galera_new_cluster hangs with galera_recovery

My cluster crashed and i cannot restart the first node with galera_new_cluster. The nodes are distributed geographically in France with medium latency of 12ms. It remains on /usr/bin/galera_recovery ...
1
vote
2answers
75 views

SQL Server - Restore only primary Filegroup but bring the database online

I'm trying to find out if it's possible to bring a SQL Server 2016 Enterprise database online by restoring only the primary Filegroup. My scenario is, we have a fairly large OLTP database, of around ...
0
votes
1answer
15 views

Which folder I use for recovery mysql database

Accidently deleted mysql database and reload again.But ı cant find my old database and no have backup.This is picture that mysql ProgramData folder. Which folder should ı use for recovery? Thanks ...
1
vote
0answers
205 views

How to repair a block based Rocksdb sst file with corrupt masked crc32 checksum in that case? [closed]

Environment I'm using the Ethereum cryptocurrency in a way which requires something called full Ethererum archival node where each new blocks (somewhat a batch of recent transactions) is added to the ...
0
votes
1answer
179 views

Recover dropped mysql sys schema

I dropped the sys schema while tinkering around mysql 8(current version). Is there a way to recover it. I am using ubuntu 20.04. I tried using the mysql documentation but I couldn't find anything ...
0
votes
1answer
30 views

How to set up mysql docker container with existing ib* files?

Related to a previous issue, I'm trying to recover some data from existing ib* files from a crashed server. The database version is 5.1.69, so quite old. One of the responses was to install MySQL 5.5, ...
0
votes
1answer
64 views

How to use wal_level in Postgres to set the recovery mode to simple for a database like how Microsoft SQL Server does it?

In Microsoft SQL Server, ALTER DATABASE CURRENT SET RECOVERY SIMPLE WITH NO_WAIT; will set the recovery mode for a database to simple, so the transaction log file space can be re-used. In Postgres, ...
2
votes
3answers
135 views

when we restore and when we recover a database?

Restoring involves copying backup files from a secondary storage (backup media) to disk. This can be done to replace damaged files or to copy/move a database to a new location. Recovery is the process ...
0
votes
0answers
13 views

How to properly cut/filter binlog file to perform single table PIT?

I've been trying to perform a single table PIT. After cutting off a dump the portion related to the table I want to restore in time, I've been trying to do a similar operation with the binlog file ...
2
votes
1answer
246 views

How crash recovery process works in SQL Server?

I would like to ask a question regarding recovery process while restoring database operation. Let's say I restored a full backup with NORECOVERY followed by restoring two t-log backups with NORECOVERY....
0
votes
0answers
13 views

How to perform partial PIT Recovery without using a staging database in MySQL? [duplicate]

I have a full physical backup and binlogs available for my MySQL instance. Is there a way to perform a partial point in time recovery (meaning restoring in time a subpart of the whole database, i.e. ...
0
votes
0answers
16 views

Point-In-Time Recovery of a single table having full physical backup in MySQL?

I need to do a point-in-time recovery, having a full physical backup and the bin-logs available. One way is for sure by mean of an external instance where one can restore the full database and then ...
0
votes
0answers
45 views

Mysql trying to drop table and how to recover data?

I have on lamp setup where suddenly I see all the database files are missing and gone and when I checked the error logs I can see few of this lines. InnoDB: Error: table `com`.`#sql` does not exist in ...
2
votes
1answer
55 views

RMAN Restore control file and SP File

I need to perform an incomplete recovery. We keep 7 days of backups, and I want to restore the database as it was 7 days ago. I've not done this before. My question is: I can use the SET UNTIL TIME ...
0
votes
0answers
207 views

How to restore a MySQL InnoDB with ONLY .ibd files?

I had a Bitnami Joomla! stack running on a computer that suddenly kicked the bucket. I had neglected to make a back-up before this happened so I do not have any dumps or backed up files, but was able ...
0
votes
1answer
78 views

Databases missing after exporting server and rebuilding master DB

We had a server running Microsoft SQL Server 2014 databases on Hyper-V. I exported it (with C: and D: drives) and opened on other machine. I could not start the MSSQLSERVER service because it said the ...
0
votes
1answer
81 views

Cannot restore data using Postgres WAL files

I'm a newbie at PostgreSQL. I'm trying to setup a streaming replication (postgresql 9.1). And I want to test backup & restore on local. I also made backup files successfully (I think so) by using ...
1
vote
1answer
25 views

Latest version to support MySQL 5.1.69 ib* files

Would like to recover InnoDB data from a crashed server. The last backup indicated it was running MySQL server 5.1.69. When doing a recovery, the log files show that the current MySQL won't support ib*...
0
votes
1answer
815 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
400 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
1answer
305 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
173 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
91 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
80 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
140 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
29 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
293 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 ...
4
votes
2answers
3k 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
64 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
807 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
70 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
105 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
91 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
1answer
43 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
251 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
196 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, ...
1
vote
2answers
922 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
138 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 ...

1
2 3 4 5
8