How to put database in Archive/No-Archive log mode?- Oracle Interview question

In this blog I will show you the importance of archive and no-archive log mode. Mode of Logging There are two types of logging modes in Oracle database :- 1. ARCHIVELOG :-... Read more »

Alert log file in Oracle

Lenovo Ideapad S145 AMD A6-9225 15.6-inch HD Thin and Light Laptop ( 4GB RAM / 1TB HDD / Windows 10 Home / Office Home and Student 2019 / Grey / 1.85kg ),... Read more »

RMAN oracle database 12c backup script

Oracle database RMAN level 0 backup script RUN { ALLOCATE CHANNEL MY_RMAN1 TYPE disk; ALLOCATE CHANNEL MY_RMAN2 TYPE disk; SETLIMIT CHANNEL MY_RMAN1 KBYTES 33554432; SETLIMIT CHANNEL MY_RMAN2 KBYTES 33554432; CONFIGURE RETENTION POLICY... Read more »