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