How to apply archive logs manually in oracle 9i

Archived redo logs are integral to maintaining a standby database, which is an exact replica of a database. You can operate your database in standby archiving mode, which automatically updates a standby database with archived redo logs from the original database. See Also: Oracle Data Guard Concepts and Administration. Would this sequence be ok? 1. Use the SQL+ command ‘ARCHIVE LOG LIST’ to identify the ‘Oldest online log sequence’ 2. Do the cold backup 3. Delete all archive log files with a sequence number smaller than the ‘Oldest online log sequence’. Thanks, Tobias –.  · Log_archive_Start=True. Log_archive_dest_1=LOCATION=E:oracleora92RDBMSarchive. Log_archive_format=arc percnt;spercnt;t. Now go to sql prompt Select value from v$parameter where name=log_archive_start; Value ——-True Select name from v$archived_log: We get a list of Estimated Reading Time: 5 mins.

Copy the archive log file devdb12_1__arc manually from primary to standby archive destination location. Step 2. Run the below command in standby database. ALTER DATABASE REGISTER LOGFILE '/dbArch/oradata/devdb12/ devdb12_1__arc'; Step 3. Verify the standby database and see if the copied archive log file is applied. LOG_ARCHIVE_DEST = '/disk1/archive' LOG_ARCHIVE_DUPLEX_DEST = '/disk2/archive' Edit the LOG_ARCHIVE_FORMAT parameter, using %s to include the log sequence number as part of the file name and %t to include the thread number. Use capital letters (%S and %T) to pad the file name to the left with zeroes. For example, enter. Archived redo logs are integral to maintaining a standby database, which is an exact replica of a database. You can operate your database in standby archiving mode, which automatically updates a standby database with archived redo logs from the original database. See Also: Oracle Data Guard Concepts and Administration.

Oracle Database Tips by Donald BurlesonDecember 9, The log apply service reads archived log files from the directory specified by the. Mar 6, Standby site complains for missing Archivelog even if the file is Oracle 10g and above %t, %s and %r must be set, and if Oracle 9i is. Instructions on how to disable ARCHIVELOG mode status. Log in as OS user, oracle and enter the following commands: $ export ORACLE_SID.