Oracle restore/recovery without RMAN catalog

[hanzklotz]

Hi all,

Is it possible (using ArcServe) to restore and recover oracle database to specified point in time without RMAN catalog?

Regards,
Marcin

 

[davidmichel]

Without RMAN or without RMAN catalog?

It would also be helpful if details were provided such as versions, type of backup, etc.

 

[hanzklotz]

System Details:

ARCserve Backup R12.0 SP1 on Windows Server 2003
Oracle Database Server 11.0 on Red Hat Enterprise Linux
ARCserve Agent for Oracle on Linux

Backup rotation: 5 days, Full on Mon, Wed, Fri, Incremental on Tue, Thu

Agent config in ArcServe:
backup method Full + archive logs
use RMAN Catalog - UNCHECKED

RECOVERY & RESTORE Oracle Databases

Restoring the database from last backup (restore) runs without errors (used tape: last Full backup)
Recover the database:
For the most recent state - without errors
For a specified point in time - errors (log below) .

I think that RMAN needs additional files to recover the database and these files are not on the tape from the last backup.

During restore, regardless of the selected options (recover to specific point in time,recover from a backup made on ...) ArcServe always is trying to use the last recorded tape (last backup)
For example,
On Friday, I'm trying to restore a database state from Wednesday. ARCserve using Friday tape with most recent backup instead of Wednesday tape.

Why?

Agent log file (rman logs were in polish language, my translation - hope good

Oracle Agent for BrightStor ARCserve Backup for Linux r11.5 SP3 (Build 2427)

11/07 17:39:11(19932) - Server Type[11]

11/07 17:39:11(19932) - A job has been received from BrightStor ARCserve Backup running on host ARC_SERVE

11/07 17:39:18(19932) - getCurrentOracleVersion - return status = 0

11/07 17:39:18(19932) - getCurrentOracleVersion - return status = 0

11/07 17:39:27(19932) - getCurrentOracleVersion - return status = 0

11/07 17:39:27(19932) - Database has not been identified as part of a RAC= -134667932

11/07 17:39:27(19932) - isInstanceInRac - Assuming that the database is not part of a RAC

11/07 17:39:27(19932) - RMAN restore script /opt/CA/BABoraagt/rman_scripts/HYPDB_ARC_SERVE_6.rman has been generated

11/07 17:39:27(19932) - Executing RMAN script /opt/CA/BABoraagt/rman_scripts/HYPDB_ARC_SERVE_6.rman

11/07 17:43:43(19932) - AE360144 Failed to execute the RMAN command /opt/oracle/111/bin/rman msglog '/tmp/rman_6.log' nocatalog

11/07 17:43:43(19932) - AX-RMAN ===========

11/07 17:43:43(19932) - AX-RMAN RMAN OUTPUT

11/07 17:43:43(19932) - AX-RMAN ===========

11/07 17:43:43(19932) - AX-RMAN

11/07 17:43:43(19932) - AX-RMAN Recovery Manager: Release 11.1.0.6.0 - Production on N Lis 7 17:39:35 2010

11/07 17:43:43(19932) - AX-RMAN

11/07 17:43:43(19932) - AX-RMAN Copyright (c) 1982, 2007, Oracle.  All rights reserved.

11/07 17:43:43(19932) - AX-RMAN

11/07 17:43:43(19932) - AX-RMAN RMAN>

11/07 17:43:43(19932) - AX-RMAN connected to target database: HYPDB (DBID = 233203257, unopened)

11/07 17:43:43(19932) - AX-RMAN using the control file instead of the recovery catalog

11/07 17:43:43(19932) - AX-RMAN

11/07 17:43:43(19932) - AX-RMAN RMAN>

11/07 17:43:43(19932) - AX-RMAN RMAN> # THIS RESTORE SCRIPT WAS GENERATED BY /opt/CA/BABoraagt/oragentd

11/07 17:43:43(19932) - AX-RMAN 2> # FOR DATABASE HYPDB

11/07 17:43:43(19932) - AX-RMAN 3>

11/07 17:43:43(19932) - AX-RMAN 4> run {

11/07 17:43:43(19932) - AX-RMAN 5> allocate channel dev1_1 type 'sbt_tape'

11/07 17:43:43(19932) - AX-RMAN 6> parms='SBT_LIBRARY=/opt/CA/BABoraagt/libobk64.so,ENV=(PARENT_JOBID=6,SBT_PARMS=172.20.30.11;<NULL>;<NULL>;<NULL>;<NULL>;SU

MMARY;FALSE;FALSE;<NULL>;<NULL>;FALSE;0;0;5;60)';

11/07 17:43:43(19932) - AX-RMAN 7> restore tablespace 'ORA_WORKIXTABLESPACE',

11/07 17:43:43(19932) - AX-RMAN 8> 'ORA_WORKTABLESPACE',

11/07 17:43:43(19932) - AX-RMAN 9> 'SYSAUX',

11/07 17:43:43(19932) - AX-RMAN 10> 'SYSTEM',

11/07 17:43:43(19932) - AX-RMAN 11> 'UNDOTBS1',

11/07 17:43:43(19932) - AX-RMAN 12> 'USERS',

11/07 17:43:43(19932) - AX-RMAN 13> 'HYPERION' until time = "to_date ('05/11/2010:20:00:00', 'dd/mm/yyyy:hh24:mi:ss')";

11/07 17:43:43(19932) - AX-RMAN 14> sql 'alter database open';

11/07 17:43:43(19932) - AX-RMAN 15> release channel dev1_1;

11/07 17:43:43(19932) - AX-RMAN 16> }

11/07 17:43:43(19932) - AX-RMAN assigned chanel: dev1_1

11/07 17:43:43(19932) - AX-RMAN chanel dev1_1: SID=319 device type=SBT_TAPE

11/07 17:43:43(19932) - AX-RMAN chanel dev1_1: BrightStor ARCserve Backup Oracle Agent v11.5

11/07 17:43:43(19932) - AX-RMAN

11/07 17:43:43(19932) - AX-RMAN Start restore at 11/07/2010/17:39:36

11/07 17:43:43(19932) - AX-RMAN

11/07 17:43:43(19932) - AX-RMAN kana? dev1_1: starting restore a set of backup data files

11/07 17:43:43(19932) - AX-RMAN kana? dev1_1: determining data files to recover form backup

11/07 17:43:43(19932) - AX-RMAN kana? dev1_1: recovering data file 00006 do /u00/oradata/HYPDB/ora_WorkX.dbf

11/07 17:43:43(19932) - AX-RMAN kana? dev1_1: recovering data file 00005 do /u00/oradata/HYPDB/ora_WorkD.dbf

11/07 17:43:43(19932) - AX-RMAN kana? dev1_1: recovering data file 00002 do /u00/oradata/HYPDB/sysaux01.dbf

11/07 17:43:43(19932) - AX-RMAN kana? dev1_1: recovering data file 00001 do /u00/oradata/HYPDB/system01.dbf

11/07 17:43:43(19932) - AX-RMAN kana? dev1_1: recovering data file 00003 do /u00/oradata/HYPDB/undotbs01.dbf

11/07 17:43:43(19932) - AX-RMAN kana? dev1_1: recovering data file 00004 do /u00/oradata/HYPDB/users01.dbf

11/07 17:43:43(19932) - AX-RMAN kana? dev1_1: recovering data file 00007 do /u00/oradata/HYPDB/hyperion.dbf

11/07 17:43:43(19932) - AX-RMAN kana? dev1_1: reading from a part of backup 7rls3tbu_1_1

11/07 17:43:43(19932) - AX-RMAN kana? dev1_1: handle = 7rls3tbu_1_1, tag = TAG20101103T212622

11/07 17:43:43(19932) - AX-RMAN kana? dev1_1: recovering part 1 from backup 

11/07 17:43:43(19932) - AX-RMAN kana? dev1_1: end of recovery, elapsed time: 00:04:05

11/07 17:43:43(19932) - AX-RMAN End of restore at 11/07/2010/17:43:43

11/07 17:43:43(19932) - AX-RMAN

11/07 17:43:43(19932) - AX-RMAN sql instruction: alter database open

11/07 17:43:43(19932) - AX-RMAN release chanel: dev1_1

11/07 17:43:43(19932) - AX-RMAN RMAN-00571: ===========================================================

11/07 17:43:43(19932) - AX-RMAN RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============

11/07 17:43:43(19932) - AX-RMAN RMAN-00571: ===========================================================

11/07 17:43:43(19932) - AX-RMAN RMAN-03009: failure of sql command on default channel 11/07/2010 17:43:43

11/07 17:43:43(19932) - AX-RMAN RMAN-11003: failure during parse / execute SQL statement: alter database open

11/07 17:43:43(19932) - AX-RMAN ORA-01113: a file 1 requires recovery media

11/07 17:43:43(19932) - AX-RMAN ORA-01110: data file 1: '/u00/oradata/HYPDB/system01.dbf'

11/07 17:43:43(19932) - AX-RMAN

11/07 17:43:43(19932) - AX-RMAN RMAN> **end of file**

11/07 17:43:43(19932) - AX-RMAN

11/07 17:43:43(19932) - AX-RMAN RMAN>

11/07 17:43:43(19932) - AX-RMAN

11/07 17:43:43(19932) - AX-RMAN Recovery Manager - end.

11/07 17:43:43(19932) - ERROR: Cannot restore the Oracle objects. return [-1]

11/07 17:43:43(19932) - AE360112 The Restore of DB Object [HYPDB] failed

11/07 17:43:43(19932) - AW360078 Please refer to the Backup Agent log file

Sorry for mistakes, please help

Marcin

 

[davidmichel]

I don't know.

Best I can say is to install SP2 for ARCserver and if there is still a problem get with CA Support.

Here is the link to the 12.0 updates page.

https://support.ca.com/irj/portal/anonymous/phpdocs?filePath=0/4536/12/4536_12-patchindex.html

 

[hanzklotz]

Thanks, for your replay. I try to fix this problem since 2 months and can'n find a solution.

I had some problems while configuring backup with RMAN catalog so maybe I should try to fix this problem first and then try to resolve recovery errors.

...

 

[davidmichel]

that sounds like a good idea.