Добро пожаловать в форум, Guest  >>   Войти | Регистрация | Поиск | Правила | В избранное | Подписаться
Все форумы / Oracle Новый топик    Ответить
 Oracle 9i. RMAN. How to restore standby controlfile using "from tag" clause?  [new]
ShaDmiF
Member

Откуда:
Сообщений: 302
-bash-3.00$ rman target / catalog rman/rman@emgc

Recovery Manager: Release 9.2.0.8.0 - 64bit Production

Copyright (c) 1995, 2002, Oracle Corporation.  All rights reserved.

connected to target database: crvs (not mounted)
connected to recovery catalog database

RMAN> list backup tag stby_ctrl;


List of Backup Sets
===================

BS Key  Type LV Size       Device Type Elapsed Time Completion Time
------- ---- -- ---------- ----------- ------------ ---------------
142851  Full    7M         SBT_TAPE    00:01:44     02.02.11       
        BP Key: 142852   Status: AVAILABLE   Tag: STBY_CTRL
        Piece Name: CRVS_20110202.c7m3kbrd_1_1.stb
  Controlfile Included: Ckp SCN: 67168490043   Ckp time: 02.02.11

RMAN> run
{
ALLOCATE CHANNEL ch1 DEVICE TYPE 'SBT_TAPE' PARMS 'SBT_LIBRARY=/oracle/apps/osb/lib/libobk.so';
RESTORE standby CONTROLFILE from tag  stby_ctrl;
release channel ch1;
}
2> 3> 4> 
RMAN-00571: ===========================================================
RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
RMAN-00571: ===========================================================
RMAN-00558: error encountered while parsing input commands
RMAN-01005: syntax error: found "from": expecting one of: "to"
RMAN-01007: at line 4 column 29 file: standard input
...

RMAN> run
{
ALLOCATE CHANNEL ch1 DEVICE TYPE 'SBT_TAPE' PARMS 'SBT_LIBRARY=/oracle/apps/osb/lib/libobk.so';
RESTORE CONTROLFILE from tag  stby_ctrl;
release channel ch1;
}
2> 3> 4> 5> 6> 
allocated channel: ch1
channel ch1: sid=13 devtype=SBT_TAPE
channel ch1: Oracle Secure Backup

Starting restore at 04.02.11

released channel: ch1
RMAN-00571: ===========================================================
RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
RMAN-00571: ===========================================================
RMAN-03002: failure of restore command at 02/04/2011 09:49:26
RMAN-06026: some targets not found - aborting restore
RMAN-06024: no backup or copy of the controlfile found to restore
...

RMAN> run
{
ALLOCATE CHANNEL ch1 DEVICE TYPE 'SBT_TAPE' PARMS 'SBT_LIBRARY=/oracle/apps/osb/lib/libobk.so';
RESTORE CONTROLFILE from 'CRVS_20110202.c7m3kbrd_1_1.stb';
release channel ch1;
}
2> 3> 4> 5> 6> 
allocated channel: ch1
channel ch1: sid=13 devtype=SBT_TAPE
channel ch1: Oracle Secure Backup

Starting restore at 04.02.11

channel ch1: restoring controlfile
channel ch1: restore complete
replicating controlfile
input filename=/data02/crvs/ctrl/control01.ctl
output filename=/data02/crvs/ctrl/control02.ctl
Finished restore at 04.02.11

released channel: ch1

RMAN>
4 фев 11, 06:58    [10181401]     Ответить | Цитировать Сообщить модератору
Все форумы / Oracle Ответить