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

Thread: Question abt Backup

  1. #1
    Join Date
    Jan 2004
    Location
    Bangalore, India
    Posts
    66

    Question abt Backup

    All,
    Somebody had deleted all archivelogs in our database.
    However, a cold backup was taken after this, using RMAN.

    But, whenever we try to do hot backup and instruct RMAN to backup database plus archivelog, we get the "unable to locate file ... " error and the backup script terminates.

    How to overcome this problem and start afresh?
    Pls advice.
    Thanks in advance.

  2. #2
    Join Date
    Sep 2002
    Location
    England
    Posts
    7,334
    what does crosscheck archivelog all; do for you.

    Also you dont mention version

  3. #3
    Join Date
    Jan 2004
    Location
    Bangalore, India
    Posts
    66
    Oracle 10g (10.1.0.3.0) on Linux ES 3
    Crosscheck give sthe following:
    validation failed for archived log
    archive log filename=/orasystem/sfw/arch/1_515_546189296.arc recid=835 stamp=549640701

    Any inputs to resolve this problem will be highly appreciated...

  4. #4
    Join Date
    Sep 2002
    Location
    England
    Posts
    7,334
    once you have done the crosscheck they will be set to expired

    delete expired archivelog all;

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