Home » RDBMS Server » Backup & Recovery » Rman TSPITR error
Rman TSPITR error [message #293330] Fri, 11 January 2008 13:08 Go to next message
monto
Messages: 60
Registered: November 2007
Location: DALLAS
Member
Hi ,
I am trying to do TSPITR using Rman(10105,hpux 11.1) .

SQL> select to_char(sysdate,'YYYY-MM-DD:HH24:MI:SS') from dual;

TO_CHAR(SYSDATE,'YY
-------------------
2008-01-11:17:44:59


SQL> DROP TABLE TEST.TEST1;

Table dropped.

Now during the recovery of tablespace USERS, i am getting the following error did search for the argument for it on metalink but found nothing.


Command used:
RUN
{
ALLOCATE AUXILIARY CHANNEL c1 DEVICE TYPE DISK;
RECOVER TABLESPACE users UNTIL time "to_date('01/11/2008 17:44:30','mm/dd/yyyy hh24:mi:ss')" ;
}



Errors:
sql statement: alter database datafile 1 online

sql statement: alter database datafile 2 online

sql statement: alter database datafile 4 online

Starting recover at 11-JAN-08

starting media recovery

archive log thread 1 sequence 501 is already on disk as file /amoidts1/oidtest/arch/log1_501_641767390.dbf
archive log thread 1 sequence 502 is already on disk as file /amoidts1/oidtest/arch/log1_502_641767390.dbf
archive log thread 1 sequence 503 is already on disk as file /amoidts1/oidtest/arch/log1_503_641767390.dbf
archive log filename=/amoidts1/oidtest/arch/log1_501_641767390.dbf thread=1 sequence=501
released channel: c1
RMAN-00571: ===========================================================
RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
RMAN-00571: ===========================================================
RMAN-03002: failure of recover command at 01/11/2008 17:57:46
RMAN-03015: error occurred in stored script Memory Script
ORA-00283: recovery session canceled due to errors
RMAN-11003: failure during parse/execution of SQL statement: alter database recover logfile '/amoidts1/oidtest/arch/log1_501_641767390.dbf'
ORA-00283: recovery session canceled due to errors
ORA-00600: internal error code, arguments: [3635], [4], [], [], [], [], [], []

Please any help would be appericated.
Re: Rman TSPITR error [message #293332 is a reply to message #293330] Fri, 11 January 2008 13:12 Go to previous messageGo to next message
Michel Cadot
Messages: 64103
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
ORA-00600 = Oracle bug => search on Metalink and/or call Oracle support

Copy and paste the whole RMAN session, maybe we will wee something.

Regards
Michel

[Updated on: Fri, 11 January 2008 13:13]

Report message to a moderator

Re: Rman TSPITR error [message #293336 is a reply to message #293330] Fri, 11 January 2008 13:24 Go to previous messageGo to next message
monto
Messages: 60
Registered: November 2007
Location: DALLAS
Member
I search on metalink found nothing for this argument.

Following is the ouput of whole rman session.

RMAN> RUN
{
ALLOCATE AUXILIARY CHANNEL c1 DEVICE TYPE DISK;
RECOVER TABLESPACE users UNTIL time "to_date('01/11/2008 17:44:30','mm/dd/yyyy hh24:mi:ss')" ;
}
2> 3> 4> 5>
allocated channel: c1
channel c1: sid=390 devtype=DISK

Starting recover at 11-JAN-08

contents of Memory Script:
{
# set the until clause
set until time "to_date('01/11/2008 17:44:30','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 11-JAN-08

channel c1: starting datafile backupset restore
channel c1: restoring controlfile
channel c1: restored backup piece 1
piece handle=/amoidts1/OID/flash_recovery/OIDTEST/autobackup/2008_01_11/o1_mf_s_643743110_3rhb06xv_.bkp tag=TAG20080111T173150
channel c1: restore complete
output filename=/ufsstg/gmcsspr02s/oradata/oidsr/controloidsr01.ctl
output filename=/ufsstg/gmcsspr02s/oradata/oidsr/controloidsr02.ctl
output filename=/ufsstg/gmcsspr02s/oradata/oidsr/controloidsr03.ctl
Finished restore at 11-JAN-08

sql statement: alter database mount clone database

sql statement: alter system archive log current

sql statement: begin dbms_backup_restore.AutoBackupFlag(FALSE); end;

starting full resync of recovery catalog
full resync complete

contents of Memory Script:
{
# generated tablespace point-in-time recovery script
# set the until clause
set until time "to_date('01/11/2008 17:44:30','mm/dd/yyyy hh24:mi:ss')";
# do a FLIP
switch clone datafile 1 to datafilecopy
"/ufsstg/gmcsspr02s/oradata/oidsr/system01.dbf";
# do a FLIP
switch clone datafile 2 to datafilecopy
"/ufsstg/gmcsspr02s/oradata/oidsr/undotbs01.dbf";
# set a destination filename for restore
set newname for datafile 1 to
"/ufsstg/gmcsspr02s/oradata/oidsr/system01.dbf";
# set a destination filename for restore
set newname for datafile 2 to
"/ufsstg/gmcsspr02s/oradata/oidsr/undotbs01.dbf";
# set a destination filename for restore
set newname for datafile 4 to
"/amoidts1/oradata/oidtest/users01.dbf";
# restore the tablespaces in the recovery set plus the auxilliary tablespaces
restore clone datafile 4;
switch clone datafile all;
#online the datafiles restored or flipped
sql clone "alter database datafile 1 online";
#online the datafiles restored or flipped
sql clone "alter database datafile 2 online";
#online the datafiles restored or flipped
sql clone "alter database datafile 4 online";
# make the controlfile point at the restored datafiles, then recover them
recover clone database tablespace "USERS", "SYSTEM", "UNDOTBS1" delete archivelog;
alter clone database open resetlogs;
# PLUG HERE the creation of a temporary tablespace if export fails due to lack
# of temporary space.
# For example in Unix these two lines would do that:
#sql clone "create tablespace aux_tspitr_tmp
# datafile ''/tmp/aux_tspitr_tmp.dbf'' size 500K";
}
executing Memory Script

executing command: SET until clause

datafile 1 switched to datafile copy
input datafilecopy recid=2 stamp=643744661 filename=/ufsstg/gmcsspr02s/oradata/oidsr/system01.dbf

datafile 2 switched to datafile copy
input datafilecopy recid=3 stamp=643744661 filename=/ufsstg/gmcsspr02s/oradata/oidsr/undotbs01.dbf

executing command: SET NEWNAME

executing command: SET NEWNAME

executing command: SET NEWNAME

Starting restore at 11-JAN-08

skipping datafile 4; already restored to file /amoidts1/oradata/oidtest/users01.dbf
restore not done; all files readonly, offline, or already restored
Finished restore at 11-JAN-08

datafile 4 switched to datafile copy
input datafilecopy recid=5 stamp=643744662 filename=/amoidts1/oradata/oidtest/users01.dbf

sql statement: alter database datafile 1 online

sql statement: alter database datafile 2 online

sql statement: alter database datafile 4 online

Starting recover at 11-JAN-08

starting media recovery

archive log thread 1 sequence 501 is already on disk as file /amoidts1/oidtest/arch/log1_501_641767390.dbf
archive log thread 1 sequence 502 is already on disk as file /amoidts1/oidtest/arch/log1_502_641767390.dbf
archive log thread 1 sequence 503 is already on disk as file /amoidts1/oidtest/arch/log1_503_641767390.dbf
archive log filename=/amoidts1/oidtest/arch/log1_501_641767390.dbf thread=1 sequence=501
released channel: c1
RMAN-00571: ===========================================================
RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
RMAN-00571: ===========================================================
RMAN-03002: failure of recover command at 01/11/2008 17:57:46
RMAN-03015: error occurred in stored script Memory Script
ORA-00283: recovery session canceled due to errors
RMAN-11003: failure during parse/execution of SQL statement: alter database recover logfile '/amoidts1/oidtest/arch/log1_501_641767390.dbf'
ORA-00283: recovery session canceled due to errors
ORA-00600: internal error code, arguments: [3635], [4], [], [], [], [], [], []

RMAN> EXIT

Re: Rman TSPITR error [message #293341 is a reply to message #293336] Fri, 11 January 2008 13:34 Go to previous messageGo to next message
Michel Cadot
Messages: 64103
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
So the process is (or seems to be) correct but you fell into an Oracle bug.

Regards
Michel
Re: Rman TSPITR error [message #293344 is a reply to message #293330] Fri, 11 January 2008 13:44 Go to previous message
monto
Messages: 60
Registered: November 2007
Location: DALLAS
Member
Thanks Michel.

Regards
Previous Topic: flashback database
Next Topic: Can I force the clone DB to receive data from primary DB?
Goto Forum:
  


Current Time: Sun Dec 04 00:09:30 CST 2016

Total time taken to generate the page: 0.11250 seconds