ORACLE RMAN - BASIC COMMANDS

 

RMAN BASIC COMMANDS

 

Sl. No.

Tasks

1.

RMAN Full Database Backup Script: This script performs a full backup of the entire database, including datafiles, control file, and spfile.

RUN {

ALLOCATE CHANNEL ch1 TYPE DISK;

BACKUP DATABASE FORMAT '/backup/full_db_%t_%p%p' FILESPERSET 10;

RELEASE CHANNEL ch1;

ALLOCATE CHANNEL ch2 TYPE DISK;

BACKUP CURRENT CONTROLFILE FORMAT '/backup/cntrl_%s_%p_%t';

RELEASE CHANNEL ch2;

ALLOCATE CHANNEL ch3 TYPE DISK;

BACKUP SPFILE FORMAT '/backup/spfile_%s_%p_%t';

RELEASE CHANNEL ch3;

}

 

2.

RMAN Incremental DB Backup Script: This script performs an incremental backup based on changes since the last full backup.

RUN

{

ALLOCATE CHANNEL ch1 TYPE DISK;

INCREMENTAL BACKUP DATABASE UNTIL TIME RECOVERABLE UNTIL TIME 'SYSDATE - 1'; RELEASE CHANNEL ch1;

}

 

3.

RMAN Tablespace Backup Script: This script backs up a specific tablespace.

RUN {

  ALLOCATE CHANNEL ch1 TYPE DISK;

  BACKUP TABLESPACE 'USERS' FORMAT '/backup/ts_users_%t_%p%p';

  RELEASE CHANNEL ch1;

}

 

4.

RMAN Datafile(s) Backup Script: This script backs up specific datafiles.

RUN {

  ALLOCATE CHANNEL ch1 TYPE DISK;

  BACKUP DATAFILE '/u01/app/oracle/oradata/orcl/datafile01.dbf' FORMAT

'/backup/datafile01_%t_%p%p';

  BACKUP DATAFILE '/u01/app/oracle/oradata/orcl/datafile02.dbf' FORMAT

'/backup/datafile02_%t_%p%p';

  RELEASE CHANNEL ch1;

}

 

5.

Delete Archive Older than 1 Day: This script deletes archive logs older than one day.

RUN {

  DELETE ARCHIVE LOG UNTIL TIME SYSDATE - 1;

}

 

6.

Backup Archive Logs Using RMAN: This script backs up all archive logs.

RUN {

  ALLOCATE CHANNEL ch1 TYPE DISK;

  BACKUP ARCHIVELOG FORMAT '/backup/arch_%t_%s_%p';

  RELEASE CHANNEL ch1;

}

 

7.

Copy Archive from ASM to Mount Point: This script copies an archive log from ASM to a mount point.

RUN {

COPY ARCHIVELOG '/+ASM/arch/

}

 

Copy archive log from ASM to regular mount point using RMAN: -

RMAN> copy archivelog '+B2BSTARC/thread_2_seq_34.933' to '/data/thread_2_seq_34.933';

 

8.

Backup Archive Between 2 Sequence Numbers: Backs up archive logs within a specified sequence range.

RUN {

ALLOCATE CHANNEL ch1 TYPE DISK;

BACKUP ARCHIVELOG FROM SEQUENCE 1000 UNTIL SEQUENCE 1050 FORMAT '/backup/arch_%t_%s_%p';

 RELEASE CHANNEL ch1;

}

 

9.

Enable Trace for RMAN: Enables detailed tracing for RMAN operations.

SET TRACE ENABLED;

 

To diagnose rman script, use trace as below.

spool trace to '/tmp/rman_trace.out';

report schema;

list backup summary;

list backup of datafile 1;

list copy of datafile 1;

spool trace off;

 

10.

Recover Dropped Table: Recovers a dropped table to a specified point in time.

RUN {

  ALLOCATE CHANNEL ch1 TYPE DISK;

  RECOVER TABLE "DROPPED_TABLE_NAME" UNTIL TIME "TO_DATE('2026-02-04 12:00:00', 'YYYY-MM-DD HH24:MI:SS')";

  RELEASE CHANNEL ch1;

}

 

11.

Monitor RMAN Backup Progress: Monitors the progress of an ongoing RMAN backup.

RMAN> LIST BACKUP;

 

sql> SELECT SID, SERIAL#, CONTEXT, SOFAR, TOTALWORK,

ROUND(SOFAR/TOTALWORK*100,2) "%_COMPLETE"

FROM V$SESSION_LONGOPS

WHERE OPNAME LIKE 'RMAN%'

AND OPNAME NOT LIKE '%aggregate%'

AND TOTALWORK != 0

AND SOFAR <> TOTALWORK;

 

12.

Restore Archivelog from RMAN Tape: Restores archive logs from tape to disk.

RUN {

  ALLOCATE CHANNEL ch1 DEVICE TYPE sbt;

  RESTORE ARCHIVELOG FROM SEQUENCE 1020 UNTIL SEQUENCE 1030;

  RELEASE CHANNEL ch1;

}

 

Restore the archive sequences from 7630 to 7640 to /dumparea location

run

{

allocate channel t1 type SBT_TAPE parms

‘ENV=(NSR_SERVER=nwwerpw,NSR_CLIENT=tsc_test01,NSR_DATA_VOLUME_POOL=

DD086A1)’connect sys/****@CRM_DB;

set archivelog destination to ‘/dumparea/';

restore archivelog from sequence 7630 until sequence 7640;

release channel t1;

}

 

13.

Enable Block Change Tracking: Enables block change tracking for faster incremental backups.

SQL> ALTER DATABASE ENABLE BLOCK CHANGE TRACKING;

SQL> alter database enable block change tracking using file

'/export/home/oracle/RMAN/TESTDB/TRACKING_FILE/block_change_TESTDB.log';

SQL> select filename,status from v$block_change_tracking;

 

 

Comments

Post a Comment

Popular posts from this blog

 Exadata  Oracle Exadata Smart Flash Cache * Exadata cell -> Flash LUN -> Cell Disk -> Flash Cache/Flash Log  * CELL_FLASH_CACHE - – DEFAULT (LRU), KEEP, NONE * ALTER TABLE <TABLE_NAME> STORAGE(FLASH_CACHE [NONE|DEFAULT|KEEP]) * ALTER INDEX <INDEX NAME> STORAGE(FLASH_CACHE [NONE|DEFAULT|KEEP]) Smart Flash Cache Mode: 1. Write Through Flash Cache Mode (Default):  Write on Disk -> Copy to Flash Cache  * excellent for absorbing repeated random reads  * commonly found in OLTP applications. * dcli -g cell_servers -l celladmin cellcli -e "list cell attributes flashcachemode" * Steps to enable Write-Through Mode CellCLI> ALTER FLASHCACHE ALL FLUSH CellCLI> DROP FLASHCACHE CellCLI> ALTER CELL SHUTDOWN SERVICES CELLSRV CellCLI> ALTER CELL flashCacheMode=WriteThrough CellCLI> ALTER CELL STARTUP SERVICES CELLSRV CellCLI> CREATE FLASHCACHE ALL 2. Write Back Flash Cache Mode:  Write on Flash -> Copy to Disk  * best ...
Read more

Database Network : Configuration Parameters

LSNRCTL> command [listener_name] lsnrctl @file_name  #to execute in batch mode. REM or # to identify comments in the batch script Listener.ora file parameters: ·          PASSWORDS_listener_name  #an unencrypted password ·          LSNRCTL> change_password #to establish an encrypted password ·          LSNRCTL> SAVE_CONFIG  #Any changes are stored in listener.ora ·          LSNRCTL> SET PASSWORD  #If a password is set, then issue SET PASSWORD command before changing the password. Use the command SET PASSWORD prior to privileged Listener Control utility commands ·          Reload : the database services, instances, service handlers, and listening endpoints that were dynamically registered with the listener will be unregistered and subseque...
Read more

Undo Segments : Drop Problematic Undo Segments

ERROR about to recover undo segment 98 status:6 inst:0 mark undo segment 98 as available status:6 ret:1  about to recover undo segment 46 status:6 inst:0 mark undo segment 46 as available status:6 ret:1   SQL> select * from V$FAST_START_TRANSACTIONS; USN SLT SEQ STATE UNDOBLOCKSDONE UNDOBLOCKSTOTAL PID CPUTIME PARENTUSN PARENTSLT PARENTSEQ XID PXID RCVSERVERS CON_ID ---------- ---------- ---------- ---------------- -------------- --------------- ---------- ---------- ---------- ---------- 46 46 2313064 RECOVERING 505 24992423 77 5586 0 0 0 10001000684B2300 0000000000000000 1 0 98 25 1352150 RECOVERING 0 226231 78 5586 0 0 0 30001900D6A11400 0000000000000000 1 0   SQL> SELECT segment_name, tablespace_name  FROM dba_rollback_segs  WHERE segment_id IN (98, 46); SEGMENT_NAME               TABLESPACE_NAME ------------------------------ ----------------------------...
Read more