Explanation: While performing point-in-time recovery of the database, you must specify time in the format YYYY-MM-DD:HH24:MI:SS. For example, if recovery needs to be performed until January 31, 2003 at 10:41 a.m., you must execute the following command:
SQL> RECOVER DATABASE USING BACKUP CONTROL FILE UNTIL TIME ‘2003-01- 31:10:41:00’;
Reference:
Oracle 9i Net Services Administrator’s Guide
Oracle 9i Net Services Reference Guide
Oracle 9i Recovery Manager Reference
Oracle 9i Backup and Recovery Concepts