archivelog

Rman backup of archives between two sequences

Below is the script for taking backup of archive log between sequence number 1000 to 1050 For standalone database: [crayon-5beb0ead36bb2411724389/] For RAC database: For RAC database, we need to menti...

ORA-19588: archived log RECID is no longer valid

PROBLEM: While taking rman backup, got below error. RMAN-00571: =========================================================== RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS =============== RMAN...

ORA-01126: database must be mounted in this instance and not open in any instance

PROBLEM: While enabling archive mode in database, got below error. SQL> alter database archivelog; alter database archivelog * ERROR at line 1: ORA-01126: database must be mounted in this instance ...

ORA-38774: cannot disable media recovery – flashback database is enabled

PROBLEM: While disabling archive log mode, got the error – ORA-38774   SQL> alter database noarchivelog; alter database noarchivelog * ERROR at line 1: ORA-38774: cannot disable media r...

How to enable/disable archive log mode in oracle database

   There are 2 types of logging mode in oracle database.   1. Archivelog mode In this mode, after the online redo logs are filled , it will move to archive location 2. Noarchivelog mode In this...

Skip to toolbar