Difference between revisions of "RecoverOracle"
| Line 22: | Line 22: | ||
{| class="wikitable" style="padding-left: 20px; color:#FFFFFF; background-color: black; width: 900px; FONT-FAMILY:monospace,monospace; LINE-HEIGHT:15px; white-space: pre-wrap; " | {| class="wikitable" style="padding-left: 20px; color:#FFFFFF; background-color: black; width: 900px; FONT-FAMILY:monospace,monospace; LINE-HEIGHT:15px; white-space: pre-wrap; " | ||
| | | | ||
| − | RESTORE | + | RMAN> RESTORE CONTROLFILE FROM "C:\Backup\Oracle\C\ProgramData\OmniBack\tmp\ctrl_ORCL_2924.dbf"; |
|} | |} | ||
| Line 31: | Line 31: | ||
{| class="wikitable" style="padding-left: 20px; color:#FFFFFF; background-color: black; width: 900px; FONT-FAMILY:monospace,monospace; LINE-HEIGHT:15px; white-space: pre-wrap; " | {| class="wikitable" style="padding-left: 20px; color:#FFFFFF; background-color: black; width: 900px; FONT-FAMILY:monospace,monospace; LINE-HEIGHT:15px; white-space: pre-wrap; " | ||
| | | | ||
| − | ALTER DATABASE MOUNT; | + | RMAN> ALTER DATABASE MOUNT; |
|} | |} | ||
| Line 40: | Line 40: | ||
{| class="wikitable" style="padding-left: 20px; color:#FFFFFF; background-color: black; width: 900px; FONT-FAMILY:monospace,monospace; LINE-HEIGHT:15px; white-space: pre-wrap; " | {| class="wikitable" style="padding-left: 20px; color:#FFFFFF; background-color: black; width: 900px; FONT-FAMILY:monospace,monospace; LINE-HEIGHT:15px; white-space: pre-wrap; " | ||
| | | | ||
| − | CONFIGURE DEVICE TYPE sbt_tape PARALLELISM 1; | + | RMAN> CONFIGURE DEVICE TYPE sbt_tape PARALLELISM 1; |
| − | CONFIGURE CHANNEL DEVICE TYPE sbt_tape PARMS='SBT_LIBRARY=oracle.disksbt,ENV=(BACKUP_DIR=C:\Backup\new)'; | + | RMAN> CONFIGURE CHANNEL DEVICE TYPE sbt_tape PARMS='SBT_LIBRARY=oracle.disksbt,ENV=(BACKUP_DIR=C:\Backup\new)'; |
|} | |} | ||
| Line 75: | Line 75: | ||
{| class="wikitable" style="padding-left: 20px; color:#FFFFFF; background-color: black; width: 900px; FONT-FAMILY:monospace,monospace; LINE-HEIGHT:15px; white-space: pre-wrap; " | {| class="wikitable" style="padding-left: 20px; color:#FFFFFF; background-color: black; width: 900px; FONT-FAMILY:monospace,monospace; LINE-HEIGHT:15px; white-space: pre-wrap; " | ||
| | | | ||
| − | CROSSCHECK BACKUP; | + | RMAN> CROSSCHECK BACKUP; |
|} | |} | ||
| Line 84: | Line 84: | ||
{| class="wikitable" style="padding-left: 20px; color:#FFFFFF; background-color: black; width: 900px; FONT-FAMILY:monospace,monospace; LINE-HEIGHT:15px; white-space: pre-wrap; " | {| class="wikitable" style="padding-left: 20px; color:#FFFFFF; background-color: black; width: 900px; FONT-FAMILY:monospace,monospace; LINE-HEIGHT:15px; white-space: pre-wrap; " | ||
| | | | ||
| − | RESTORE DATABASE; | + | RMAN> RESTORE DATABASE; |
|} | |} | ||
| Line 93: | Line 93: | ||
{| class="wikitable" style="padding-left: 20px; color:#FFFFFF; background-color: black; width: 900px; FONT-FAMILY:monospace,monospace; LINE-HEIGHT:15px; white-space: pre-wrap; " | {| class="wikitable" style="padding-left: 20px; color:#FFFFFF; background-color: black; width: 900px; FONT-FAMILY:monospace,monospace; LINE-HEIGHT:15px; white-space: pre-wrap; " | ||
| | | | ||
| − | RECOVER DATABASE; | + | RMAN> RECOVER DATABASE; |
|} | |} | ||
---- | ---- | ||
Use this link to go back to the main [[recoverydocs]] Page. | Use this link to go back to the main [[recoverydocs]] Page. | ||
Revision as of 11:25, 1 November 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.
|
RMAN> RESTORE CONTROLFILE FROM "C:\Backup\Oracle\C\ProgramData\OmniBack\tmp\ctrl_ORCL_2924.dbf"; |
Step 4
Mount the database.
|
RMAN> ALTER DATABASE MOUNT; |
Step 5
Configure sbt device.
|
RMAN> CONFIGURE DEVICE TYPE sbt_tape PARALLELISM 1; RMAN> 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.
|
RMAN> CROSSCHECK BACKUP; |
Step 6
Restore the database.
|
RMAN> RESTORE DATABASE; |
Step 7
Now recover the database.
|
RMAN> RECOVER DATABASE; |
Use this link to go back to the main recoverydocs Page.