Questions tagged [recovery]

Reconstructing a database.

Filter by
Sorted by
Tagged with
1 vote
1 answer
29 views

Databases in Recovery Pending or Suspect Mode after SQL Server service restart

This issue applies for SQL Server 2019 Always on environment with the latest CU applied. When SQL service needs a restart or the entire OS needs a reboot, some of the DBs come back in recovery pending/...
-1 votes
1 answer
36 views

How to restore a Oracle Database if i only have the datafiles?

My Oracle database Test server crashed, I have no rman backups but I still have the datafiles because they are on a SAN Storage, so if I have datafiles, how can I restore my Oracle database?
  • 29
0 votes
1 answer
28 views

PostgreSQL stops continuous recovery without error

I have some Postgresql 10 instances running on Windows Server that are in continuous recovery mode. Once in a while they just stop recovering without giving any errors, like in this example log file (...
  • 33
3 votes
3 answers
78 views

How do I restore multiple transaction log backups after restoring a full backup SQLSERVER 2019

I am creating my DR strategy, and my full back-up recovers fine. The full backups are taken with a modified version of the Ola Hallengren scripts. The file timestamp of the full backup shows 07/26/...
  • 35
0 votes
1 answer
79 views

How to recover Postgresq data from $PGDATA/base files after system crash

I was working on my Ubuntu machine and left it on to grab food. Upon returning, I found it had shut itself down. It was not power failture because I have a home backup system and lights never go off ...
0 votes
0 answers
30 views

Are there any educational transactional databases?

Are there any educational transactional databases for databases, just as there is educational OS xv6 for OS? I would like one that implements MVCC and recovery of transaction.
-2 votes
1 answer
34 views

How do admins manage RTO for sql server with large number of dbs? [closed]

Assuming I have 140 dbs and daily full and log backups. The crash recovery process would be to restore each db one by one using the backups. Therefore the RTO to get the system up ready will be high ...
  • 2,814
-2 votes
1 answer
86 views

What is the general recommendation for sql server crash recovery from mdf/ldf vs backups for least data loss? [closed]

I'm learning steps to recover from sql server OS or OS disk crash. Assuming the OS or OS disk is corrupted and unrecoverable. I know that a HA solution like fci or ag is better suited to prevent such ...
  • 2,814
1 vote
0 answers
37 views

Data in one or more tables corrupt after recovering tables with alter table discard/import tablespace

I accidentally dropped my schema and had to recover all the tables per the steps in this post; Recover schema and the data in it from accidentally deleted schema However, I notice that all of the ...
0 votes
1 answer
247 views

Recover schema and the data in it from accidentally deleted schema

I did something careless. I deleted a schema. I have backups of the \mysql...\data\refadmin folder so I (hope) I have all the tables and data. That's backed up daily. When I look at work bench, I ...
1 vote
0 answers
25 views

Database deployment rollback

I am looking for documentation on how this is done in MS SQL. I've done some searches and haven't found how to do this. There is documentation on how to set up HA and DR... But this specific process I ...
-1 votes
1 answer
41 views

Recreate broken Database

Here is the scenario - I have a Database that is suffering from Error 824, dbcc checkdb repair_allow_loss has not rectified it and unfortunately the Backups are also corrupt. However, I am able to ...
2 votes
1 answer
103 views

Fix mysql replication crashed due to underlying storage corruption

we have critical database server running on two virtual machines. one virtual machine crashed due to underlying storage problem and we had to move it to different storage medium and recover the xfs ...
0 votes
1 answer
63 views

Postgres (9.6) hangs on start after storage upgrade

I have been running Postgres on a Linode with the data directory mapped to an external volume. Yesterday Linode prompted me to upgrade my storage to NVMe so I did. Unfortunately, following that, ...
  • 101
0 votes
0 answers
17 views

Recover profile of deleted user from backup, and inject into working MYSQL database

Can someone specify a procedure to recover the complete profile of a deleted user, extracting the old data from a backup (gz compressed MySQL) and injecting it into the empty profile of the working ...
3 votes
2 answers
219 views

Estimating the best restore time from saved backups in SQL Server

I am looking for guidance and any advice on how to estimate the restore time for SQL Server databases once copied locally to the server. This is just to layout a strategy what will happen if in future ...
2 votes
1 answer
486 views

How to revert Postgres to some time ealier?

Consider this scenario, I made some update to a running Postgres database, and some bad things happen. Now I want to rollback the database to 1 hour earlier, what's the process to achieve this? I was ...
0 votes
0 answers
22 views

Attaching a deattached database fails on SQL Server due to CREATE FILE encountered operating system error [duplicate]

I have a big SQL Server database (500GB) for my study and using the latest SQL Server Developer version I am not a DBA, I just have little knowledge in Databases due to OS issues, I had to format my ...
  • 189
0 votes
0 answers
464 views

Oracle Rman recovery to another database on different location

We had production user facing data loss from production Oracle database and only wanted to recover just one schema in the test database from a week ago. Backup team was able to retrieve the physical ...
's user avatar
0 votes
2 answers
78 views

Does only a full backup (and no tlog backup) of a db in full recovery model allow for point in time recovery?

I have a database in full recovery model. Full backups are configured to run every Sunday and log backups run every day. Log backup files are destroyed after 30 days. Full backups are destroyed after ...
  • 2,814
0 votes
1 answer
189 views

PITR with barman fails - is my understanding even accurate?

I mange to take backups and recover them to my postgres-server. Now I want to see what PITR is able to do with these steps create a backup (20220111T062908) wait a minute create a new database (at 06:...
  • 131
0 votes
1 answer
53 views

Should databases be dumped to SQL format or custom archive?

I am wondering, what is the industry standard regarding dump formats, when making and storing the database dumps? Is it better to dump it to a custom-format compressed and unreadable archive, or just ...
  • 115
2 votes
1 answer
230 views

How to list backups when not connected to target DB in Oracle RMAN

I'm trying to list backups in RMAN completed within a certain date range. This works fine when I can connect to the target database and recovery catalog. However, I'm assuming a situation where I am ...
1 vote
2 answers
152 views

Make running MySQL with InnoDB flush everything to file to allow file-level live backup

A client has a file-level backup, where every relevant file of a critical webserver is synced to another webserver around 1am. This includes the /var/lib/mysql directory where the databases of that ...
  • 13
2 votes
2 answers
36 views

Microsoft SQL Standard 2012 DB recovery without .BAK file?

Morning, I'm posting for some guidance on an issue we're up against. We had a server crash and don't have .BAK file for our SQL DB (the backup/images failed). Anyhow, we DO have a file level backup of ...
  • 21
0 votes
0 answers
59 views

Barman Recover Unable to start postgresql 9.6 FATAL: could not access status of transaction 722811824

I have done a barman recover to a different server, however I am having issues starting postgresql 9.6 FATAL: could not access status of transaction 722811824 DETAIL: Could not open file "...
  • 195
0 votes
1 answer
48 views

All file in redo log group corrupt

ORA-00313: open failed for members of log group 2 of thread 1 ORA-00312: online log 2 thread 1: '/u02/oraredo/O12C/redo02b.rdo' 0RA-00312: online log 2 thread 1: '/u02/oraredo/O12C/redo02A.rdo' i got ...
1 vote
1 answer
37 views

Which log backup to apply first during recovery?

During recovery, I have restored the latest full backup, followed by the latest differential backup. Last Full backup had ran on Thursday 9.15pm. Last Differential backup had run on Sunday 3.15am. Log ...
  • 2,814
1 vote
0 answers
58 views

How can i restore the tablestructure and recover data when i drop table column

i have some test table create table test123(ids number,emp_name varchar(100)); next i insert 1 record into the table and commit the changes insert into test123 values(1,'asdzxc') after that i issue ...
2 votes
2 answers
183 views

Will snapshot backup (non copy only) break restore chain?

I have full backup running at 6am on Sunday. Differential backup running at 6am everyday. Log backup running every hour. There is also a Snapshot backup running at 3pm everyday. This is not a copy ...
  • 2,814
3 votes
1 answer
195 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 ...
  • 33
1 vote
2 answers
238 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 ...
1 vote
1 answer
126 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
1 answer
964 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 ...
  • 121
0 votes
1 answer
33 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 ...
  • 101
2 votes
1 answer
322 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 ...
  • 195
0 votes
1 answer
35 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 ...
's user avatar
2 votes
1 answer
2k 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 ...
  • 266
2 votes
2 answers
228 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 ...
2 votes
2 answers
570 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
1 answer
37 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
1 vote
0 answers
597 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
1 answer
1k 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
1 answer
120 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
1 answer
283 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, ...
  • 127
2 votes
3 answers
274 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 ...
2 votes
1 answer
360 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....
  • 1,193
0 votes
0 answers
149 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 ...
  • 187
2 votes
1 answer
64 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
0 answers
460 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 ...

1
2 3 4 5
9