Backup and Restore ARCHIVELOG

• BACKUP ARCHIVELOG

RMAN> backup format '/home/oracle/back/back_for_stbydf_%s_%p.back' archivelog sequence 188168 thread 2;
OR
RMAN> backup format '/home/oracle/back/back_for_stbydf_%s_%p.back' archivelog from sequence 189118 until sequence 189143 thread 2;

 

RMAN> list backup of archivelog from sequence 189118 until sequence 189143 thread 2;

 

• RESTORE ARCHIVELOG

RMAN> catalog start with '/home/oracle/back';
RMAN> restore archivelog sequence 188168 thread 2;
OR
RMAN> restore archivelog from sequence 189118 until sequence 189143 thread 2;

Restore and Recover

ORACLE_BASE=/oracle; export ORACLE_BASE
ORACLE_HOME=$ORACLE_BASE/product/11.2.0.4/db_1; export ORACLE_HOME
ORACLE_SID=TSTDB; export ORACLE_SID

RMAN>startup nomount pfile='/oracle/product/11.2.0.4/db_1/dbs/initTSTDB.ora';
RMAN>restore controlfile from '/home/oracle/TSTDB/autobackup/2021_05_15/o1_mf_s_1072634365_j9zm5p0p_.bkp';
RMAN>alter database mount;
RMAN>run {
restore database;
switch datafile all;
set until sequence 60951;
recover database;
}
RMAN> alter database open resetlogs;