oracleadmin

seo, data, big data

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

Leave a Comment / Oracle DBA / By

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 :- In this type of logging whatever oracle writes in a redo log file related to transactions in database, saved to another location after …

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

RMAN oracle database 12c backup script

Leave a Comment / Oracle DBA / By

Change RMAN backup location configure channel device type disk format ‘/data/backup/%U’ maxpiecesize 2 G; SPFILE backups The SPFILE can be automatically backed up with the control file during database backups by configuring the CONTROLFILE AUTOBACKUP parameters To backup up the SPFILE explicitly use: RMAN> BACKUP SPFILE; Controlfile backups The current controlfile can be automatically backed …

RMAN oracle database 12c backup script Read More »