Home » RDBMS Server » Backup & Recovery » Error running automated TSPITR (Oracle 11g on SPARC Solaris)
Error running automated TSPITR [message #412950] Mon, 13 July 2009 10:13 Go to next message
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
Re: Error running automated TSPITR [message #412953 is a reply to message #412950] Mon, 13 July 2009 10:36 Go to previous messageGo to next message
Orna
Messages: 62
Registered: November 2008
Member
I found Metalink document 391785.1
this sounds very similar to what I am having

Even though this bug is said to be fixed in 11g - probably its not fully fixed

So , my only option is to use the manual way and create the auxiliary instance myself Sad

Orna
Re: Error running automated TSPITR [message #412958 is a reply to message #412953] Mon, 13 July 2009 11:19 Go to previous messageGo to next message
Orna
Messages: 62
Registered: November 2008
Member
I found an east workaround

If I configure the tape channels using the CONFIGURE command and not specyfying the channel allocation in the rcv file - the problem is solved.

thanks
Orna
Re: Error running automated TSPITR [message #413020 is a reply to message #412958] Tue, 14 July 2009 00:40 Go to previous message
babuknb
Messages: 1734
Registered: December 2005
Location: NJ
Senior Member


Great to know this.

Thanks for your feedback.

Babu
Previous Topic: Oracle 32 bit on 64 bit processor
Next Topic: Add redo log member to flash recovery area
Goto Forum:
  


Current Time: Wed Dec 07 12:44:27 CST 2016

Total time taken to generate the page: 0.06697 seconds