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