|
Explanation: Correct sequence of events to create a recovery catalog is: you first need to create table space to hold the catalog in the database, create a user and schema which will own the recovery catlog, grant the appropriate privileges and roles, create the catalog, connect to the target database, register the target database in the catalog. Incorrect Answer: 1: RESYNC CATALOG command can be used only AFTER catalog creation. 2: Before registering database you should create catalog. 3: The purpose of this command is to create a schema for the recovery catalog. Typically, you create this schema in a separate recovery catalog database. The catalog is created in the default table space of the recovery catalog owner if you not specify the table space name. Reference: OCP Oracle 9i Database: Fundamentals II Exam Guide, Rama Velpuri, p. 397-398 Chapter 17: Recovery Catalog Creation and Maintenance
|