Oracle-L: RE: RMAN restores

From: Ball, Terry <TBall_at_birch.com>
Date: Mon, 25 Mar 2002 10:40:33 -0800
Message-ID: <F001.0043251D.20020325104033@fatcity.com>

Here are the errors I am seeing.

  RMAN-03002: failure during compilation of command
  RMAN-03013: command type: restore
  RMAN-03002: failure during compilation of command
  RMAN-03013: command type: IRESTORE
  RMAN-06026: some targets not found - aborting restore
  RMAN-06102: no channel to restore a backup or copy of log thread 1 seq 27

scn 34
923
....

This lists all the logs EXCEPT the most recent. No logs are found in the archive log directory and the database does not recover thru RMAN. I can not recover the database manually, because the archive logs can not be found. (The backup script removes the archive logs after they have been (hopefully) backed up.

-----Original Message-----
Sent: Monday, March 25, 2002 12:36 PM
To: 'ORACLE-L_at_fatcity.com'
Cc: 'TBall_at_birch.com'

Terry,

When you say that Rman does not restore the archive log files, what exactly are you expecting?

Maybe Rman does not need to restore any archive logs, depending on what point-in-time you are restoring to. It could just restore the db files, and use the current redo logs to catch them up?

Below is a point-in-time restore script that I have used - the syntax has not changed much since 816.

run {

allocate channel t1 type 'SBT_TAPE' parms 'BLKSIZE=2097152';

set until time "to_date('2001-06-22:13:25:00','yyyy-mm-dd:hh24:mi:ss')";

restore (database);

recover database;

release channel t1;
sql 'alter database open resetlogs';

}

reset database;

Hope this helps.

Tom Mercadante
Oracle Certified Professional

-----Original Message-----
Sent: Monday, March 25, 2002 1:13 PM
To: Multiple recipients of list ORACLE-L

Oracle 8.1.7.0.0 on Solaris 2.8 with NetBackup 3.4

We are trying to use the same RMAN scripts that worked for us in 8.0.5 and 8.1.6. We can do full - incrememtal 0 - backup and restore. We can also do an incremental 1 backup, but when we try to do the restore, it does not restore the archive logs. The lists does show the correct archive logs, so I'm reasonabley certain that the logs are getting backed up, but they do NOT restore. I am working with Oracle on this, but because it is just testing at this point, WWW is not in any hurry to get back to me.

Does any one have any scripts they use for 8.1.7 that work for them? I'd like to do a comparison and see if there is something we are missing.

TIA Terry

Terry Ball, DBA
Birch Telecom
Work: 816-300-1335
FAX: 816-300-1801
--

Please see the official ORACLE-L FAQ: http://www.orafaq.com
--

Author: Ball, Terry
INET: TBall_at_birch.com

Fat City Network Services    -- (858) 538-5051  FAX: (858) 538-5051
San Diego, California        -- Public Internet access / Mailing Lists
--------------------------------------------------------------------

To REMOVE yourself from this mailing list, send an E-Mail message to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
--

Please see the official ORACLE-L FAQ: http://www.orafaq.com
--

Author: Ball, Terry
INET: TBall_at_birch.com

Fat City Network Services    -- (858) 538-5051  FAX: (858) 538-5051
San Diego, California        -- Public Internet access / Mailing Lists
--------------------------------------------------------------------