Hi,
SPFILE is not in use at the moment, and I set the following parameter to at least start the archivelog backups:
SQL> ALTER SYSTEM SET CONTROL_FILE_RECORD_KEEP_TIME=20; (As there is no catalog DB)
SQL> ALTER SYSTEM SET DB_RECOVERY_FILE_DEST_SIZE=200G;
SQL> ALTER SYSTEM SET LOG_ARCHIVE_DEST=' ';
SQL> ALTER SYSTEM SET DB_RECOVERY_FILE_DEST='d:\oradata';
Should I simply edit initDB.ora file and add these parameter there so that when next time DB is started these setting are made permanent by using initDB.ora auto.
# To add the following parameter in InitDB.ora:
CONTROL_FILE_RECORD_KEEP_TIME=20
DB_RECOVERY_FILE_DEST_SIZE=200G;
LOG_ARCHIVE_DEST=' ';
DB_RECOVERY_FILE_DEST='d:\oradata';
or there is any other way that I create SPFILE and use ALTER SYSTEM to make these changes permanent (WITHOUT RESTARTING THE DATABASE AT THE MOMENT), so that next time DB starts by default SPFILE will be used to start the DB and it will be started with these required parameters.
What do you suggest? First way that is using initDB.ora might not be great or recommended but looks more reliable for the changes I wanted to make, isn't it?
Thank you.
Best Regards