REWINDING A DATABASE USING ORACLE FLASHBACK DATABASE

THIS PUZZLE TEST TO REWINDING A DATABASE USING ORACLE FLASHBACK DATABASE

			1


2	3


					4
				5


		6

Across

2. (STEP 1) Connect RMAN to the target ________ .

6. (STEP 3) Shut down the database consistently , ensure that it is not opened by any instance , and then mount the database. CODING : SHUTDOWN ________ ; STARTUP MOUNT ;

Down

1. (STEP 2) Identify the desired SCN, restore point, or point in time to which the _______ database must be performed.

3. (STEP 4) Flash back the database to desired _______ . CODING : FLASHBACK DATABASE TO TIME "TO_DATE('03/20/2012','MM/DD/YY')" ;

4. (STEP 6) After confirming that the state of the database is as expected , make the database available for updates by opening it with the RESETLOGS option. CODING : SHUTDOWN IMMEDIATE ; ________ MOUNT ; ALTER DATABASE OPEN RESETLOGS ;

5. (STEP 5) Open the database read-only and run some queries to verify thr database contents. CODING : ALTER DATABASE OPEN _______ ONLY;

Use the "Printable HTML" button to get a clean page, in either HTML or PDF, that you can use your browser's print button to print. This page won't have buttons or ads, just your puzzle. The PDF format allows the web site to know how large a printer page is, and the fonts are scaled to fill the page. The PDF takes awhile to generate. Don't panic!