Difference between revisions of "RecoverOracle"
From Tranzman Documentation
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;