RMAN

How to Resolve ORA-19602: cannot backup or copy active file in NOARCHIVELOG mode

Posted on
Found ORA-19602 When I tried to backup a NOARCHIVELOG database in MOUNT state, I got ORA-19602 like the following case: RMAN> startup mount; … RMAN> backup database tag ‘20190416-before-yearly-import’; Starting backup at 16-APR-19 using target database control file instead of recovery catalog allocated channel: ORA_DISK_1 channel ORA_DISK_1: SID=393 device type=DISK channel ORA_DISK_1: starting full datafile […]
Administration

How to Move Oracle Database

Posted on
Actually, this topic “How to Move Oracle Database” follows my previous post: How to Move ORACLE HOME. But I think it can be used in any moving operations. Generally speaking, this post will include the following subtle topics: How to move spfile How to move control files How to move database files How to move […]
Redo Log File

How to Resize Redo Logs in Oracle

Posted on
Resize Redo Logs The default size of redo logs during installation is 50MB which is too small for production databases. Of course, you can change the size of redo logs for your needs in DBCA if you know where to make the change. As for the databases that you took over from other DBA, 50MB […]
Backup and Recovery

When Database is Not Consistent

Posted on
There are several different kinds of situation when you recover a database with inconsistent states among files. In the following, I have to assume that you can mount the database without question.Data files are consistent, but controlfile is advanced.Do you have all required logs? If you have both archived logs and redo logs, then you […]
Archived Log File

How to Determine Archived Log Size

Posted on
Archived Log Size Before determining archived log size, you have to know that archived logs are derived (retired) from online redo logs switching. That is, you are not determining archived log size, in fact you are determining online redo log size. But now the question is: How to set a proper and optimal size for […]
Backup and Recovery

When Redo Log Files Are All Missing

Posted on
If your redo logs are all missing, then you have to know you will lose some data and no longer to recover it. Now let’s mount the database, I mean you can only startup the database to mount state, and let the control file knows all the situation.SQL> startup mount;ORACLE instance started….Database mounted.Recover the database […]