oracle 10gr2 - 10.2.0.5 on ASM
RHEL 5.8 64-bit
I just created a new database with custom settings. I set the "archive" location to "+RECOVERY/orcl/archivelog".
Would DBCA create the 'orcl/archivelog' directories automatically?
Or I will have to create the directories manually using ASMCMD?
When I use ASMCMD and look at the directories, I do not see these two.
I thought ASM may create them on the fly so I issued "alter system switch logfile" three times. The third time, it just kind of hangs and SQL prompt does not come back.
what DML normally occurs to ASM instance.
Please do not blame the gun that it hurts when you shoot yourself in the foot.
Problem Exists Between Keyboard And Chair!
I changed the default value from "+DATA" to "+RECOVERY/orcl/archivelog" because
- "+DATA" should not contain archivelog files.
- 2nd, there will be multiple database using same ASM instance/storage. So I want to keep the archivelog files separate for each database.
I used "orcl" just for the sake of example.
Looks like I have to create these directories manually.
I don't have a database running with ASM running at the moment around me so can't test what you posted. But it seems that you just made a directory in the ASM. For the archivelog, the default destination would be the FRA(Fast Recovery Area) so you should check the output of the command ARCHIVE LOG LIST and it should be set to the FRA. The reason that the db got hung was that it was waiting for the archive log of the previous log file to be generated.
The default location is the Fast Recovery Area, which requires db_recovery_file_dest and db_recovery_file_dest_size instance parameters.
I think let me rephrase my question.
If I am creating a Custom DB using DBCA and I specify a non-default ASM location in for archivelog files, do I need to create that location (directory) manually? Or DBCA will take care of it?
For example, default location displayed in DBCA is "+DATA". I change it to "+RECOVERY/<sid>/archivelog". Do I need to use ASMCMD and create the "<sid>" and "archivelog" folder manually?
If you are using OMF then you do not need to build any folder structures oracle will create the folder structure.
if you set +RECOVERY for your db_recovery_file_dest then Oracle will create the following for your archivelog location.
Thank you so much!