archivelog

how to change archivelog destination in oracle

If your present archivelog mountpoint is FULL or for any other reason, you want to change the archivelog destination in the database, then follow the below steps. NOTE – > It can be done ,whe...

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: RMAN> backup format '/archive/%d_%s_%p_%c_%t.arc.bkp' archivelog from sequence 100...

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...