Difference between revisions of "RecoverOracle"

From Tranzman Documentation
Jump to: navigation, search
Line 4: Line 4:
 
|
 
|
 
rman target /
 
rman target /
 +
|}
 +
As soon as you log in to the database, the DBID currently in use will be displayed.
 +
 +
{| class="wikitable" style="padding-left: 20px; color:#FFFFFF; background-color: black; width: 900px; FONT-FAMILY:monospace,monospace; LINE-HEIGHT:15px; white-space: pre-wrap; "
 +
|
 +
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=1519181895)
 +
 +
RMAN>
 
|}
 
|}
 
__NOTOC__
 
__NOTOC__

Revision as of 11:57, 9 November 2018

The restore of Oracle data can be done from within RMAN. 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=1519181895)

RMAN>

Step 1

Set the DBID for the database to be restored.

RMAN> SET DBID 1490584423;

Step 2

RMAN> STARTUP NOMOUNT;

Step 3

Restore the control file.

RMAN> RESTORE CONTROLFILE FROM "C:\Backup\Oracle\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\Oracle)';

Step 6

Catalog the dbf files.

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 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.