Difference between revisions of "Recovery as Normal Files(Oracle)"

From Tranzman Documentation
Jump to: navigation, search
(Created page with "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 '''RM...")
 
 
(3 intermediate revisions by the same user not shown)
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 files (dbf'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 2'''===
+
==='''Step 1'''===
−
From Netbackup restore the Oracle backup as files, and then copy them to a temporary location on the Oracle server.
 
−
 
 
−
[[File:Restore_Oracle_Files.jpg]]
 
−
 
 
−
In our example, we have copied them to the location of '''"C:\Backup\Oracle"'''.
 
−
 
 
−
==='''Step 3'''===
 
 
{| 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 35: Line 31:
 
|}
 
|}
  
−
==='''Step 4'''===
+
==='''Step 2'''===
 
Restore the control file.
 
Restore the control file.
  
Line 45: 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 5'''===
+
==='''Step 3'''===
 
Mount the database.
 
Mount the database.
  
Line 53: Line 49:
 
|}
 
|}
  
−
==='''Step 6'''===
+
==='''Step 4'''===
 
Configure sbt device.
 
Configure sbt device.
  
Line 62: Line 58:
 
|}
 
|}
  
−
==='''Step 7'''===
+
==='''Step 5'''===
 
Catalog each of the dbf files in turn.
 
Catalog each of the dbf files in turn.
  
Line 86: Line 82:
 
|}
 
|}
  
−
==='''Step 8'''===
+
==='''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 94: Line 90:
 
|}
 
|}
  
−
==='''Step 9'''===
+
==='''Step 7'''===
 
Restore the database.
 
Restore the database.
  
Line 102: Line 98:
 
|}
 
|}
  
−
==='''Step 10'''===
+
==='''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.
  
Line 110: Line 106:
 
|}
 
|}
  
−
----
+
 
−
Use this link to go back to the main [[recoverydocs]] Page.
+
 
 +
[[ VERITAS NetBackup Recovery | Return to VERITAS NetBackup Recovery ]]

Latest revision as of 12:06, 14 July 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 files (dbf'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;


Return to VERITAS NetBackup Recovery

Retrieved from "https://docs.stoneram.com/index.php?title=Recovery_as_Normal_Files(Oracle)&oldid=2695"