I am using oracle 19c on windows.
On our test environment, we enabled archive log mode, but did not enable flashback. we created guarantee restore point, for we just need to use flashback database to restore point CLEAN_DB so we don' t need to enable flashback.
After we restored restore point I found in the fast recovery area under Flashback folder it created a lot of .flb files, that almost make my FRA full. what are these flashback files for, they are created after I restored the restore point. We did not enable flashback.
Another related question:
I flashback the database to restore point CLENA_DB in the startup mount mode, can I do a drop restore point, and then change it to noarchivelog mode right after restored the retore point in the same startup mount mode? if this is not a good practice, what it should be ?
Thanks!