Difference between revisions of "Recovery as Normal Files(Oracle)"
| Line 1: | Line 1: | ||
| + | Below documentation shows how to restore Oracle data after it has been recovered as normal files using steps as shown in [[ Recovery as Normal Files(FileSystem) | Recovery as Normal Files ]]. | ||
| + | Please recover the Oracle database files (mdf's). Once you have the files, please follow the steps to restore. | ||
| + | |||
The restore of Oracle data can be done from within '''RMAN''' and we restore the backup files from NetBackup to a temporary location on the Oracle server. | The restore of Oracle data can be done from within '''RMAN''' and we restore the backup files from NetBackup to a temporary location on the Oracle server. | ||
| Line 22: | Line 25: | ||
| − | ==='''Step | + | ==='''Step 1'''=== |
{| 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; " | ||
| | | | ||
| Line 28: | Line 31: | ||
|} | |} | ||
| − | ==='''Step | + | ==='''Step 2'''=== |
Restore the control file. | Restore the control file. | ||
| Line 38: | Line 41: | ||
Restore of control file changes the DBID to the target DBID. Run a select DBID from v$database; from SQL to verify that. | Restore of control file changes the DBID to the target DBID. Run a select DBID from v$database; from SQL to verify that. | ||
| − | ==='''Step | + | ==='''Step 3'''=== |
Mount the database. | Mount the database. | ||
| Line 46: | Line 49: | ||
|} | |} | ||
| − | ==='''Step | + | ==='''Step 4'''=== |
Configure sbt device. | Configure sbt device. | ||
| Line 55: | Line 58: | ||
|} | |} | ||
| − | ==='''Step | + | ==='''Step 5'''=== |
Catalog each of the dbf files in turn. | Catalog each of the dbf files in turn. | ||
| Line 79: | Line 82: | ||
|} | |} | ||
| − | ==='''Step | + | ==='''Step 6'''=== |
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 87: | Line 90: | ||
|} | |} | ||
| − | ==='''Step | + | ==='''Step 7'''=== |
Restore the database. | Restore the database. | ||
| Line 95: | Line 98: | ||
|} | |} | ||
| − | ==='''Step | + | ==='''Step 8'''=== |
Perform this step if redo of all online datafiles needs to be applied. | Perform this step if redo of all online datafiles needs to be applied. | ||
Revision as of 15:23, 18 May 2021
Below documentation shows how to restore Oracle data after it has been recovered as normal files using steps as shown in Recovery as Normal Files . Please recover the Oracle database files (mdf's). Once you have the files, please follow the steps to restore.
The restore of Oracle data can be done from within RMAN and we restore the backup files from NetBackup to a temporary location on the Oracle server.
To log in to RMAN, type the command below into a Command Line window.
|
rman target / |
As soon as you log in to the database, the DBID currently in use will be displayed.
|
Recovery Manager: Release 11.2.0.1.0 - Production on Fri Nov 9 11:53:46 2018 Copyright (c) 1982, 2009, Oracle and/or its affiliates. All rights reserved. connected to target database: ORCL (DBID=1490584423) RMAN> |
Step 1
|
RMAN> STARTUP NOMOUNT; |
Step 2
Restore the control file.
|
RMAN> REPLICATE CONTROLFILE FROM "C:\Backup\Oracle\ctrl_ORCL_2924.dbf"; |
Restore of control file changes the DBID to the target DBID. Run a select DBID from v$database; from SQL to verify that.
Step 3
Mount the database.
|
RMAN> ALTER DATABASE MOUNT; |
Step 4
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\Oracle)'; |
Step 5
Catalog each of the dbf files in turn.
|
RMAN> catalog device type 'SBT_TAPE' backuppiece 'B_ORA_All_Full_BS068%3CORCL_10%3A962806106%3A1%3E.dbf'; RMAN> catalog device type 'SBT_TAPE' backuppiece 'B_ORA_All_Full_BS068%3CORCL_11%3A977481621%3A1%3E.dbf'; RMAN> catalog device type 'SBT_TAPE' backuppiece 'B_ORA_All_Full_BS068%3CORCL_12%3A977481656%3A1%3E.dbf'; RMAN> catalog device type 'SBT_TAPE' backuppiece 'B_ORA_All_Full_BS068%3CORCL_16%3A977491557%3A1%3E.dbf'; RMAN> catalog device type 'SBT_TAPE' backuppiece 'B_ORA_All_Full_BS068%3CORCL_17%3A977491557%3A1%3E.dbf'; RMAN> catalog device type 'SBT_TAPE' backuppiece 'B_ORA_All_Full_BS068%3CORCL_18%3A977491557%3A1%3E.dbf'; RMAN> catalog device type 'SBT_TAPE' backuppiece 'B_ORA_All_Full_BS068%3CORCL_19%3A977491557%3A1%3E.dbf'; RMAN> catalog device type 'SBT_TAPE' backuppiece 'B_ORA_All_Full_BS068%3CORCL_2%3A962805087%3A1%3E.dbf'; RMAN> catalog device type 'SBT_TAPE' backuppiece 'B_ORA_All_Full_BS068%3CORCL_20%3A977491575%3A1%3E.dbf'; RMAN> catalog device type 'SBT_TAPE' backuppiece 'B_ORA_All_Full_BS068%3CORCL_21%3A977491602%3A1%3E.dbf'; RMAN> catalog device type 'SBT_TAPE' backuppiece 'B_ORA_All_Full_BS068%3CORCL_22%3A977491602%3A1%3E.dbf'; RMAN> catalog device type 'SBT_TAPE' backuppiece 'B_ORA_All_Full_BS068%3CORCL_23%3A977492038%3A1%3E.dbf'; RMAN> catalog device type 'SBT_TAPE' backuppiece 'B_ORA_All_Full_BS068%3CORCL_24%3A977492038%3A1%3E.dbf'; RMAN> catalog device type 'SBT_TAPE' backuppiece 'B_ORA_All_Full_BS068%3CORCL_25%3A977492038%3A1%3E.dbf'; RMAN> catalog device type 'SBT_TAPE' backuppiece 'B_ORA_All_Full_BS068%3CORCL_26%3A977492046%3A1%3E.dbf'; RMAN> catalog device type 'SBT_TAPE' backuppiece 'B_ORA_All_Full_BS068%3CORCL_27%3A977492058%3A1%3E.dbf'; RMAN> catalog device type 'SBT_TAPE' backuppiece 'B_ORA_All_Full_BS068%3CORCL_9%3A962806071%3A1%3E.dbf'; |
Step 6
Do a crosscheck backup files on disk with entries in the catalog or controlfile.
|
RMAN> CROSSCHECK BACKUP; |
Step 7
Restore the database.
|
RMAN> RESTORE DATABASE; |
Step 8
Perform this step if redo of all online datafiles needs to be applied.
|
RMAN> RECOVER DATABASE; |
Use this link to go back to the main recoverydocs Page.