You can use any dump utility to obtain a dump of the database. When the dump is complete, you, as the administrator, must determine the desired dump point based on information obtained from the primary database when the dump was taken. The dump utility may provide the dump point. The scenarios in later sections use the Oracle RMAN utility.
To obtain the dump point from one RMAN backup set, use the list backup Oracle command. This is an example of the output from list backup:
List of Backup Sets =================== BSKey Type LV Size Device Type Elapsed Time Completion Time
------- ---- -- ---------- ----------- ------------ --------------- 1 Full 1.13G DISK 00:02:26 19-MAY-09 BP Key: 1 Status: AVAILABLE Compressed: NO Tag: TAG20090519T102428 Piece Name: D:\ORACLE11G\PRODUCT\11.1.0\DB_1\DATABASE\01KFDJAS_1_1 List of Datafiles in backup set 1 File LV Type Ckp SCN Ckp Time Name ---- -- ---- ---------- --------- ---- 1 Full 1721510 19-MAY-09 D:\ORACLE11G\ORADATA\ORAPDB11G\SYSTEM01.DBF 2 Full 1721510 19-MAY-09 D:\ORACLE11G\ORADATA\ORAPDB11G\SYSAUX01.DBF 3 Full 1721510 19-MAY-09 D:\ORACLE11G\ORADATA\ORAPDB11G\UNDOTBS01.DBF 4 Full 1721510 19-MAY-09 D:\ORACLE11G\ORADATA\ORAPDB11G\USERS01.DBF
The value of “Ckp SCN”, 1721510, is the required dump point.
See Oracle documentation for more information on the RMAN utility and the list backup command.