43. 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? 44. Explain the concept of the DUAL table.
45. What are the ways tablespaces can be managed and how do they differ?
46. From the database level, how can you tell under which time zone a database is operating?
47. What’s the benefit of "dbms_stats" over "analyze"?
48. Typically, where is the conventional directory structure chosen for Oracle binaries to reside? 49. You have found corruption in a tablespace that contains static tables that are part of a database that is in NOARCHIVE log mode.
How would you restore the tablespace without losing new data in the other tablespaces?
50. How do you recover a datafile that has not been physically been backed up since its creation and has been deleted. Provide syntax example. |