Switching to Archivelog mode – Oracle 11g

-

Archivelog mode is a must for a production database as it ensures high recoverability of the database and provides greater flexibility to backup.
Its very simple to turn on archiveing of Redo logs in your database.
First step is check the log mode of the database.
There are two ways to check this.
First way is to query the column LOG_MODE from v$database.
sys@ORCL> select log_mode from v$database; LOG_MODE
------------
NOARCHIVELOG
sys@ORCL>
sys@ORCL> Second way is to use the command ARCHIVE LOG LIST sys@ORCL> archive log list
Database log mode              No Archive Mode
Automatic archival             Disabled
Archive destination            USE_DB_RECOVERY_FILE_DEST
Oldest online log sequence     51
Current log sequence           53
sys@ORCL>   Second step is to shutdown the database in consistent manner using any one the command such as SHUTDOWN , SHUTDOWN IMMEDIATE or SHUTDOWN TRANSACTIONAL sys@ORCL> shutdown immediate
Database closed.
Database dismounted.
ORACLE instance shut down.
sys@ORCL>
Mount the database instance sys@ORCL>
sys@ORCL> startup mount
ORACLE instance started. Total System Global Area  263639040 bytes
Fixed Size                  1373964 bytes
Variable Size             209717492 bytes
Database Buffers           46137344 bytes
Redo Buffers                6410240 bytes
Database mounted.
sys@ORCL>   Check whether the archive log parameters are set as per the requirement sys@ORCL>
sys@ORCL> show parameter log_archive_dest_1 NAME                                 TYPE        VALUE
------------------------------------ ----------- ------------------------------
log_archive_dest_1                   string      location=F:\app\FRA\orcl
log_archive_dest_10                  string
log_archive_dest_11                  string
sys@ORCL>
sys@ORCL> show parameter log_archive_dest_state_1 NAME                                 TYPE        VALUE
------------------------------------ ----------- ------------------------------
log_archive_dest_state_1             string      enable
log_archive_dest_state_10            string      enable
log_archive_dest_state_11            string      enable sys@ORCL>
sys@ORCL> show parameter log_archive_format NAME                                 TYPE        VALUE
------------------------------------ ----------- ------------------------------
log_archive_format                   string      ARC%S_%R.%T
sys@ORCL>
sys@ORCL>
Now alter the database to archive the redo logs.

sys@ORCL>
sys@ORCL> alter database archivelog
  2  ;
sys@ORCL>
sys@ORCL>
Check the log_mode now
sys@ORCL> select log_mode from v$database; LOG_MODE
------------
ARCHIVELOG
sys@ORCL>
You can now open the database for operation.




















Comments

Post a Comment

Popular posts from this blog

Current Variables in T24

-
CURRENT VARIABLE Introduction In addition to the system common variables that can be used in ENQUIRY and VERSION there is a feature where the user can populate a variable of their own and use it later. There are now a series of new system variables and a much wider option for users to create and use their own which are: CURRENT.CUSTOMER CURRENT.ARRANGEMENT CURRENT.EXTERNAL.USER These may be set on login by an external user and cleared when they logout. This means that ENQUIRY & VERSION can be tailored to accept the content of the variable instead of forcing a user to enter their own customer number or arrangement etc. Similarly in VERSION you can now default a field content by using the !CURRENT.CUSTOMER to populate a customer field with the current content of the variable. So the variable could be set in one Enquiry and used in either another Enquiry linked to it; or via VERSION to populate fields in an application triggered from the Enquiry. Note: ...
Read more

All accounting entries of an T24 account

-
There is a core routine that will return all the accounting entries for an account it is EB.ACCT.ENTRY.LIST Syntax: EB.ACCT.ENTRY.LIST(ACCOUNT.NUMBER,FROM.DATE,END.DATE,YID.LIST,OPENING.BAL,ER) Passed Parameters. ACCOUNT.NUMBER :- Account for which balance & entries is to be returned. FROM.DATE :- Start date for opening balance and entries. END.DATE :- The last date to be considered. Outgoing : YID.LIST :- List of statement entry ids. OPENING.BAL :- Opening balance on the startt date. ER :- Any errors found
Read more

SQL queries in JBase

-
The query Language of Jbase is really restrictive. Data analysis and comparison between two table is not possible without the use of spreadsheet software. I recently came to know that Jbase is providing a command called SQLSELECT through which you can actually issue SQL query command directly on Jbase tables. A sample would be like SQLSELECT * FROM FBNK.ACCOUNT WHERE SHORT_NAME LIKE '%PETER%' AND CATEGORY = 6601 Limitations: The command though have serious limitations such as  The table you query should not have dot charecter for example you cannot query FBNK.CUSTOMER.ACCOUNT with this command. But there is a workaround for the above drawback. Make a copy of the VOC record FBNK.CUSTOMER.ACCOUNT into a new one without ID in its ID. For Example: COPY FROM VOC FBNK.CUSTOMER.ACCOUNT,FBNK.CUSACC SQLSELECT * FROM FBNK.CUSACC; will work. The field name should not have dot character. You can overcome this by changing the dot character to underscore. For...
Read more