Autobackup

How to Resolve RMAN-06509: only SPFILE or control file can be restored from AUTOBACKUP

by Ed Chen
June 14, 2023June 24, 2023

RMAN-06509 When we tried to restore a datafile from a backup piece in RMAN, we saw error RMAN-06509. RMAN> restore datafile 1 from '/home/oracle/datafile-0a1r6qon_1_1'; ...… Read More »

How to Resolve ORA-19697: standby control file not found in backup set

by Ed Chen
June 13, 2023June 24, 2023

ORA-19697 Tried to restore controlfile from a backup set by RMAN, but it failed with ORA-19697. RMAN> restore controlfile from '/home/oracle/031r656h_1_1'; ... ORA-19697: standby control… Read More »

How Oracle Backup SPFILE

by Ed Chen
May 29, 2023August 25, 2023

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 Resolve SPFILE in DB_UNKNOWN

by Ed Chen
June 23, 2019May 31, 2023

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 Change SPFILE Location in Oracle

by Ed Chen
February 23, 2019May 31, 2023
2 Comments

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 RMAN Restore Database from BackupSet

by Ed Chen
October 31, 2018May 31, 2023

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 to Configure AUTOBACKUP

by Ed Chen
December 27, 2012December 1, 2021

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 RMAN Backup Controlfile

by Ed Chen
December 27, 2012June 15, 2023

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 »

JavaScript is not enabled. Please enable it and reload the page.