| Rman TSPITR error [message #293330] |
Fri, 11 January 2008 13:08  |
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 #293336 is a reply to message #293330] |
Fri, 11 January 2008 13:24  |
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
|
|
|
|
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
