| Facing Deadlock error while restore using TSPITR [message #471820] |
Tue, 17 August 2010 08:32 |
|
|
This is the step is followed but i am getting deadlock error .please give your valuable suggestion .
1)Before taking backup get SCN number for restore.
Command applied: Select current_scn from v$database;
2)running Full backup of database
Command applied:
{
configure controlfile autobackup on;
backup database;
}
CROSSCHECK BACKUP;
exit;
3)Running level 0 incremental backup
Command applied:
BACKUP AS COMPRESSED BACKUPSET INCREMENTAL LEVEL 0 TAG ='WEEKLY' TABLESPACE MNTNS;
exit;
3) Running level 1 incremental backup
Command applied:
BACKUP AS COMPRESSED BACKUPSET INCREMENTAL LEVEL 1 TAG ='DAILY' TABLESPACE MNTNS;
4)Before Restore(TSPITR) following procedure are applied under sysdba privilege
Command applied:
SQL 'exec dbms_backup_restore.manageauxinstance ('TSPITR',1)';
5)TSPITR Restore command
Command applied:
run
{
SQL 'ALTER TABLESPACE mntns OFFLINE'
RECOVER TABLESPACE MNTNS UNTIL SCN 1791053 AUXILIARY DESTINATION '/opt/oracle/base/flash_recovery_area';
SQL 'ALTER TABLESPACE MNTNS ONLINE';
}
and i tried with this option also(the same error i was getting)
Command applied:
run
{
SQL 'ALTER TABLESPACE mntns OFFLINE';
SET UNTIL SCN 1912813;
RESTORE TABLESPACE MNTNS;
RECOVER TABLESPACE MNTNS UNTIL SCN 1912813 AUXILIARY DESTINATION '/opt/oracle/base/flash_recovery_area';
SQL 'ALTER TABLESPACE MNTNS ONLINE';
}
The follwing error i get for above mentioned restore command
RMAN-00571: ===========================================================
RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
RMAN-00571: ===========================================================
RMAN-03002: failure of recover command at 08/17/2010 18:25:36
RMAN-03015: error occurred in stored script Memory Script
RMAN-03009: failure of sql command on default channel at 08/17/2010 18:25:25
RMAN-11003: failure during parse/execution of SQL statement: drop tablespace MNTNS including contents keep datafiles
ORA-00604: error occurred at recursive SQL level 1
ORA-00060: deadlock detected while waiting for resource
I here by attached restore log file also for your reference .please give your valuable suggestion .It should be more helpful for us.
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
