How to Backup SPFILE
Timings to Backup SPFILE In case that we need to restore SPFILE to the original state at a later time, we should backup SPFILE in… Read More »How to Backup SPFILE
Autobackup
How to Resolve SPFILE in DB_UNKNOWN
SPFILE in DB_UNKNOWN When I tried to restore SPFILE to the default location at nomount state, I found that SPFILE was restored to a DB_UNKNOWN… Read More »How to Resolve SPFILE in DB_UNKNOWN
How to Change SPFILE Location in Oracle
ALTER SYSTEM SET SPFILE Before reading, you have to know that there's no ALTER SYSTEM SET SPFILE statement in Oracle, because we can never write… Read More »How to Change SPFILE Location in Oracle
How RMAN Restore Database from BackupSet
In this post, I will show you how to restore a single-instance database from a backup set by RMAN. For RAC restoration, you may check… Read More »How RMAN Restore Database from BackupSet
How to Configure AUTOBACKUP
Check AUTOBACKUP ON The default configuration of AUTOBACKUP is ON in RMAN. For those databases which are disabled, we can enable it like this: RMAN>… Read More »How to Configure AUTOBACKUP
How RMAN Backup Controlfile
Backup Controlfile Since the controlfile is a very busy file on reading and writing when your database is open, you can't copy the file directly… Read More »How RMAN Backup Controlfile