Skip to main content

Alter System ‘SWITCH LOGFILE’ vs ‘ARCHIVE LOG CURRENT’

Both the command is used to force the log switch but they do it in different way. ARCHIVELOG CURRENT waits for the writing to complete. This can take several minute to complete for large redologs file where as SWITCH LOGFILE is fast as it does not wait for the archiver process to complete writing the online redologs.
The ‘ARCHIVELOG CURRENT’ command is safer because it waits for OS to acknowledge that the redolog has been successfully written. Hence this command is best practice for production backup script for RMAN.
The ‘ARCHIVELOG CURRENT’ allows, you to specify the thread to archive (If you do not pass the thread parameter then oracle will archive all full online redo logs) where as ‘SWITCH LOGFILE’ archives only the current thread.
Note: In case of RAC environment, the ‘ARCHIVELOG CURRENT’ will switch the log of all nodes (instances) where as ‘SWITCH LOGFILE’ will only switch the log file on the instance where you issue this command.

SWITCH LOGFILE’ is not a correct method after hot backup


In order to be sure that all changes generated during a hot backup are available for a recovery, Oracle recommends that the current online log be archived after the last tablespace in a hot backup is taken out of backup mode. A similar recommendation stands for after a recovery manager online database backup is taken.

Comments

Post a Comment

Popular posts from this blog

Changing National Character Set AL16UTF16 to UTF8

Changing National Character Set AL16UTF16 to UTF8 The national character set is used for data that is stored in table columns of the types NCHAR, NVARCHAR2, and NCLOB.  In contrast, the database character set is used for data stored in table columns of the types CHAR, VARCHAR2 and CLOB. Like the database character set, the national character set is defined when the database is initially created and can usually no longer be changed, at least not easily or without involving quite a lot of work (export, recreate database, import). Except when creating the database, where the national character set is defined explicitly, it can change implicitly even when upgrading the database from Oracle8i to Oracle9i (or Oracle10g). You require SYSDBA authorization to change the national character set. Changing the national character set means changing an Oracle Dictionary entry, but no data is changed.  $sqlplus /nolog SQL> CONNECT / AS SYSDBA SQL> Select property_...
Post a Comment
Read more

How to Monitor RMAN Backup through SQL Query

To Monitor RMAN you can use OEM or any other tools such as "Quest Backup Report for Oracle". You can also used following Views in oracle 9i to check the RMAN backup status: v$rman_configuration v$backup_set v$backup_piece v$backup_spfile v$session_longops Script to check RMAN Configuration: SELECT  name "PARAMETERS", value "RMAN CONFIGURATION" FROM  v$rman_configuration ORDER BY name; PARAMETERS RMAN CONFIGURATION BACKUP OPTIMIZATION ON CHANNEL DEVICE TYPE DISK FORMAT   'H:\ORABACK\%U' CONTROLFILE AUTOBACKUP ON CONTROLFILE AUTOBACKUP FORMAT FOR DEVICE TYPE DISK TO 'H:\ORABACK\%F' DEFAULT DEVICE TYPE TO DISK RETENTION POLICY TO RECOVERY WINDOW OF 30 DAYS Script to List RMAN Backup Piece: SELECT bs.recid, DECODE(   bp.status, 'A', 'Available', 'D', 'De...
Post a Comment
Read more

How to Remove Oracle services from Windows

How to Remove Oracle services from Windows If you have uninstall the Oracle software from your system, but, the services are not removed. This resulted, when you are trying to install oracle back and trying to configure your Instance as old name is not allowed. Method1: To remove OracleService , go to the command prompt and type: oradim -delete -sid <SID> where SID is the sid of your database, as it appears when you type net start | more (you should get an "OracleServiceSID") Method2: If you have the resource kit, you can use delsrv.exe to remove the listener service. If you don't have the resource kit, you can download delsrv.exe from Microsoft Support: http://www.microsoft.com/windows2000/tec… Method3: Go to Registry (Type regedit on RUN) Take a backup of Registry. (For the backup Click on file menu on Registry and export your registry backup any location so whenever required you can import your old registry.) Now go to registry HKEY_L...
Post a Comment
Read more