All Questions
9 questions
0
votes
2
answers
188
views
Oracle: Corrupt datafile will not turn back online?
need immediate assistance on an issue... Oracle Support is taking way too long to respond back on.
We have a corrupt datafile in one of our tablespaces, I attempted to shut the datafile offline, and ...
- 11
3
votes
3
answers
2k
views
Creating/restoring mdf/ldf to non-default file location giving access denied
Default folder is typical C:\Program Files\Microsoft SQL Server\MSSQL13.MSSQLSERVER\MSSQL\DATA. But C: drive on server is almost full.
So, in restoring an 11gb database from another server, I ...
- 131
1
vote
2
answers
175
views
mysqldump file restore while sql is still being dumped
Im using MaridaDB 10, but my question applies to all mysql variants.
I have large dataset (70GB uncomressed when dumped to file).
The mysqldump process takes 2-3hours. The restore process takes even ...
- 11
0
votes
1
answer
9k
views
How to copy tablespace from one database to another database in Oracle 11g
How to copy tablespace and datafiles from one database to another database in Oracle 11g in same server ?
- 81
4
votes
1
answer
994
views
Repair SQL Server Database [closed]
Can anyone give me a complete guide to verifying/repairing a SQL Server database?
At the moment our backup is failing on the Solarwinds database saying the database NetPerfMon is corrupted (we are ...
- 41
0
votes
2
answers
780
views
Discover the original OS of a datafile from a oracle backup
I have just been awarded with the task of recovering a oracle database with some given datafiles. However, nobody knows from which OS this backup comes from.
I have an AIX box to make the recover. Is ...
- 69
1
vote
1
answer
4k
views
RMAN rename datafile created in an archivelog
I'm trying to restore an Oracle database (11.2.0.4.0) to a test system with a different file layout. The production database is being backed up using RMAN, no catalog. We do a full backup of all the ...
- 113
1
vote
1
answer
99
views
1 time shrink of abused databse or restore from backup [duplicate]
I have a database that I have inherited which has been left for a long time to grow and grow. 95% of this growth is caused by 1 log table used by our application. The database is 120GB and in full ...
- 5,785
2
votes
1
answer
469
views
Restore InnoDB tables / database using only data files
I have MySQL Server 5.1.51 installed on Windows Server 2003 as Operating System and using InnoDB as database engine.
I have run DROP DATABASE dbName statement by mistake. I have no backup of that ...
- 236