RMAN

RMAN VALIDATE command is used to check for corrupt blocks and missing files, or to determine whether a backup set can be restored. If VALIDATE detects a problem… Read More »RMAN VALIDATE

Use the RMAN TRANSPORT TABLESPACE command to create transportable tablespace sets from RMAN backups instead of the live data files of the source database. Using RMAN TRANSPORT… Read More »RMAN TRANSPORT TABLESPACE

RMAN REPAIR FAILURE command is used to repair database failures identified by the Data Recovery Advisor. The recommended workflow is to run LIST FAILURE to display failures, ADVISE FAILURE to display… Read More »RMAN REPAIR FAILURE

RMAN RECOVER, Steps required Recovering a Tablespace in an Open Database Assume that the disk containing the data files for tablespace users becomes unavailable because of a… Read More »RMAN RECOVER

RMAN RESTORE Operations Restoring a Tablespace This example takes a tablespace offline, restores it, then performs media recovery. ALTER TABLESPACE users OFFLINE IMMEDIATE; RESTORE TABLESPACE… Read More »RMAN RESTORE

RMAN Flashback Database to a Specific SCN Assume that you inserted corrupted rows in many tables at 5:00 p.m. on February 14. You connect SQL*Plus… Read More »RMAN FLASHBACK DATABASE

Using RMAN CONVERT, Converting Tablespaces on the Source Platform Suppose you must convert tablespaces finance and hr in source database prodlin to the platform format of destination database prodsun. The finance tablespace includes data… Read More »RMAN CONVERT

RMAN CROSSCHECK Command to Cross-Check All Backups and Copies This example, which assumes that the default configured channel is DEVICE TYPE sbt, cross-checks all backups and… Read More »RMAN CROSSCHECK

RMAN PRINT SCRIPT command is used to print a local or global stored script to standard output or to a file. Prerequisites Execute PRINT SCRIPT only at the… Read More »RMAN PRINT SCRIPT

RMAN LIST Command uses the information in the RMAN repository to provide lists of backups and other objects. Listing Backups This RMAN LIST Command example… Read More »RMAN LIST Command

RMAN EXECUTE SCRIPT command is used to run a local or global RMAN script stored in the recovery catalog Executing a Stored Script This example… Read More »RMAN EXECUTE SCRIPT

RMAN CREATE SCRIPT command is used to create a stored script in the recovery catalog Creating a Global Stored Script This example connects RMAN to… Read More »RMAN Create Script