Problem description:
According to the needs of the business needs to open the database file, by performing the following statements open the database file
Sqlplus> Startup the mount; (database in the mount)

Sqlplus> The alter database archivelog; (start the database archive)

Sqlplus> The alter system set log_archive_dest_1="/arch" (change the archive log path, Windows system using drive)

Sqlplus> alter database open; (open database)

Sqlplus> archive log list; (see the file is already open)

After open in my archive directory query found a large number of DBF file, with a dozen or so per minute, each about 45 m, about one minute a G, cause I can't open, and closed the archive in a moment, this is what problem, have a great god can help it?

CodePudding user response:

Why is DBF file, and a minute a g volume is too big

CodePudding user response:

1. Your business is so big?
2. You can analyze, whether due to a bug

CodePudding user response:

I find the unit a great god saw, that have big transaction is running normally, and the application, but application is also only one, nor the DML, just query, business is not so big, two data exchange program is running, so confused, first encountered this problem, should not be. DBF file?

CodePudding user response:

A minute, a G less sure not less, to see what kind of system you
As for the archive file name, you can see this parameter: log_archive_format

CodePudding user response:

The alter system set log_archive_dest_1="location=/DSG/arcorcl", this is to change the path of the statement, I need to adjust the file archive directory path to arcorcl, finally the directory name must be archive_log?