RMAN – incremental backup

RMAN command to create level 0 backup which is needed before running of incremental backup RMAN> BACKUP INCREMENTAL LEVEL 0 DATABASE; RMAN command to run level 1 backup. Level 1 backup will backup all blocks changed since most recent cumulative or differential backup. If a level 0 backup doesn’t exists, when running INCREMENTAL backup Oracle…

Using RMAN to validate backup

When using VALIDATE option, Oracle will validate backup and not create backups and will not restore when this option is used. # Validate if datafile exists and have no physical or logical corruptions that would prevent RMAN from running. If “archivelog” is specified it will also check if archive logs are valid too RMAN> backup…

How to rename block change tracking file?

To move/rename current block change tracking file, one would need to restart the database. # Get current block change tracking file SQL> SELECT filename FROM v$block_change_tracking; FILENAME ——————————————————————————– /tmp/blocktracking.f # Shutdown database and start database in mount state SQL> SHUTDOWN IMMEDIATE; SQL> STARTUP MOUNT; # Rename block tracking file and SQL> ALTER DATABASE RENAME FILE…

RMAN – checksyntax

Starting RMAN with check syntax will check syntax of RMAN command, it will report errors if the syntax is incorrect. Example: -- Start RMAN with check syntax option $ $ORACLE_HOME/bin/rman checksyntax Recovery Manager: Release 10.2.0.1.0 – Production on Sat Jan 22 19:49:42 2011 Copyright (c) 1982, 2005, Oracle. All rights reserved. -- Valid RMAN command,…

Offlining a datafile

When one offline a datafile before you online the datafile one has to recover the datafile 1) Offline a datafile SQL> alter database datafile 5 offline; Database altered. — Shows datafile is in recover state SQL> select status from v$datafile where file# = 5; STATUS ——- RECOVER — datafile can’t be made online SQL> alter…