How can we specify the Archived log file name format and destination?

How can we specify the Archived log file name format and destination?
by

1 Answer

Answer :

By setting the following values in init.ora file. LOG_ARCHIVE_FORMAT =
arch %S/s/T/tarc (%S - Log sequence number and is zero left paded, %s
- Log sequence number not padded. %T - Thread number lef-zero-
paded and %t - Thread number not padded). The file name created is
arch 0001 are if %S is used. LOG_ARCHIVE_DEST = path.
by

Related questions

What is Archived Redo Log ?

Description : What is Archived Redo Log ?

Last Answer : Archived Redo Log consists of Redo Log files that have archived before being reused.

How does one backup archived log files? (for DBA

Description : How does one backup archived log files? (for DBA

Last Answer : One can backup archived log files using RMAN or any operating system backup utility. Remember to delete files after backing them up to prevent the archive log directory from filling up. If the ... oracle/arch_backup/log_t%t_s%s_p%p' 5> (archivelog all delete input); 6> release channel dev1; 7> }

What is Archived Redo Log?

Description : What is Archived Redo Log?

Last Answer : Archived Redo Log consists of Redo Log files that have archived before being reused.

What is meant by Redo Log file mirroring ? How it can be achieved?

Description : What is meant by Redo Log file mirroring ? How it can be achieved?

Last Answer : Process of having a copy of redo log files is called mirroring. This can be achieved by creating group of log files together, so that LGWR will automatically writes them to all the members ... . If any one group fails then database automatically switch over to next group. It degrades performance.

specify where to get the source and destination operands for the operation specified by the a. Operand fields and opcode b. Opcode and operand c. Source and destination d. Cpu and memory

Description : specify where to get the source and destination operands for the operation specified by the a. Operand fields and opcode b. Opcode and operand c. Source and destination d. Cpu and memory

Last Answer : a. Operand fields and opcode

To specify the number of decimal places in a cell the ……………… tab of the Format cells dialog is used. -Technology

Description : To specify the number of decimal places in a cell the ……………… tab of the Format cells dialog is used. -Technology

Last Answer : To specify the number of decimal places in a cell the Fill series tab of the Format cells dialog is used.

How would you force a log switch?

Description : How would you force a log switch?

Last Answer : ALTER SYSTEM SWITCH LOGFILE;

What is the use of redo log information?

Description : What is the use of redo log information?

Last Answer : The information in a redo log file is used only to recover the database from a system or media failure prevents database data from being written to a database's data files.

What is the function of redo log?

Description : What is the function of redo log?

Last Answer : The primary function of the redo log is to record all changes made to data.

What is a redo log?

Description : What is a redo log?

Last Answer : The set of redo log files for a database is collectively known as the database redo log.

What is On-line Redo Log?

Description : What is On-line Redo Log?

Last Answer : The On-line Redo Log is a set of tow or more on-line redo files that record all committed changes made to the database. Whenever a transaction is committed, the corresponding redo entries temporarily ... file by the background process LGWR. The on-line redo log files are used in cyclical fashion.

What is Log Switch ?

Description : What is Log Switch ?

Last Answer : The point at which ORACLE ends writing to one online redo log file and begins writing to another is called a log switch.

What is meant by redo log buffer ?

Description : What is meant by redo log buffer ?

Last Answer : Changes made to entries are written to the on-line redo log files. So that they can be used in roll forward operations during database recoveries. Before writing them into the redo log files ... buffers in SGA and LGWR will write into files frequently. LOG_BUFFER parameter will decide the size.

What is a SNAPSHOT LOG ?

Description : What is a SNAPSHOT LOG ?

Last Answer : A snapshot log is a table in the master database that is associated with the master table. ORACLE uses a snapshot log to track the rows that have been updated in the master table. Snapshot logs are used in updating the snapshots based on the master table.

What is snapshot log ?

Description : What is snapshot log ?

Last Answer : It is a table that maintains a record of modifications to the master table in a snapshot. It is stored in the same database as master table and is only available for simple snapshots. It should be created before creating snapshots.

When will the data in the snapshot log be used?

Description : When will the data in the snapshot log be used?

Last Answer : We must be able to create a after row trigger on table (i.e., it should be not be already available) After giving table privileges. We cannot specify snapshot log name because oracle uses the ... 23 characters. (The table name created will be MLOGS_tablename, and trigger name will be TLOGS name).

What is a Redo Log ?

Description : What is a Redo Log ?

Last Answer : The set of Redo Log files YSDATE,UID,USER or USERENV SQL functions,or the pseudo columns LEVEL or ROWNUM.

What is Mirrored on-line Redo Log ?

Description : What is Mirrored on-line Redo Log ?

Last Answer : A mirrored on-line redo log consists of copies of on-line redo log files physically located on separate disks, changes made to one member of the group are made to all members.

What are database files, control files and log files. How many of these files should a database have at least? Why?

Description : What are database files, control files and log files. How many of these files should a database have at least? Why?

Last Answer : ∙ Database Files The database files hold the actual data and are typically the largest in size. Depending on their sizes, the tables (and other objects) for all the user accounts can go in one ... or redo log file to the database, the information is recorded in the control files. ∙ Redo Logs

What is the purpose of Redo Log files?

Description : What is the purpose of Redo Log files?

Last Answer : Before Oracle changes data in a datafile it writes these changes to the redo log. If something happens to one of the datafiles, a backed up datafile can be restored and the redo, that was written since, replied, which brings the datafile to the state it had before it became unavailable.

Which log would you check if a database has a problem?

Description : Which log would you check if a database has a problem?

Last Answer : Alert log

Determine from the following the basic mode of transmission system in the public data network in which data are transferred from the source to the network and from the network to the destination in the frame format. A. Voice mode B. Asynchronous mode C. Synchronous mode D. Packet mode

Description : Determine from the following the basic mode of transmission system in the public data network in which data are transferred from the source to the network and from the network to the destination in the frame format. A. Voice mode B. Asynchronous mode C. Synchronous mode D. Packet mode

Last Answer : D. Packet mode

In 1-address format how many address is used both as source as well as destination: a. b. 9 a 1 2 3 4

Description : In 1-address format how many address is used both as source as well as destination: a. b. 9 a 1 2 3 4

Last Answer : 1

Assume a two address format specified as source, destination. Examine the following sequence of instruction and explain the addressing modes used and the operation done in every instruction?

Description : Assume a two address format specified as source, destination. Examine the following sequence of instruction and explain the addressing modes used and the operation done in every instruction?

Last Answer : 1. Move (R5) +, R0 2. Add (R5) +, R0. 3. Move (R0), (R5) 4. Move 16(R5), R3 5. Add #40, R5

How to search in an archived website?

Description : How to search in an archived website?

Last Answer : Maybe go further into the past?

Where can I watch archived NFL games?

Description : Where can I watch archived NFL games?

Last Answer : answer:Do a Google search or try to find .torrent files for it on sites like isohunt or piratebay. Not that I’m advising you to steal content.

Does anyone know of a good website that has archived radar loops 48-72 hours in length?

Description : Does anyone know of a good website that has archived radar loops 48-72 hours in length?

Last Answer : Forecasting would be A LOT easier if you could see the radar patterns over the last couple days. The weather forecast that says, High in the mid 80 with a 30% chance of showers doesn't cut it ... yesterday over Tennessee moving east towards North Carolina so I know if it's going to hit us or not.

Corrupt/Incomplete downloads of archived Tomcat versions?

Description : Corrupt/Incomplete downloads of archived Tomcat versions?

Last Answer : Gah! No help, eh? How bout this - attempt to download this - it should be ~10MB in size is it? - the filename should end with .tar.gz ... does it? - you should be ... archived version. - Mother bleeping sonuva beeyootiful crappity smackin' holy cat butter funky butt lovin' fiddlesticks!!!!!!!

Secondary/existing data may include which of the following? a. Official documents b. Personal documents c. Archived research data d. All of the above

Description : Secondary/existing data may include which of the following? a. Official documents b. Personal documents c. Archived research data d. All of the above

Last Answer : d. All of the above

Which attribute is used to specify the location of an image file in the <img> tag? Explain. -Technology

Description : Which attribute is used to specify the location of an image file in the tag? Explain. -Technology

Last Answer : The attribute you need to get an image to display on a Web page is the src attribute.In the src attribute of the tag, you can specify the path of the image that you want to add to the ... image somewhere else on the same server, or an image stored on another server.The syntax for src attribute is

…………. attribute is used to specify the location of an image file. (a) alt (b) src -Technology

Description : …………. attribute is used to specify the location of an image file. (a) alt (b) src -Technology

Last Answer : (b) src attribute is used to specify the location of an image file.

How can I dump an oracle schema to a LOCAL file over a network connection from sqlplus?

Description : How can I dump an oracle schema to a LOCAL file over a network connection from sqlplus?

Last Answer : By connecting and spooling are you excluding the exp/imp commands (or expdb/impdb in 10g)?

What are the minimum parameters should exist in the parameter file (init.ora) ?

Description : What are the minimum parameters should exist in the parameter file (init.ora) ?

Last Answer : DB NAME - Must set to a text string of no more than 8 characters and it will be stored inside the datafiles, redo log files and control files and control ... an ORACLE instance acquires at database startup. Also optionally LICENSE_MAX_SESSIONS,LICENSE_SESSION_WARNING and LICENSE_MAX_USERS.

What is a trace file and how is it created ?

Description : What is a trace file and how is it created ?

Last Answer : Each server and background process can write an associated trace file. When an internal error is detected by a process or user process, it dumps information about the error to its trace. This can be used for tuning the database.

What view would you use to look at the size of a data file?

Description : What view would you use to look at the size of a data file?

Last Answer : DBA_DATA_FILES

How do you resize a data file?

Description : How do you resize a data file?

Last Answer : ALTER DATABASE DATAFILE RESIZE ;

How do you add a data file to a tablespace

Description : How do you add a data file to a tablespace

Last Answer : ALTER TABLESPACE ADD DATAFILE SIZE

What command would you use to create a backup control file?

Description : What command would you use to create a backup control file?

Last Answer : Alter database backup control file to trace.

How do you switch from an init.ora file to a spfile?

Description : How do you switch from an init.ora file to a spfile?

Last Answer : Issue the create spfile from pfile command.

What is the use of control file?

Description : What is the use of control file?

Last Answer : When an instance of an Oracle database is started, its control file is used to identify the database and redo log files that must be opened for database operation to proceed. It is also used in database recovery.

What does a control file contains?

Description : What does a control file contains?

Last Answer : Database name - Names and locations of a database's files and redolog files. - Time stamp of database creation.

Table Space,Data Files,Parameter File, Control Files

Description : Table Space,Data Files,Parameter File, Control Files

Last Answer : Table Space :: The table space is useful for storing the data in the database.When a database is created two table spaces are created. a) System Table space :: This data file stores all the tables ... They contain the Db name, name and location of dbs, data files ,redo log files and time stamp.

Explain the following file extension related to library?

Description : Explain the following file extension related to library?

Last Answer : .pll,.lib,.pld The library pll files is a portable design file comparable to an fmb form file The library lib file is a plat form specific, generated library file comparable to a fmx form file The pld file is Txt format file and can be used for source controlling your library files Parameter

Write the Abbreviation for the following File Extension 1. FMB 2. MMB 3. PLL?

Description : Write the Abbreviation for the following File Extension 1. FMB 2. MMB 3. PLL?

Last Answer : FMB ----- Form Module Binary. MMB ----- Menu Module Binary. PLL ------ PL/SQL Library Module Binary.

What is a Control file ?

Description : What is a Control file ?

Last Answer : Database overall physical architecture is maintained in a file called control file. It will be used to maintain internal consistency and guide recovery operations. Multiple copies of control files are advisable.

What is the use of FILE option in IMP command ?

Description : What is the use of FILE option in IMP command ?

Last Answer : The name of the file from which import should be performed.

It is possible to use raw devices as data files and what is the advantages over file. system files ?

Description : It is possible to use raw devices as data files and what is the advantages over file. system files ?

Last Answer : Yes. The advantages over file system files. I/O will be improved because Oracle is bye-passing the kernnel which writing into disk. Disk Corruption will be very less.

How can a text file be attached to a report while creating in the report writer?

Description : How can a text file be attached to a report while creating in the report writer?

Last Answer : By using the link file property in the layout boiler plate property sheet.

What use of command line parameter cmd file?

Description : What use of command line parameter cmd file?

Last Answer : It is a command line argument that allows you to specify a file that contain a set of arguments for r20run.

How does one add users to a password file? (for DBA

Description : How does one add users to a password file? (for DBA

Last Answer : One can select from the SYS.V_$PWFILE_USERS view to see which users are listed in the password file. New users can be added to the password file by granting them SYSDBA or SYSOPER privileges, or by using the orapwd utility. GRANT SYSDBA TO scott;