Database crashes. Corruption is found scattered among the
file system neither of your doing nor of Oracle's. What
database recovery options are available? Database is in
archive log mode.
No Answer is Posted For this Question
Be the First to Post Answer
Should you place Recovery Catalog in the Same DB? . Can you use RMAN without Recovery catalog
How would you best determine why your MVIEW couldn't FAST REFRESH?
Give the two types of tables involved in producing a star schema and the type of data theyhold.
. I have my backup RMAN script called "backup_rman.sh". I am on the target database. My catalog username/password is rman/rman. My catalog db is called rman. How would you run this shell script from the o/s such that it would run as a background process?
What is the cache hit ratio, what impact does it have on performance of an Oracle database and what is involved in tuning it?
What is the difference between online backup & offline backup?
You have 4 instances running on the same UNIX box. How can you determine which shared memory and semaphores are associated with which instance?
how to restore files with rman?
Which types of backups you can take in Oracle? 2. A database is running in NOARCHIVELOG mode then which type of backups you can take? 3. Can you take partial backups if the Database is running in NOARCHIVELOG mode?
From the database level, how can you tell under which time zone a database is operating?
How would you go about increasing the buffer cache hit ratio?
What is replication? : sql server DBA
Oracle (3253)
SQL Server (4518)
MS Access (429)
MySQL (1402)
Postgre (483)
Sybase (267)
DB Architecture (141)
DB Administration (291)
DB Development (113)
SQL PLSQL (3330)
MongoDB (502)
IBM Informix (50)
Neo4j (82)
InfluxDB (0)
Apache CouchDB (44)
Firebird (5)
Database Management (1411)
Databases AllOther (288)