Standby Archivelogs
DBAsupport.com Forums - Powered by vBulletin
Results 1 to 4 of 4

Thread: Standby Archivelogs

  1. #1
    Join Date
    Sep 2000
    Posts
    384

    Standby Archivelogs

    On the Production server I have backed up the archivelogs using rman and deleted them .I am maintaining a Standby on a Diffrent server .It so happened that the last 5 archivelogs were not transferred to the standby site .How do I restore the archivelogs in the standby site without disturbing the production server .

    Any short cuts ???
    Radhakrishnan.M

  2. #2
    Join Date
    Feb 2000
    Location
    Washington DC
    Posts
    1,843
    No short cut method other than taking hotbackup of PRODUCTION again and build standby fresh, if you have already lost those 5 archive logs.
    Reddy,Sam

  3. #3
    Join Date
    Sep 2000
    Posts
    384
    RMAN> run { allocate channel t1 type disk ;
    2> restore archivelog low logseq 72421 high logseq 72442 ;}
    RMAN-03022: compiling command: allocate
    RMAN-03023: executing command: allocate
    RMAN-08030: allocated channel: t1
    RMAN-08500: channel t1: sid=10 devtype=DISK

    RMAN-03022: compiling command: restore

    RMAN-03022: compiling command: IRESTORE
    RMAN-03023: executing command: IRESTORE
    RMAN-08017: channel t1: starting archivelog restore to default destination
    RMAN-08022: channel t1: restoring archivelog
    RMAN-08510: archivelog thread=1 sequence=72421
    RMAN-08022: channel t1: restoring archivelog
    RMAN-08510: archivelog thread=1 sequence=72422
    RMAN-08022: channel t1: restoring archivelog
    RMAN-08510: archivelog thread=1 sequence=72423
    RMAN-08022: channel t1: restoring archivelog
    RMAN-08510: archivelog thread=1 sequence=72424
    RMAN-08022: channel t1: restoring archivelog
    RMAN-08510: archivelog thread=1 sequence=72425
    RMAN-08022: channel t1: restoring archivelog
    RMAN-08510: archivelog thread=1 sequence=72426
    RMAN-08022: channel t1: restoring archivelog

    Hope Reddy this helps
    Radhakrishnan.M

  4. #4
    Join Date
    Feb 2000
    Location
    Washington DC
    Posts
    1,843

    Re: Standby Archivelogs

    Originally posted by omegamark
    On the Production server I have backed up the archivelogs using rman and deleted them .I am maintaining a Standby on a Diffrent server .It so happened that the last 5 archivelogs were not transferred to the standby site .How do I restore the archivelogs in the standby site without disturbing the production server .

    Any short cuts ???
    You said you deleted those logs, I thought you do not have those logs anymore. I didn't know that you have backup, if you do, you can apply them.
    Reddy,Sam

Posting Permissions

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


Click Here to Expand Forum to Full Width