RMAN

RMAN VALIDATE

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

RMAN REPAIR FAILURE

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

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

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 CONVERT

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

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