| Error running automated TSPITR [message #412950] |
Mon, 13 July 2009 10:13  |
Orna
Messages: 62
Registered: November 2008
|
Member |
|
|
Hi
I am trying to perform full automated point in time reconvery on our 11g database
the backups are on tape.
this is the log file :
Recovery Manager: Release 11.1.0.6.0 - Production on Mon Jul 13 14:55:13 2009
Copyright (c) 1982, 2007, Oracle. All rights reserved.
connected to target database: KGCSP (DBID=2179340697)
connected to recovery catalog database
RMAN> run{
2> ALLOCATE CHANNEL ch00 TYPE 'SBT_TAPE' parms 'ENV=(NSR_SERVER=bkpnyc02.ibasis.net,NSR_DATA_VOLUME_POOL=DBBACKUP, NSR_CLIENT=timskn
ycdb01, NSR_GROUP=RMAN_2_WEEKS)';
3> ALLOCATE CHANNEL ch01 TYPE 'SBT_TAPE' parms 'ENV=(NSR_SERVER=bkpnyc02.ibasis.net,NSR_DATA_VOLUME_POOL=DBBACKUP, NSR_CLIENT=timskn
ycdb01, NSR_GROUP=RMAN_2_WEEKS)';
4> ALLOCATE CHANNEL CH03 DEVICE TYPE DISK;
5> recover tablespace MRTR_P20090210,MRTR_P20090211
6> until time "to_date('07/06/2009 06:00:00','mm/dd/yyyy hh24:mi:ss')"
7> auxiliary destination '/u07/recover_dir';
8> release channel ch00;
9> release channel ch01;
10> }11>
12>
allocated channel: ch00
channel ch00: SID=528 device type=SBT_TAPE
channel ch00: NMO v4.2.0.0
allocated channel: ch01
channel ch01: SID=227 device type=SBT_TAPE
channel ch01: NMO v4.2.0.0
allocated channel: CH03
channel CH03: SID=114 device type=DISK
Starting recover at 13-JUL-09
Creating automatic instance, with SID='eujh'
initialization parameters used for automatic instance:
db_name=KGCSP
compatible=11.1.0.0.0
db_block_size=8192
db_files=2000
db_unique_name=tspitr_KGCSP_eujh
large_pool_size=1M
shared_pool_size=110M
processes=50
#No auxiliary parameter file used
db_create_file_dest=/u07/recover_dir
control_files=/u07/recover_dir/cntrl_tspitr_KGCSP_eujh.f
starting up automatic instance KGCSP
Oracle instance started
Total System Global Area 213041152 bytes
Fixed Size 2099464 bytes
Variable Size 147789560 bytes
Database Buffers 58720256 bytes
Redo Buffers 4431872 bytes
Automatic instance created
contents of Memory Script:
{
# set the until clause
set until time "to_date('07/06/2009 06:00:00','mm/dd/yyyy hh24:mi:ss')";
# restore the controlfile
restore clone controlfile;
# mount the controlfile
sql clone 'alter database mount clone database';
# archive current online log for tspitr to a resent until time
sql 'alter system archive log current';
# avoid unnecessary autobackups for structural changes during TSPITR
sql 'begin dbms_backup_restore.AutoBackupFlag(FALSE); end;';
# resync catalog after controlfile restore
resync catalog;
}
executing Memory Script
executing command: SET until clause
Starting restore at 13-JUL-09
Removing automatic instance
shutting down automatic instance
Oracle instance shut down
Automatic instance removed
released channel: ch00
released channel: ch01
released channel: CH03
RMAN-00571: ===========================================================
RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
RMAN-00571: ===========================================================
RMAN-03002: failure of recover command at 07/13/2009 14:55:23
RMAN-03015: error occurred in stored script Memory Script
RMAN-06034: at least 1 channel must be allocated to execute this command
Why do I get this error ?
I cannot allocate an auxiliary channel because then I get the error :
RMAN-06174: not connected to auxiliary database
And I cannot connect to the auxiliary DB - it was not created yet ( that's the whole point of the automated TSPITR , I believe )
thanks in advance
Orna
|
|
|
|
|
|
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
