What would happen if the database name in the parameter file does not match the control file?
An instance would start, but the database would not be mounted. When a database is created, the database name is specified in the CREATE DATABASE command and it must match the DB_NAME parameter. The database will not mount if the database name recorded in the control file does not match the database name in the STARTUP command. • Evaluate this command: CREATE DATABASE prod MAXLOGFILES 5 MAXLOGMEMBERS 5 MAXDATAFILES 100 MAXLOGHISTORY 100 LOGFILE GROUP 1 ‘/disk3/log1a.rdo, /disk4/log1b.rdo’, GROUP 2 ‘/disk3/log2a.rdo, /disk4/log2b.rdo’ REUSE DATAFILE ‘/disk2/system01.dbf’ SIZE 50M; Which line will return an error under any condition? ==> GROUP 1 ‘/disk3/log1a.rdo, /disk4/log1b.rdo’, For any datafiles or redo log files that already exist, use the REUSE option in the CREATE DATABASE command. If the file does not exist, you must use the SIZE option to specify the size of the file to be created either in kilobytes (K) or megabytes (M).
Related Questions
- Does the replacement for PRTDOC support the OUTFILE parameter (which allows output to be written to a database file instead of a spooled file)?
- How to determine the Redo Log File size using the Sizing Advice by using the EM Database Control?
- What would happen if the database name in the parameter file does not match the control file?
