Welcome! » Log In » Create A New Profile

Oracle DataBase Restore/Recovery problem

Posted by HanzKlotz 
Oracle DataBase Restore/Recovery problem
November 08, 2010 04:55AM
Hi all,

I have a problem with restoring oracle database.
Backup is done without errors. I can restore the database, I can also recover it to its present state, but I can not recover to a specific point in time. I don't use the RMAN catalog. Below is a log of the oracle agent.

[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 Menedżer przywracania: 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 połšczono z docelowš bazš danych: HYPDB (DBID=233203257, nieotwarta)

11/07 17:43:43(19932) - AX-RMAN używanie pliku sterujšcego docelowej bazy danych zamiast katalogu przywracania

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&#40;19932&#41; - AX-RMAN 6> parms='SBT_LIBRARY=/opt/CA/BABoraagt/libobk64.so,ENV=&#40;PARENT_JOBID=6,SBT_PARMS=172.20.30.11;<NULL>;<NULL>;<NULL>;<NULL>;SU

MMARY;FALSE;FALSE;<NULL>;<NULL>;FALSE;0;0;5;60&#41;';

11/07 17:43:43&#40;19932&#41; - AX-RMAN 7> restore tablespace 'ORA_WORKIXTABLESPACE',

11/07 17:43:43&#40;19932&#41; - AX-RMAN 8> 'ORA_WORKTABLESPACE',

11/07 17:43:43&#40;19932&#41; - AX-RMAN 9> 'SYSAUX',

11/07 17:43:43&#40;19932&#41; - AX-RMAN 10> 'SYSTEM',

11/07 17:43:43&#40;19932&#41; - AX-RMAN 11> 'UNDOTBS1',

11/07 17:43:43&#40;19932&#41; - AX-RMAN 12> 'USERS',

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

11/07 17:43:43&#40;19932&#41; - AX-RMAN 14> sql 'alter database open';

11/07 17:43:43&#40;19932&#41; - AX-RMAN 15> release channel dev1_1;

11/07 17:43:43&#40;19932&#41; - AX-RMAN 16> &#125;

11/07 17:43:43&#40;19932&#41; - AX-RMAN przydzielono kana&#322;: dev1_1

11/07 17:43:43&#40;19932&#41; - AX-RMAN kana&#322; dev1_1: SID=319 typ urz&#154;dzenia=SBT_TAPE

11/07 17:43:43&#40;19932&#41; - AX-RMAN kana&#322; dev1_1: BrightStor ARCserve Backup Oracle Agent v11.5

11/07 17:43:43&#40;19932&#41; - AX-RMAN

11/07 17:43:43&#40;19932&#41; - AX-RMAN Rozpocz&#281;cie restore o 11/07/2010/17:39:36

11/07 17:43:43&#40;19932&#41; - AX-RMAN

11/07 17:43:43&#40;19932&#41; - AX-RMAN kana&#322; dev1_1: rozpocz&#281;cie odtwarzania z zestawu zapasowych kopii plików danych

11/07 17:43:43&#40;19932&#41; - AX-RMAN kana&#322; dev1_1: okrelanie plików danych do odtwarzania z kopii zapasowej

11/07 17:43:43&#40;19932&#41; - AX-RMAN kana&#322; dev1_1: odtwarzanie pliku danych 00006 do /u00/oradata/HYPDB/ora_WorkX.dbf

11/07 17:43:43&#40;19932&#41; - AX-RMAN kana&#322; dev1_1: odtwarzanie pliku danych 00005 do /u00/oradata/HYPDB/ora_WorkD.dbf

11/07 17:43:43&#40;19932&#41; - AX-RMAN kana&#322; dev1_1: odtwarzanie pliku danych 00002 do /u00/oradata/HYPDB/sysaux01.dbf

11/07 17:43:43&#40;19932&#41; - AX-RMAN kana&#322; dev1_1: odtwarzanie pliku danych 00001 do /u00/oradata/HYPDB/system01.dbf

11/07 17:43:43&#40;19932&#41; - AX-RMAN kana&#322; dev1_1: odtwarzanie pliku danych 00003 do /u00/oradata/HYPDB/undotbs01.dbf

11/07 17:43:43&#40;19932&#41; - AX-RMAN kana&#322; dev1_1: odtwarzanie pliku danych 00004 do /u00/oradata/HYPDB/users01.dbf

11/07 17:43:43&#40;19932&#41; - AX-RMAN kana&#322; dev1_1: odtwarzanie pliku danych 00007 do /u00/oradata/HYPDB/hyperion.dbf

11/07 17:43:43&#40;19932&#41; - AX-RMAN kana&#322; dev1_1: odczytywanie z fragmentu kopii zapasowej 7rls3tbu_1_1

11/07 17:43:43&#40;19932&#41; - AX-RMAN kana&#322; dev1_1: uchwyt fragmentu = 7rls3tbu_1_1, znacznik = TAG20101103T212622

11/07 17:43:43&#40;19932&#41; - AX-RMAN kana&#322; dev1_1: odtwarzanie fragmentu 1 z kopii zapasowej

11/07 17:43:43&#40;19932&#41; - AX-RMAN kana&#322; dev1_1: uko&#324;czono odtwarzanie, up&#322;yn&#281;&#322;o: 00:04:05

11/07 17:43:43&#40;19932&#41; - AX-RMAN Zako&#324;czono restore o 11/07/2010/17:43:43

11/07 17:43:43&#40;19932&#41; - AX-RMAN

11/07 17:43:43&#40;19932&#41; - AX-RMAN instrukcja sql: alter database open

11/07 17:43:43&#40;19932&#41; - AX-RMAN zwolniono kana&#322;: dev1_1

11/07 17:43:43&#40;19932&#41; - AX-RMAN RMAN-00571: ===========================================================

11/07 17:43:43&#40;19932&#41; - AX-RMAN RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============

11/07 17:43:43&#40;19932&#41; - AX-RMAN RMAN-00571: ===========================================================

11/07 17:43:43&#40;19932&#41; - AX-RMAN RMAN-03009: niepowodzenie polecenia sql dla kana&#322;u default w 11/07/2010 17:43:43

11/07 17:43:43&#40;19932&#41; - AX-RMAN RMAN-11003: niepowodzenie w trakcie analizy sk&#322;adniowej/wykonania instrukcji SQL: alter database open

11/07 17:43:43&#40;19932&#41; - AX-RMAN ORA-01113: plik 1 wymaga zastosowania przywracania noników

11/07 17:43:43&#40;19932&#41; - AX-RMAN ORA-01110: plik danych 1: '/u00/oradata/HYPDB/system01.dbf'

11/07 17:43:43&#40;19932&#41; - AX-RMAN

11/07 17:43:43&#40;19932&#41; - AX-RMAN RMAN> **koniec pliku**

11/07 17:43:43&#40;19932&#41; - AX-RMAN

11/07 17:43:43&#40;19932&#41; - AX-RMAN RMAN>

11/07 17:43:43&#40;19932&#41; - AX-RMAN

11/07 17:43:43&#40;19932&#41; - AX-RMAN Mened&#380;er przywracania - uko&#324;czono.

11/07 17:43:43&#40;19932&#41; - ERROR: Cannot restore the Oracle objects. return &#91;-1&#93;

11/07 17:43:43&#40;19932&#41; - AE360112 The Restore of DB Object &#91;HYPDB&#93; failed

11/07 17:43:43&#40;19932&#41; - AW360078 Please refer to the Backup Agent log file[/code]

Agent and database are installed on RedHat Enterprise.
I'm not an expert with ARCserve and oracle. Please advice.[/quote]
Oracle DataBase Restore/Recovery problem
November 08, 2010 10:11AM
Based off this log entry it appears, that the restore is only a single tablespace to a point in time:
'HYPERION' until time = "to_date ('05/11/2010:20:00:00', 'dd/mm/yyyy:hh24:mi:ss')";

More information on this process:
RMAN Tablespace Point-in-Time Recovery (TSPITR)
Recovery Manager (RMAN) automatic tablespace point-in-time recovery (commonly abbreviated TSPITR) enables you to quickly recover one or more tablespaces in an Oracle database to an earlier time, without affecting the state of the rest of the tablespaces and other objects in the database.
This chapter explains when you can and cannot use TSPITR, what RMAN actually does to your database during TSPITR, how to prepare a database for TSPITR, how to run TSPITR, and options for controlling the TSPITR process
(http://download.oracle.com/docs/cd/B14117_01/server.101/b10734/rcmtspit.htm_

two points to consider:
You cannot recover dropped tablespaces.
You cannot recover a renamed tablespace to a point in time before it was renamed. If you try to perform a TSPITR to an SCN earlier than the rename operation, RMAN cannot find the new tablespace name in the repository as of that earlier SCN (because the tablespace did not have that name at that SCN).
Sorry, only registered users may post in this forum.

Click here to login