I have kept recovery catalog on same target database and taken backup of target DB to disk. deleted the target DB & tried to restore and revoer DB using the backup on disk but it is not possible, how do we restore & recover DB
1516if monday take full backup and tuesday it was cumulative backup and wednesday we taken incremental backup, thursday some disaster happen then what type of recovery and how it will take?
1 3346when we login sql editor using username and password then it says this error "could not resolve service name" then what can we do at client side.( here thing is tnsnames.ora file is ok till yesterday and worked well, but now it giving error.
1227How do you find out from the RMAN catalog if a particular archive log has been backed-up?
IBM,
2 10129How can you tell how much space is left on a given file system and how much space each of the file system's subdirectories take-up?
2023Define the SGA and: How you would configure SGA for a mid-sized OLTP environment? What is involved in tuning the SGA?
3298What is the cache hit ratio, what impact does it have on performance of an Oracle database and what is involved in tuning it?
1964Other than making use of the statspack utility, what would you check when you are monitoring or running a health check on an Oracle 8i or 9i database?
1547You have 4 instances running on the same UNIX box. How can you determine which shared memory and semaphores are associated with which instance?
3931Post New DB Administration Questions
Which dictionary view(s) would you first look at to understand or get a high-level idea of a given Advanced Replication environment?
What the different types of replication and why are they used? : sql server DBA
How do you troubleshoot errors in a sql server agent job? : sql server DBA
What is transparent data encryption? : sql server DBA
What happens on checkpoint? : sql server DBA
Does any body has ORACLE Certification Dumps or Materials on 9i DBA, 10G DBA, Internet Application Developer, OCP 8i to 10g DBA Upgrade, Oracle 11i if any body have it, please kindly drop an email to: taruni_2k8@yahoo.com
currently iam working in mnc as a oracleappsdba,please send the EXPERIENCE RESUME those who r worked as a oracle apps dba
how do we explain a project in cognos in an interview? please help me. Also how do we perform testing in cognos after creating reports?
what is a crs resource?
What types of replication are supported in sql server? : sql server DBA
how can you initialize log miner?
What are the recovery models for a database? : sql server DBA
what do you understand by flashback feature of oracle?
Where do you find the default index fill factor and how to change it? : sql server DBA
How can you control the amount of free space in your index pages? : sql server DBA