ADSM-L

[ADSM-L] TSM restore of Oracle via TDP and RMAN

2009-07-28 15:43:07
Subject: [ADSM-L] TSM restore of Oracle via TDP and RMAN
From: Tim Brown <tbrown AT CENHUD DOT COM>
To: ADSM-L AT VM.MARIST DOT EDU
Date: Tue, 28 Jul 2009 15:41:39 -0400
I was wondering if anyone has any insight to my issue.

I'm doing a restore/recover for a windows 2003 server (oracle db 10g).
We do incremental backups with a full backup every Friday.

This is the script i've tried for the restore (among the other tries):
run
{
    #if not already done, do a shutdown.  I was doing shutdown at the RMAN 
prompt.
    #shutdown immediate;
    startup nomount;

    #--restore the controlfile
    restore controlfile from autobackup;

    ##mount the database using the restored control file.
    alter database mount;

    allocate channel t1 type 'sbt_tape' parms 'ENV=(tdpo_optfile=C:\Program 
Files\Tivoli\TSM\AgentOBA\tdpo.opt)';


    ##SCN=system change number (it's like a counter)
    ##when using the 'until' command, it should restore 'up to but not 
including'
    ##restore database;
    ##restore database until scn 9699232120;
    ##restore database until sequence=277 thread=1 force;
    restore database until sequence=291 thread=1 force;

    ##do a list backup of archivelog from time = 'sysdate-7'; to find sequence 
#.
    ##-do a list recoverable backup of database; to get the most recent scn #.
    ##recover database until sequence=291;
    ##recover database until scn 9699232120;
    ##recover database until sequence=277 thread=1;
    recover database until sequence=291 thread=1;

    alter database open resetlogs;
    release channel t1;

   }

The restore seems to work fine, but no matter how I do the restore, I always 
get this error on the recover:

channel t1: reading from backup piece df_688689807_164_1
channel t1: restored backup piece 1
piece handle=df_688689807_164_1 tag=TAG20090604T224327
channel t1: restore complete, elapsed time: 00:02:25

starting media recovery

unable to find archive log
archive log thread=1 sequence=1
released channel: t1
RMAN-00571: ===========================================================
RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
RMAN-00571: ===========================================================
RMAN-03002: failure of recover command at 06/16/2009 15:23:38
RMAN-06054: media recovery requesting unknown log: thread 1 seq 1 lowscn 9698800
261

Recovery Manager complete.

I have to manually open the database and it does open and all the .dbf, .log, 
and .ctl files are restored and we can log onto the database fine and use it, 
but I always get this error about unable to find archive log.  Any thoughts or 
suggestions??
thanks.

Tim Brown
Systems Specialist - Project Leader
Central Hudson Gas & Electric
284 South Ave
Poughkeepsie, NY 12601
Email: tbrown AT cenhud DOT com <mailto:tbrown AT cenhud DOT com>
Phone: 845-486-5643
Fax: 845-486-5921
Cell: 845-235-4255


This message contains confidential information and is only for the intended 
recipient.  If the reader of this message is not the intended recipient, or an 
employee or agent responsible for delivering this message to the intended 
recipient, please notify the sender immediately by replying to this note and 
deleting all copies and attachments.  Thank you.

<Prev in Thread] Current Thread [Next in Thread>