![]() This setting will generate archived logs as follows for thread 1 log sequence numbers 100, 101, and 102 resetlogs ID 509210197. The following example shows a setting of LOG_ARCHIVE_FORMAT: LOG_ARCHIVE_FORMAT = arch_%t_%s_%r.arc See Oracle Database Backup and Recovery User's Guide for more information about this method of recovery. Specifying %r causes the database to capture the resetlogs ID in the archived redo log file name. The incarnation of a database changes when you open it with the RESETLOGS option. For example, this is the default format for UNIX: The default for this parameter is operating system dependent. If the COMPATIBLE initialization parameter is set to 10.0.0 or higher, the database requires the specification of resetlogs ID ( %r) when you include the LOG_ARCHIVE_FORMAT parameter. ![]() Use capital letters ( %T, %S, and %R) to pad the file name to the left with zeroes. Optionally, set the LOG_ARCHIVE_FORMAT initialization parameter, using %t to include the thread number as part of the file name, %s to include the log sequence number, and %r to include the resetlogs ID (a timestamp value represented in ub4). For example, enter: LOG_ARCHIVE_DEST_4 = 'SERVICE = standby1' If you are archiving to a standby database, then use the SERVICE keyword to specify a valid net service name. LOG_ARCHIVE_DEST_3 = 'LOCATION = +RECOVERY' LOG_ARCHIVE_DEST_2 = 'LOCATION = /disk2/archive' For example, enter: LOG_ARCHIVE_DEST_1 = 'LOCATION = /disk1/archive' Set the LOG_ARCHIVE_DEST_ n initialization parameter to specify from one to 31 archiving locations. Perform the following steps to set the destination for archived redo logs using the LOG_ARCHIVE_DEST_ n initialization parameter: The connect descriptor contains the information necessary for connecting to the remote database. If you specify SERVICE, supply a net service name that Oracle Net can resolve to a connect descriptor for a standby database. The keyword USE_DB_RECOVERY_FILE_DEST to indicate the Fast Recovery Area If you use the LOCATION keyword, specify one of the following:Ī valid path name in your operating system's local file system ![]() Remote archival through Oracle Net service name. LOG_ARCHIVE_DEST_ n = 'LOCATION=USE_DB_RECOVERY_FILE_DEST' LOG_ARCHIVE_DEST_ n = 'LOCATION=+DGROUP1' LOG_ARCHIVE_DEST_ n = 'LOCATION=/disk1/arc' The following table summarizes the archive destination alternatives, which are further described in the sections that follow.Ī local file system location or Oracle ASM disk group Any destination changes that you make take effect at the next log switch (automatic or manual). However, you can use the ALTER SYSTEM command to dynamically add or change archive destinations after your database is running. Typically, you determine archive log destinations during database planning, and you set the initialization parameters for archive destinations during database installation. See Oracle Database Backup and Recovery User's Guide for details about the Fast Recovery Area. The database uses the Fast Recovery Area to store and automatically manage disk space for a variety of files related to backup and recovery. If you want to archive to multiple destinations, then you can choose to archive to two or more locations using the LOG_ARCHIVE_DEST_n initialization parameters, or to archive only to a primary and secondary destination using the LOG_ARCHIVE_DEST and LOG_ARCHIVE_DUPLEX_DEST initialization parameters.įor local destinations, in addition to the local file system or an Oracle ASM disk group, you can archive to the Fast Recovery Area. If you want to archive to only a single destination, then specify that destination using the LOG_ARCHIVE_DEST initialization parameter. These redundant copies help ensure that archived logs are always available in the event of a failure at one of the destinations. When you archive to multiple destinations, a copy of each filled redo log file is written to each destination. Destinations can be local-within the local file system or an Oracle Automatic Storage Management (Oracle ASM) disk group-or remote (on a standby database). You can choose to archive redo logs to a single destination or to multiple destinations. Setting Initialization Parameters for Archive Destination s
0 Comments
Leave a Reply. |
Details
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |