oracleadmin

Learnomate Technologies > oracleadmin
How to put database in Archive/No-Archive log mode?- Oracle Interview question
11
Jun

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 […]

Posted in: Oracle DBA ,
Tags: How to put database in Archive/No-Archive log mode , oracle admin , oracle Database , Oracle DBA Scripts , Oracle Interview question , oracle training , oracleadmin ,
Alert log file in Oracle
10
Jun
Posted in: Oracle DBA ,
Tags: Alert Log File , AlertLogFileInOracle , oracle admin , Oracle DBA Scripts , oracleadmin ,
RMAN oracle database 12c backup script
06
Jun

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 […]

Posted in: Oracle DBA ,
Tags: backupScript , oracle , oracle12c , oracleadmin , oracledatabase , oracledba , RMAN , Script ,