Questions tagged [recovery]
Recovery is the rebuilding of a database or table space after a problem such as media or storage failure, power interruption, or application failure. If you have backed up your database, or individual table spaces, you can rebuild them should they become damaged or corrupted in some way.
412
questions
0
votes
1
answer
48
views
How to change from "Read-Only" mode to "Standby / Read-Only" mode?
I changed the database (foo) mode from "Standby / Read-Only" to Active by using the following statement:
restore database foo with recovery
After that, I changed the mode back to Active by ...
- 207
0
votes
2
answers
49
views
Why does (In Recovery) indication show up?
I just noticed that this database is currently in "In Recovery" mode.
How do I change back to normal mode (without (In Recovery))?
This is very active database, and I am trying to be very ...
- 207
0
votes
0
answers
14
views
PostgreSQL 9.6 recovery process stops earlier
Run into a strange issue using PostgreSQL 9.6 database on Windows OS
Using the recovery process with WAL files. Everything works fine - database starts up properly after recovery, no error message
BUT....
- 1
0
votes
2
answers
34
views
How to fix MySQL replication when duplicated key problem appears?
I have data logger software that writes data to master database. There are just 2 tables. If this database is locked or stopped for more than 1 minute I will loose some data that should be stored.
...
- 123
0
votes
0
answers
40
views
"Trying to read" "bytes at“ "outside the bounds of the file"
I have a slight issue.
Yesterday we had a power outage while we were importing data into the MySQL server inside a Docker container.
I'm trying to perform data recovery because this is what the log ...
1
vote
1
answer
45
views
Unable to Repair MariaDB Database Because It Is Read-Only
A recent incident corrupted my MariaDB database and I'm trying to repair it. I followed the instructions on the MariaDB site and successfully started my database at innodb_force_recovery=5. I have ...
- 13
0
votes
0
answers
82
views
Using a different time for recovery after restoring an Oracle Database 19c
After restoring a oracle database with the following command, recovery fails :
CONFIGURE DEVICE TYPE 'SBT_TAPE' PARALLELISM 8;
CONFIGURE CHANNEL DEVICE TYPE 'SBT_TAPE' PARMS 'ENV=(xxxxx)';
CONFIGURE ...
- 938
0
votes
1
answer
24
views
extract a corrupt or delete table
What is the correct way and what is the steps to just recover and restore one big table from sqlserver 2019 backup in production server in an emergency situation?
0
votes
0
answers
185
views
Unable to Recover MySQL Database [Missing FILE_CHECKPOINT]
Using MariaDB 10.7.3 via Homebrew on MacOS Monterey 12.6.1
While trying to recover the database after a system crash, I am stuck with the following situation.
[Note] mysqld (server 10.7.3-MariaDB) ...
- 11
0
votes
1
answer
110
views
Recover deleted redo log files
I have the following problem: all redo log files from an Oracle 19C database have been deleted while the database was running. The database is running on a Linux server. When I try to connecting to ...
- 228
0
votes
1
answer
47
views
How does sql server know whether the dirty pages have been written to the data file?
I understand sql server writes the updates to the data pages (making them dirty) in memory and writes the tlog onto the disk before sending the commit notification to the user.
This question is to ask ...
- 3,153
2
votes
1
answer
120
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/...
- 21
-1
votes
1
answer
51
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
59
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
4
answers
359
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/...
- 37
1
vote
1
answer
509
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 ...
- 111
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
37
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 ...
- 3,153
-2
votes
1
answer
150
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 ...
- 3,153
1
vote
0
answers
77
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 ...
- 19
0
votes
1
answer
744
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 ...
- 19
1
vote
0
answers
34
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 ...
- 173
-1
votes
1
answer
52
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 ...
- 183
2
votes
1
answer
278
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 ...
- 123
0
votes
1
answer
108
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
3
votes
2
answers
545
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 ...
- 765
2
votes
1
answer
1k
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 ...
- 21
0
votes
0
answers
701
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 ...
Color Senz
0
votes
2
answers
136
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 ...
- 3,153
0
votes
1
answer
334
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:...
- 153
0
votes
1
answer
173
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
3
votes
1
answer
481
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 ...
- 31
1
vote
2
answers
258
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
39
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
1
answer
107
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 ...
- 13
1
vote
1
answer
46
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 ...
- 3,153
1
vote
0
answers
95
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
...
- 13
2
votes
2
answers
240
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 ...
- 3,153
3
votes
1
answer
420
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
400
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 ...
- 61
1
vote
1
answer
286
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 ...
- 39
0
votes
1
answer
2k
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
43
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
654
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 ...
- 207
0
votes
1
answer
45
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 ...
berodev
3
votes
1
answer
4k
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
...
- 276
2
votes
2
answers
259
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 ...
- 39
2
votes
2
answers
940
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 ...
- 391
0
votes
1
answer
49
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
762
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 ...
- 111