Hello Experts Exchange I want to be able to select each work day date for this month. So for this month I would get from my select statement all the dates apart from the weekend dates. Work Day --------------- 03/08/2015 04/08/2015 05/08/2015 06/08/2015 07/08/2015 10/08/2015 11/08/2015 12/08/2015 13/08/2015 14/08/2015 17/08/2015 18/08/2015 19/08/2015 20/08/2015 21/08/2015 24/08/2015 25/08/2015 26/08/2015 27/08/2015 28/08/2015 31/08/2015 Regards SQLSearcher Normally connect by is used to create parent-child relationships in a hierarchical query.In this case though it's being used a simple counter.
This section describes the basic outline of complete database recovery, which is intended to encompass a wide range of different scenarios.
Although RMAN simplifies most database restore and recovery tasks, you must still plan your database restore and recovery strategy based on which database files have been lost and your recovery goal.
This section contains the following topics: It is usually obvious when the control file of your database is lost.
Backups that were encrypted using transparent encryption with an auto-login keystore require no intervention to restore, if the keystore is available.
For backups encrypted with a password-based software keystore, in addition to requiring the keystore to be available, the keystore password to be provided.
RMAN also gives you the flexibility of restoring all archive redo log files, the current ones, or archive redo log files from a specified previous incarnation of the database.