Question
How often do you test backups with a real restore on a test server?
Weekly or more often
Twice a year or more
Regularly, once a year or less
Did it only once in the past
Never ever done
Answer and see the results
Download PLATO
The free tool for auditing and tuning your database
Version 50 now available
Jun 15, 2008
The DBA-Village forum
Forum as RSS
as RSS feed
DBA Top 10
1 F. Pachot 152875
2 Y. Rifai 116100
3 B. Vroman 93050
4 M. Cadot 77600
5 N. Havard 50900
6 A. Kavsek 45150
7 A. Abd El Latif 43275
8 G. Lambregts 39100
9 A. Deledda 35650
10 D. Blr 31000
About
DBA-Village
Site Statistics
Ever registered36712
Total active23180
Active last 24h53
Active last hour0
Hits last week10375
Hits last month39525
Tips, Scripts, Papers, Events, Links, ...
Link:Effective Use of SQL Trace

Deepak Blr, Jul 13
Script:Free PL/SQL library to generate PDF from Oracle Database

Levallois Pierre-Gilles, Jul 13
Link:New Oracle DBA

positive fanatic, Jul 13
Link:All about the SERVICE_NAMES

Franck Pachot, Jul 06
Paper:A Good Site to get lots of information on Oracle RAC

Sukaina Anis, Jul 06
Latest Forum Threads
Simulating a wrong oracle_home environment but getting a SQLplus error.

hi guys,

if you guys remember, i been asking about oracle_home and oracle_sid.. in the last few t... (0 repl.)
loading .xls into oracle table

hi all

is it possible to use sql loader to load data into a database table

or i have to change... (2 repl.)
service handle not initialized /end-of-file on communication channel

hi all,

i found error while i am going to export backup of database as below
first time i got th... (2 repl.)
MV Performance tuning

Hi All,
I have an environment where by using oracle 9i MV to replicate data from the 4 production... (1 repl.)
GETTING ALERT IN OEM AS

Hi
We are getting an alert from Oracle 10g OEM stating
"2 SEGMENTS IN AV49H1TS TABLESPACE UNABLE... (1 repl.)
RECO Process

I understand that RECO process is useful as it
"Recovers failed transactions that are distributed ... (6 repl.)
dbca

Dear i m trying to create new db with DBCA bt while i fired the DBCA. i faced the following prob.
/... (1 repl.)
--> Start a new thread ...
Headlines
May, 11 Oracle SQL Developer 1.5 released
May, 04 10.2.0.4 now available for Solaris Sparc 64-bit
Mar, 28 Oracle Clusterware free to use for Unbreakable Linux support customers
Mar, 18 Database patch set 10.2.0.4 available for linux x86_64 and windows 32-bit
Mar, 03 Database patch set 10.2.0.4 out for linux x86
Nov, 12 Oracle Unveils Oracle VM

More ...
Imho
How do you test your backups?
We have a lot of databases so we can not test the restore of the backu...
Restore in test server once in three months
I'm using daily export of the schema's, and when something happend, an...
Presently we just control the log files generated by the calling scri...
I am Using Export / Import, Export - Daily Import - Weekly on test ...
we make sure that the backup is valid in the first place. and for a re...
once in three months we restore and the backups to a test server and r...

More...