All of these prerequsites must be fulfilled before creating and using Dbvisit StandbyMP Configuration for Oracle database
...
Having 2nd redo thread is allowed only for RAC databases (excluding SEHA) and this second thread must have valid archived log sequence. Run this select on your primary database and check the result:
| Code Block |
|---|
select distinct(thread#) from v$log; |
The If you have SEHA or single instance database, you must have only one thread in your primary database, so the result must be only one row with value 1 for non-RAC databases. If you have RAC primary database, the result must be two rows with values 1 and 2.
7. Cleanup Standby Server
...
If you don’t want to use RMAN for deletion for any reason (for example database can’t be started) you will have to cleanup all locations manually
| Note |
|---|
Take special care to cleanup all files in db_recovery_file_dest. This is especially important for standby servers with ASM storage. |
if you didn’t use RMAN, delete manually the spfile as well
...