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

From Tranzman Documentation
Jump to: navigation, search
 
(One intermediate revision 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 ]].
 
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.
+
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 106: 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"