- 17.9K All Categories
- 3.4K Industry Applications
- 3.4K Intelligent Advisor
- 73 Insurance
- 537.3K On-Premises Infrastructure
- 138.6K Analytics Software
- 38.6K Application Development Software
- 6K Cloud Platform
- 109.6K Database Software
- 17.6K Enterprise Manager
- 8.8K Hardware
- 71.2K Infrastructure Software
- 105.3K Integration
- 41.6K 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?