Tagged Questions
2
votes
2answers
57 views
Transaction Log maintenance when switching to Simple Recovery
Background:
I recently inherited 50+ SQL Servers with 450+ databases. The nightly backups are roughly 8TB and, needless to say, we're using more disk space than we'd like. All of the databases are ...
0
votes
2answers
61 views
Restore Oracle tablespace to 2 days before
I have multiple test tablespaces in an Oracle SID. One of the tablespace is updated with wrong data. It works fine 2 days before. I want to restore the tablespace to 2 days before.
Can anyone ...
-4
votes
1answer
44 views
Oracle database and data has been corrupted. Is there a way to get it back? [closed]
The Oracle database has been corrupted and both the data and backups were lost in the corruption. Is there anything I can do to recover my data? It would be terrible if it were all lost.
0
votes
1answer
29 views
OK to put temp tablespace on volatile storage or to omit it from backups? (Postgresql)
I would intuit that it's fine, but I just want to make sure there are
no gotchas from a recovery point of view:
If I were to lose my temp tablespace upon system crash, would this
prevent proper crash ...
0
votes
0answers
28 views
Should I keep pg_xlog on the same disk as data if using disk snapshotting?
We're running on EBS volumes on EC2. We're interested in leveraging
EBS snapshotting for backups. However, does this mean we'd need to
ensure our pg_xlog is on the same EBS volume as our data?
(I ...
0
votes
0answers
60 views
Tape rotation strategies
I am trying to find a tape rotation strategy that would be optimal under the following conditions:
Backup Media Rotation strategy should support the following:
Media Archives required ...
0
votes
0answers
64 views
How to do point in time recovery of binary log files into .sql file
I have written a shell script to do an incremental backup of MySQL database.
For point in time recovery I'm using the binary logs generated in /var/lib/mysql directory.
For point-in-time recovery, Im ...
0
votes
3answers
76 views
Where can I learn about MySQL master/slave, master/master, or clustering setups?
What are the best resources you've read or watched about setting up master/slave or clustering for database replication?
I don't know much about this. I have a database that is getting rather large ...
2
votes
1answer
202 views
Which backup files are needed for a successful restore?
Considering the built-in 'Backup Database' script (backup.bat) that comes with a new installation of the Oracle Express 11g Edition, after finishing the script execution, what folders/files should be ...
3
votes
4answers
151 views
Does it make sense to use full recovery if the data and log files are on the same HD?
We have a database that was set up to use full recovery and my guess is that the reasoning was only to prevent data loss if a failure happened between backups.
We make daily full backups of the ...
4
votes
1answer
148 views
Retrieving data if control file is lost in oracle Database
Suppose if the databases control file is lost permanently (no backup).
Can we retrieve the data from data file in Oracle database?
6
votes
2answers
300 views
PostgreSQL PITR restore
I have a PostgreSQL 9.1 server running on a CentOS 5.8 32bit OS and I have enabled WAL archiving. On this server, there are three databases: databaseA, databaseB and databaseC. Someone deletes a ...
4
votes
2answers
196 views
Change Location of VALIDATE RECOVERY FILES work area
Is there a way to tell the VALIDATE RECOVERY FILES command to use a different location with more available disk space?
When I run the command in RMAN, it fails with the following error stack:
...
4
votes
3answers
718 views
RSync Database File Deltas in SQL Server 2008
Alright, I feel like this is a terrible idea, but I need some help understanding why this is bad:
I'm still working on implementing a disaster recovery/business continuity solution for our ...
2
votes
1answer
176 views
Initial recovery Postgres with backup in sync commit mode
I've got a master and a slave postgres 9.1.3 database. I would like to init the backup database for the first time.
I did the following steps:
Stopped master
Copied all files to Slave
Create ...
1
vote
3answers
251 views
Is it good idea to change Simple Recover Model into Bulk-Logged on ETL system?
We are having an ETL process which inserts lots of data into tables. This database is set to Simple Recovery Model and the transaction log is growing a lot. I was thinking that would it help to set ...
7
votes
1answer
5k views
How can I recover data from the LDF file?
We are using SQL 2005 Express Edition. We want to read the data from the LDF file in order to restore some deleted records.
We tried using a trial version of ApexSQL which helped us a lot. Instead of ...
3
votes
1answer
2k views
RMAN-06054: media recovery requesting unknown archived log, Where is SCN kept?
I have the following situation:
Backups of DB1(located on srv1 server) database are taken everyday at 1:00 AM.
I took backed up files(datafile,archivelog,controlfile,spfile) of 24/10/2011 and ...
1
vote
1answer
128 views
Oracle Backup/Recovery architecture
When we write the following:
allocate channel ch1_tape type sbt;
set controlfile autobackup format for device type sbt to '%F';
restore controlfile from autobackup;
RELEASE CHANNEL ch1_tape;
By ...
2
votes
1answer
116 views
Oracle Backup and Recovery Issue
I have backed up database located on Host1 and restored/recovered it on Host2.
After a while, I backed up DB on Host1 again.
Now I want DBs on Host1 and Host2 be the same using last backup.
How can ...
