QUES1.The error when table area overflows?
ANS:ORA-1653 (table) and ORA-1654(index)
QUES2.what Action is taken when table space is full?
ANS:add a new data file or extend the existing table space.
QUES3.What happens when table area of ORACLE exceeds?
ANS:The ABAP program Short dumps and The error message is written in the Syslog file.
QUES4.Response for MAXEXTENT error?
ANS:The MAX extent value is increased. The size of next extent is changed. The table is reorganized and extent is integrated.
5.What error occurs when number of extent reaches the maximum limit? ANS:ORA-1631 (table) and ORA-1632(index).
6.Start parameter of ORACLE?
ANS:Nomount: OS resource is made the data base instance, and is allocated according to composition information on init.ora and is mount: The control file of the data base has not been done open as for the data base file that OPEN is done and log yet and is open: A file all the data base systems is done and open is done.
QUES7.Stop parameter of ORACLE?
ANS:Normal: It is not possible to log it on newly. After all users logoff, the data base is ended. The correspondence of data is maintained and is immediate: Only a current command is executed. The transaction to which all sessions are ended and opened by PMON is done the roll backing and is abort: The transaction which the urgent data base shutdown and opens does not have the correspondence of data that the roll backing is not done. When being start next time, SMON takes the correspondence.
QUES8.Purpose of sapbackup?
ANS:Place where action detailed log of brbackup is stored. It restores it as brrestore refers to this information when restoring it.
9.Purpose of sapreorg?
ANS:Place used by DB when database management tool of SAP is temporarily reorganized or executed.
QUES10.Purpose of saparch?
ANS:Directory which preserves detailed log of action when brarchive is executed. When restoring it, it restores it as brrestore refers to this detailed log.
QUES11.The one backed up by an off-line full backup?
ANS:Detailed log of copy (init.ora,init.dba,init.sap) of control file, data file, online redo log, and profile and brarchive, summary logs (back.log), Central logs (reorg.log), and structural logs(struct.log)
QUES12.The one backed up by an online full backup?
ANS:Detailed log of copy (init.ora,init.dba,init.sap) f control file, data file, and profile and brarchive, summary logs back.log), Central logs (reorg.log), and structural logs(struct.log)
QUES13.The file backed up by off-line REDO log backup (BRArchive)?
ANS(I):Copy (init.ora,init.dba,init.sap) of off-line REDO log file profile. (II):Detailed log, summary log (arch.log), Central log (reorg.log), and structural log of brarchive(struct.log)
QUES14.Notes when online is backed up?
ANS:It makes it to the archive log mode.
QUES15.Is there a problem in sapdata(n) for raid1 of raid5 and origlog?
ANS:It is unquestionable. (It is unquestionable for the use of RAID5 to the data file though RAID5 cannot be used for the log file. )
16.Are origlogA, B, and mirrlogA and B made the same disk and is there a problem?
ANS:OriglogA, mirrlogB & origlogB, mirrlogA, and decentralized arrangement are preferable.
17.When the REDO log is mirrored, the writing order?
ANS:The mirror is a backup after the original.
18.It is disk arrangement and consideration?
ANS:The combination of SWAP, the data file, SWAP, and LOG causes a remarkable performance decrease. You should arrange/usr/sap and SWAP on the same disk.
QUES19.Which is the disk layout with high availability?
ANS:The REDO log is used and RAID5 is used for RAID1 (mirroring) and sapdata1-n.
QUES20.Which is it should the consideration of the performance?
ANS:OS swap area sapdata1-6saparchoriglogA, BmirrlogA, and B.
QUES21.The action method where no adjustment of DB is generated while executing the backup?
ANS:The DB instance is reorganized from SAPDBA when reactivating reactivating shutdown abort doing DB, and no adjustment is canceled.
QUES22.The situation of “danger of archive stuck"
ANS:There is little empty area in the archive log area.
QUES23.Error situation of error message “file not found…Control files"?
ANS:DB does not open it because it damaged one of the control files.
QUES24.Error situation of error message “oracle not available"?
ANS:DB is not opened.
QUES25.Place where off-line REDO log is preserved?
QUES26.How do it become it when/saparch becomes full?
ANS:Neither the archives tuck nor DB move, and R3 cannot be used. LGWR and DBWR stop ARCH's stopping, and continuously.
QUES27.The method of evading archiver stack?
ANS:Archive_function=copy_delete_save=-cds which does backup execution with brarchive REDO and deletes log (Empty capacity in saparch is increased).
QUES28.The size of saparch directory?
ANS:1GB at this 300MB operation when installing it.
QUES29.The file restored when full restore/recovery is done?
ANS:Oracle initialization file, control file, and data file
QUES30.The file of the parameter of BRBACKUP and BRRESTORE?
QUES31.The name of the profile of ORACLE?
QUES32.Where is it?
ANS:?/oracle//dbs(UNIX) ?oracledatabase (NT).
QUES33.By what authority (user) is R/3 connected with ORACLE?
QUES34.Which is correcting in the place of alert_.log?
QUES35.What information is recorded in it?
ANS:Alert log of oracle
QUES36.Parameter changed to enhance shared memory area (SGA?
QUES37.The one not changed by profile parameter of Oracle?
QUES38.What check does SAPDBA-check do?
ANS:(I)Full loading level of table area.
(II)Check on check, physical adjustment (availability of data file, control file, and REDO log file), and peculiar data base troubles to R/3 environment of important error message and init.ora profile parameter of extent and alert log in table/index
QUES39.What can you do in sapdba-next?
ANS:The best NEXT value of table/index is set.
QUES40.What do you understand from sapdba-analyze?
ANS:Level of internal fragmentation of table/index of storage area allocation information (table: When the difference between EMPTY and NEVER_BEEN_USED is great, it is an internal fragmentation indices: When the difference between USED_BY_BTREE and USED is great,internal fragment. )
QUES41.Can the log of sapdba be made where?
QUES42.Which is work with a preferable thing that the system administrator regularly executes?
ANS:1 Sapdba-check2 sapdba-next3 sapdba-checkopt/-analyze or - Statistics
QUES43.Which is the sapdba command of the statistical information update?
ANS:1 It is sapdba-chkopt PSAP%2 sapdba-analyse DBSTATCO3
sapdba-statistics1+2 or thirdly possible. One hoists the flag for the table that there is a change in the structure. Two issues the ANALYSE command to the table selected by one. It is possible to schedule it on DB13. The one correct as for update of statistical information Neither the penetration table nor the cluster table are objects.
QUES44.Does the correct one : about the R/3 naming rule?
ANS:It is defined in various functions of R/3 fixing, and the changed thing is discovered in this which cannot be done and the user or more can discover the log and the message immediately.
QUES45.Which description is correct in the installation of R/3 and ORACLE?
ANS:A lot of table areas are made by the custom of the name of R/3 putting.
QUES46.For custom of name of R/3 putting?
ANS:(i)Because it is a universal part of a variety of R/3 tools, it is not possible to change arbitrarily. It is useful though the user quickly finds the log and the message.
(ii)Because operating the data base of B R/3 by which any A RAID improves the security at the R/3 system failure with RAID causes the decrease in the performance, an appropriate description cannot be recommended. Only the area of the data base of C R/3 recommends RAID. The log area should not apply RAID by occasion of on the performance.
QUES47.Which is the parameter which can be changed and reflected while R/3 is operating?
ANS:Kind and number of specific parameter work processes to divide R/3 main storage area
QUES48.Where is information on the cause obtained when R/3 does not start?
ANS:Startsap.logSTART_DVEBMGS00_.log developer trace
QUES49.The Central instance name of system ID:C11 and system ID:01?
QUES50.When is the log written by updating data?
ANS:Before it updates it
QUES51.Which is the backup method of the support with sapdba?
ANS:Two-step (i)(To the tape previously for the disk), the online adjustment backup (off-line REDO backup + log), and the partial data base backup. (Difference backup)
(ii)Backup (Only the table area :) and standby DB only of the fact sheet area. (It keeps sending saparch to the standby system. )
QUES51.The correct one is chosen about the One-Run policy?
ANS:The start from sapdba is improper though it is possible to start from can the use of it is necessary to install on one tape and two or more tape devices and DB13 because the tape cannot be exchanged.
QUES52.Method of inspecting block damage (ORA-1578)?
ANS:brbackup -w use_dbvbrbackup -w only_dbv.Use_dbv: After the backup of the data base, the check on the ORACLE block structure with tool DB_VERIFY of Ristoa and Oracle to the directory is temporarily executed. - only_dbv: An online of block structure of the data base file check is executed by DB_VERIFY without backing up.
QUES53.According to which timing does ORACLE go to DB for writing?
ANS:Data to which DBWR is changed is written in the data file when reaching the checkpoint.
QUES54.Relation of operation of DBWR, LGWR, ARCH, and CKPT?
ANS:To speed up writing CKPT-checkpoint where online REDO log file is written in off-line REDO log file when ARCH-log switch which writes the LGWR-REDO log file to write the changed data in the data file in online REDO log file occurs when reaching DBWR-checkpoint.
QUES55.When is online REDO log written by the data update?
ANS:Before it updates it
QUES56.What should I do after enhancing the table area with sapdba? Backup
QUES56.The table of attribute without record in data base?
QUES57.Kind of reorganization of index?
ANS:Alter index rebuild:It is copied onto the corresponding table area after the index is restructured in a temporary area, and the effort of having making is done. It is effective to shortening time when only the index is reorganized. Recreate index that safety is the highest: After the index is deleted, it registers again.
QUES58.Kind of reorganization of table?
ANS:Create table as select: After a new table is made by a new name, data is copied directly from an old table. After an old table is deleted, the name of a new table is changed. Afterwards, INDEX and GRANT are made, and statistical information is generated. Maximum speed. (It is unavailability in case of the reorganization of , table area and the data file for the table with the long row. )
(i)Safety is the highest. - Reorganization to the table with the SAP load/SQL*Loader:long row is simplified compared with exp/imp. It is more high-speed than export/import. (Size 2G of the file is an upper bound because there is no chop option. )
(ii)As well as SAP load/unload:SAP load/SQL*Loader. Safety is high in the second.
(iii)Oracle export/import: Data is made, and an old table is Rinamed after EXPORT, and the object table new is made. Data is deleted and after the import, the Rinamed old table is deleted. The statistical information after INDEX is made is generated (For DropTab-deffer). Data is deleted and after EXPORT, an old table is deleted. After the object table is newly made, data is generated, and the import doing and INDEX are made, and statistical information is generated (For DropTab-nomal).
QUES59.The directory at DB reorganization?
QUES60.Do when you reorganize DB?
ANS:When a heavy fragmentation of the disk hot spot (bias of the disk access) and indices has been generated when DB paraphrases it to MAXEXTENT when a reaching empty area also has caused the fragmentation.
QUES61.The method of evading DB reorganization?
ANS:Sapdba-next is regularly executed and the table area where a lot of extent is prevented being allocated is enhanced. (The data which became unnecessary is done in the archive, and the number of files of DB is prevented from approaching DB_FILES. )
QUES62.What is possible by the DB reorganization?
ANS:1. 2 to which the block use for the object is optimized . 3 which can decrease the extent which exists in the data base . 4 which can minimize a necessary storage area for the object . Two or more data files are merged with one. (The number of data files is suppressed to the minimum. )
QUES63.What are partial Ristoa and complete recovery?
ANS:When online REDO log file becomes complete, and online REDO log file is not broken, it is recovered in the state immediately before the error occurs. It is done to SCN (The system change number ??? counter that +1 is done in COMMIT and the checkpoint) as which all data files are the same.
QUES64.What is data base reset?
ANS:It is not necessary to recover, and data until generating the error disappears after taking a complete backup because it does complete Ristoa from a complete backup. It does not consist if the backup is not taken immediately before.
QUES65.What are complete Ristoa and recovery (The recovering point: Point-intime recovery)?
ANS:Here when backup is not taken immediately before. Complete Ristoa is done from a complete backup. In addition, it returns it in either of state of the adjustment to present at time. The standard uses SCN or LSN (The log order number ??? counter that +1 is done at the log switch) or time. A part of data disappears without fail without fail, and open is done with alter database resetlogs open as long as complete recovery is not executed. Afterwards, it is necessary to take the full backup at once.
QUES66.File name of control file?
QUES67.What is the Oracle cost base optimize?
ANS:The function to decide the best access passing is accessed to data which is necessary based on the cost (accessed number of blocks) reading a little number of blocks to become it.
QUES68.There is no data or nor off-line REDO log backup which can be used?
ANS:Data base reset or the Point-in-Time recovery is used.
QUES69.There are neither BRBACKUP nor BRARCHIVE log which can be used?
ANS:The function of SAPDBA is used and Ristoa of an individual file is used.
QUES70.There is no init.ora file which can be used?
ANS:It is brrestore-n init_ora and Ristoa from the tape as for the file.
QUES71.The control file is damaged?
ANS:One of mirrors is copied.
QUES72.A control file and online REDO log file are completely damaged?
ANS:Refer to online HELP. By the date of the backup selected when the reorganization of the table area by the data file is included in the recovery executed when there is no off-line REDO log file for which the backup from which recovery is not permitted as follows in SAPDBA is not specified using open resetlogs at the end when it is old at time when the data base was opened.
ANS:SAPDBA is used.
Command brbackup-a DB13
It is not possible to do.
(ii)Online adjustment backup
brbackup -t online_cons(Online REDO is used after the backup ends and because copy.BRARCHIVE does not move in switch doing and off-line REDO, <-> cds etc. cannot be used.)
It is possible to do.
(iii)Partial data base backup
All off-line online REDO logs generated after it backs up the oldest are.