如何转换init.ora到spfile？解答：使用create spfile from pfile 命令。
如何转换init.ora到spfile？解答：使用create spfile from pfile 命令。
相关考题：
After you have restored and recovered a database to a new host by using a previously performed Recovery Manager (RMAN) backup, which is the best option you would consider for the new database?() A. Opening the database in RESTRICTED modeB. Opening the database with the RESETLOGS optionC. Setting a new DBID for the newly restored databaseD. Restoring the server parameter file (SPFILE) to the new host
Which three types of files can be automatically placed in the flash recovery area (fast recovery area in 11g Release 2)?() A. Alert log fileB. Archived redo log filesC. Control file autobackupsD. Server Parameter file (SPFILE)E. Recovery Manager (RMAN) backup piece
Tomakeauditinformationmoreproductive，theDBAexecutesthefollowingcommandbeforestartinganauditoperation：SQLALTERSYSTEMSETAUDIT_TRAIL=DB，EXTENDEDSCOPE=SPFILE；WhichstatementistrueregardingtheauditrecordgeneratedwhenauditingstartsafterrestartingThedatabase（）A.ItcontainsonlytheplanfortheSQLstatementexecutedbytheuser.B.ItcontainstheSQLtextexecutedbytheuserandthebindvariablesusedwithit.C.ItcontainstheplanandstatisticsassociatedwiththeSQLstatementexecutedbytheuser.D.ItcontainstheplanfortheSQLstatementexecutedbytheuserandthebindvariablesusedwithit
WhichtwostatementsaboutAutomaticStorageManagement(ASM)aretrue?() A.ASMprovidesmirroringonfilebyfilebasis.B.ASMprovidesautomaticloadbalancingacrossallASMdisks.C.ASMsupportstheOracledatabaseandoperatingsystemfiles.D.ASMcanbeusedtostoretracefiles，alertlogfiles，andtheserverparameterfile（SPFILE）.
Which three types of files can be automatically placed in the flash recovery area (fast recovery area in 11g Release 2)?() (Choose three.) A. Alert log fileB. Archived redo log filesC. Control file autobackupsD. Server Parameter file (SPFILE)E. Recovery Manager (RMAN) backup piece
ViewtheExhibitandnotethefilesavailableinthe$ORACLE_HOME/dbsfolder.TheASMinstanceisalreadyrunning.Youusedthefollowingstepstostartthedatabaseinstanceandopenthedatabase：Whichfileisusedtostarttheinstanceinthiscase（）A.init.oraB.spfile.oraC.initorcl.oraD.spfile+ASM.ora
YouaremaintainingyourdatabaseinOracle10g.YouareperformingthebackupbyusingtheBACKUPASBACKUPSETcommandattheRMANprompt.WhichfilecannotbebackedupbyusingtheBACKUPASBACKUPSETcommand?() A.DatafilesB.CurrentcontrolfileC.Serverparameterfile（spfile）D.Passwordfile
WhataretheprerequisitesforenablingFlashbackDatabase?() A.ThedatabasemustbestartedintheMOUNTEXCLUSIVEstate.B.Thedatabasemusthavemultiplexedcontrolfiles.C.Thedatabasemustbeopenedbyusingatext-basedparameterfileinsteadofaserverparameterfile（SPFILE）.D.ThedatabasemustbeinARCHIVELOGmode.E.ThedatabasemustbeintheNOMOUNTstate.F.ThedatabasemustbeopenedinRESTRICTEDmode.
数据库参数文件的执行优先级由高到低是:() A. SpfileSID.ora ->initSID.ora ->spfile.ora - init.oraB. InitSID.ora ->spifleSID.ora ->init.ora ->spfile.oraC. SpfileSID.ora->spfile.ora->initSID.ora ->init.ora