Home » RDBMS Server » Backup & Recovery » Facing Deadlock error while restore using TSPITR (oracle 11g in linux environment)
Facing Deadlock error while restore using TSPITR [message #471820] Tue, 17 August 2010 08:32
saravanan82kumar
Messages: 5
Registered: September 2007
Location: Bnagalore
Junior Member

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.
Previous Topic: Flash Recovery Area
Next Topic: backup and recovery
Goto Forum:
  


Current Time: Mon Dec 22 06:26:34 CST 2014

Total time taken to generate the page: 0.09616 seconds