Backup Oracle with RMAN

oracle_backup.md

Backup with RMAN

• Connect

cmd>set ORACLE_SID=DBSID
cmd>sqlplus sys/passwd as sysdba;

• Check for LOG_MODE

SQL>SELECT LOG_MODE FROM SYS.V$DATABASE;

• IF NOARCHIVELOG THEN

cmd>sqlplus sys/passwd as sysdba;
SQL>shutdown immediate
SQL>startup mount
SQL> startup mount
ORACLE instance started.

Total System Global Area  184549376 bytes
Fixed Size                  1300928 bytes
Variable Size             157820480 bytes
Database Buffers           25165824 bytes
Redo Buffers                 262144 bytes
Database mounted.

SQL> alter database archivelog;
Database altered.

SQL> alter database open;
Database altered.

• ELSE

cmd>rman target /
RMAN> list copy of archivelog until time 'SYSDATE-3';
RMAN> delete archivelog until time 'SYSDATE-3';//delete archivelog until sequence 999;

---