Smart questions
Smart answers
Smart people
INTELLIGENT WORK FORUMS
FOR COMPUTER PROFESSIONALS

Member Login




Remember Me
Forgot Password?
Join Us!

Come Join Us!

Are you a
Computer / IT professional?
Join Tek-Tips now!
  • Talk With Other Members
  • Be Notified Of Responses
    To Your Posts
  • Keyword Search
  • One-Click Access To Your
    Favorite Forums
  • Automated Signatures
    On Your Posts
  • Best Of All, It's Free!

Join Tek-Tips
*Tek-Tips's functionality depends on members receiving e-mail. By joining you are opting in to receive e-mail.

Posting Guidelines

Promoting, selling, recruiting, coursework and thesis posting is forbidden.
Jobs from Indeed

Link To This Forum!

Partner Button
Add Stickiness To Your Site By Linking To This Professionally Managed Technical Forum.
Just copy and paste the
code below into your site.

Oracle restore/recovery without RMAN catalog

hanzklotz (TechnicalUser) (OP)
9 Jan 11 12:34
Hi all,

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

Regards,
Marcin
davidmichel (TechnicalUser)
11 Jan 11 11:56
Without RMAN or without RMAN catalog?

It would also be helpful if details were provided such as versions, type of backup, etc.
hanzklotz (TechnicalUser) (OP)
12 Jan 11 12:50
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 :)

CODE

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 (TechnicalUser)
12 Jan 11 13:34
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 (TechnicalUser) (OP)
13 Jan 11 8:29
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 (TechnicalUser)
14 Jan 11 13:37
that sounds like a good idea.

Reply To This Thread

Posting in the Tek-Tips forums is a member-only feature.

Click Here to join Tek-Tips and talk with other members!

Close Box

Join Tek-Tips® Today!

Join your peers on the Internet's largest technical computer professional community.
It's easy to join and it's free.

Here's Why Members Love Tek-Tips Forums:

Register now while it's still free!

Already a member? Close this window and log in.

Join Us             Close