- 17.9K All Categories
- 3.3K Industry Applications
- 3.3K Intelligent Advisor
- 60 Insurance
- 534.8K On-Premises Infrastructure
- 137.8K Analytics Software
- 38.6K Application Development Software
- 5.4K Cloud Platform
- 109.2K Database Software
- 17.5K Enterprise Manager
- 8.8K Hardware
- 70.9K Infrastructure Software
- 105.1K Integration
- 41.5K Security Software
How to specify recovery timestamp where DB in another timezone
I have a DB that is being recovered. The box it is being recovered on is in timezone GMT+8 Australia West).
It is a recovery of a database created in GMT+10 (actually Australia EST, so has daylight savings)
The source and recovery DB both have DBTIMEZONE = 10.
I need to recover the DB to 01-nov-2018 23:55 - as specified in the source DB
If I run this, will it recover to 23:55 in GMT+10 or GMT+8 (which would be 01:55 on Nov 2nd)?
set until time "to_date('01 nov 2018 23:55:00','dd mon yyyy hh24:mi:ss')";
If I run this before invoking rman, will that sort it out?