Forum Stats

  • 3,876,115 Users
  • 2,267,061 Discussions
  • 7,912,434 Comments

Discussions

rman duplicate from active database with "until" clause

SPA09
SPA09 Member Posts: 867 Gold Badge
edited Jan 11, 2016 5:45PM in Database Ideas - Ideas

Hi all,

we often setup new standby databases or made copies for new development databases.

Here we use the rman duplicate command.

In a lot of situations we have the requirement to do the setup for a special point in time for example until 9:00 a.m.

But the "until" clause can't be used for active database. So we always have to do a backup on disk for example and then start the duplicate.

To do a duplicate without the backup on disk would save a lot of space and time and administration around these jobs.

If it would also work with pluggable database it will be excellent.

kind regards

User259623 -OracleSPA09vinaykumar2Manish ChaturvedictriebFranck Pachot
14 votes

Active · Last Updated

Comments

  • top.gun
    top.gun Member Posts: 3,666 Gold Crown

    It can't work because an active duplicate is as the target database (eg production) is now.

    Specifying a time in the past just won't work.

    You need to duplicate from a past backup to get consistency from a time.

    Franck Pachot
  • SPA09
    SPA09 Member Posts: 867 Gold Badge

    It can't work because an active duplicate is as the target database (eg production) is now.

    Specifying a time in the past just won't work.

    You need to duplicate from a past backup to get consistency from a time.

    Hi,

    yes, of course you are right.

    But the future could bring some new features in this directon. (I hope so.)

    regards

  • Franck Pachot
    Franck Pachot Member Posts: 912 Bronze Trophy

    Hi,

    yes, of course you are right.

    But the future could bring some new features in this directon. (I hope so.)

    regards

    How do you think it can be implemented? Using flashback on and shipping flashback logs with the datafiles?

    berx