Difference between revisions of "RecoverOracle"

From Tranzman Documentation
Jump to: navigation, search
Line 1: Line 1:
'''Step 1'''
+
==='''Step 1'''===
  
 
Set the DBID for the database to be restored.
 
Set the DBID for the database to be restored.
Line 5: Line 5:
 
:'''''SET DBID 1490584423;'''''
 
:'''''SET DBID 1490584423;'''''
  
'''Step 2'''
+
==='''Step 2'''===
  
 
:'''''STARTUP NOMOUNT;'''''
 
:'''''STARTUP NOMOUNT;'''''
  
'''Step 3'''
+
==='''Step 3'''===
  
 
Restore the control file.
 
Restore the control file.
Line 15: Line 15:
 
:'''''RESTORE THE CONTROL FILE FROM "C:\Backup\Oracle\C\ProgramData\OmniBack\tmp\ctrl_ORCL_2924.dbf";'''''
 
:'''''RESTORE THE CONTROL FILE FROM "C:\Backup\Oracle\C\ProgramData\OmniBack\tmp\ctrl_ORCL_2924.dbf";'''''
  
'''Step 4'''
+
==='''Step 4'''===
  
 
Mount the database.
 
Mount the database.
Line 21: Line 21:
 
:'''''ALTER DATABASE MOUNT;'''''
 
:'''''ALTER DATABASE MOUNT;'''''
  
'''Step 5'''
+
==='''Step 5'''===
  
 
Configure sbt device.
 
Configure sbt device.
Line 28: Line 28:
 
:'''''CONFIGURE CHANNEL DEVICE TYPE sbt_tape  PARMS='SBT_LIBRARY=oracle.disksbt,ENV=(BACKUP_DIR=C:\Backup\new)';'''''
 
:'''''CONFIGURE CHANNEL DEVICE TYPE sbt_tape  PARMS='SBT_LIBRARY=oracle.disksbt,ENV=(BACKUP_DIR=C:\Backup\new)';'''''
  
'''Step 6'''
+
==='''Step 6'''===
  
 
Catalog the dbf files.
 
Catalog the dbf files.
Line 66: Line 66:
 
:'''''catalog device type 'SBT_TAPE' backuppiece 'B_ORA_All_Full_BS068%3CORCL_9%3A962806071%3A1%3E.dbf';'''''
 
:'''''catalog device type 'SBT_TAPE' backuppiece 'B_ORA_All_Full_BS068%3CORCL_9%3A962806071%3A1%3E.dbf';'''''
  
'''Step 5'''
+
==='''Step 5'''===
  
 
Do a crosscheck  backup files on disk with entries in the catalog or controlfile.
 
Do a crosscheck  backup files on disk with entries in the catalog or controlfile.
Line 72: Line 72:
 
:'''''CROSSCHECK BACKUP;'''''
 
:'''''CROSSCHECK BACKUP;'''''
  
'''Step 6'''
+
==='''Step 6'''===
  
 
Restore the database.
 
Restore the database.
Line 78: Line 78:
 
:'''''RESTORE DATABASE;'''''
 
:'''''RESTORE DATABASE;'''''
  
'''Step 7'''
+
==='''Step 7'''===
  
 
Now recover the database.
 
Now recover the database.
  
 
:'''''RECOVER DATABASE;'''''
 
:'''''RECOVER DATABASE;'''''

Revision as of 11:23, 30 August 2018

Step 1

Set the DBID for the database to be restored.

SET DBID 1490584423;

Step 2

STARTUP NOMOUNT;

Step 3

Restore the control file.

RESTORE THE CONTROL FILE FROM "C:\Backup\Oracle\C\ProgramData\OmniBack\tmp\ctrl_ORCL_2924.dbf";

Step 4

Mount the database.

ALTER DATABASE MOUNT;

Step 5

Configure sbt device.

CONFIGURE DEVICE TYPE sbt_tape PARALLELISM 1;
CONFIGURE CHANNEL DEVICE TYPE sbt_tape PARMS='SBT_LIBRARY=oracle.disksbt,ENV=(BACKUP_DIR=C:\Backup\new)';

Step 6

Catalog the dbf files.

catalog device type 'SBT_TAPE' backuppiece 'B_ORA_All_Full_BS068%3CORCL_10%3A962806106%3A1%3E.dbf';
catalog device type 'SBT_TAPE' backuppiece 'B_ORA_All_Full_BS068%3CORCL_11%3A977481621%3A1%3E.dbf';
catalog device type 'SBT_TAPE' backuppiece 'B_ORA_All_Full_BS068%3CORCL_12%3A977481656%3A1%3E.dbf';
catalog device type 'SBT_TAPE' backuppiece 'B_ORA_All_Full_BS068%3CORCL_16%3A977491557%3A1%3E.dbf';
catalog device type 'SBT_TAPE' backuppiece 'B_ORA_All_Full_BS068%3CORCL_17%3A977491557%3A1%3E.dbf';
catalog device type 'SBT_TAPE' backuppiece 'B_ORA_All_Full_BS068%3CORCL_18%3A977491557%3A1%3E.dbf';
catalog device type 'SBT_TAPE' backuppiece 'B_ORA_All_Full_BS068%3CORCL_19%3A977491557%3A1%3E.dbf';
catalog device type 'SBT_TAPE' backuppiece 'B_ORA_All_Full_BS068%3CORCL_2%3A962805087%3A1%3E.dbf';
catalog device type 'SBT_TAPE' backuppiece 'B_ORA_All_Full_BS068%3CORCL_20%3A977491575%3A1%3E.dbf';
catalog device type 'SBT_TAPE' backuppiece 'B_ORA_All_Full_BS068%3CORCL_21%3A977491602%3A1%3E.dbf';
catalog device type 'SBT_TAPE' backuppiece 'B_ORA_All_Full_BS068%3CORCL_22%3A977491602%3A1%3E.dbf';
catalog device type 'SBT_TAPE' backuppiece 'B_ORA_All_Full_BS068%3CORCL_23%3A977492038%3A1%3E.dbf';
catalog device type 'SBT_TAPE' backuppiece 'B_ORA_All_Full_BS068%3CORCL_24%3A977492038%3A1%3E.dbf';
catalog device type 'SBT_TAPE' backuppiece 'B_ORA_All_Full_BS068%3CORCL_25%3A977492038%3A1%3E.dbf';
catalog device type 'SBT_TAPE' backuppiece 'B_ORA_All_Full_BS068%3CORCL_26%3A977492046%3A1%3E.dbf';
catalog device type 'SBT_TAPE' backuppiece 'B_ORA_All_Full_BS068%3CORCL_27%3A977492058%3A1%3E.dbf';
catalog device type 'SBT_TAPE' backuppiece 'B_ORA_All_Full_BS068%3CORCL_9%3A962806071%3A1%3E.dbf';

Step 5

Do a crosscheck backup files on disk with entries in the catalog or controlfile.

CROSSCHECK BACKUP;

Step 6

Restore the database.

RESTORE DATABASE;

Step 7

Now recover the database.

RECOVER DATABASE;