Results 1 to 3 of 3
  1. #1
    Join Date
    Jul 2003
    Posts
    2,296

    Unanswered: Rman backup from different server

    Okay here is the scenario.
    On server1 I start RMAN and connect to my target database, Server2.

    on Server1 at 2:15 I issue: backup database plus archivelog;
    Backup was successful.

    NEXT on Server2 the time is not exactly the same and I issue drop table tablename at 2:14

    NOW, is the backup time based on the Server1 time or the Server2 time?

    If I issue a Time-based backup, do I issue everything according the the time on Server1 that I issued the backup command or the time that Server2 had when the backup was made?

    You get my meaning?
    - The_Duck
    you can lead someone to something but they will never learn anything ...

  2. #2
    Join Date
    Jan 2004
    Posts
    370
    Duck,

    If I understand correctly, you are asking what time to base your point in time recovery on the machine where RMAN was invoked, or the target database?

    The recovery is always going to be based on the contents of the backup set and (archive) logfiles of the target database, so whatever time you specify will relate to the target database, not the RMAN host.


    I guess if the time difference was greater then things might be clearer - like if the RMAN host was in a different timezone rather than just being a few seconds out.

  3. #3
    Join Date
    Jul 2003
    Posts
    2,296
    Thanks for the reply.
    We have most/all our servers pointing to the same time-server.
    Was just curious about a few things.

    Thanks.
    - The_Duck
    you can lead someone to something but they will never learn anything ...

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •