ARchivelog Noarchivelog simply explained

Archivelog Mode – Oracle saves filled redo logs in archivelog mode. If we are running the database in archivelog mode, we can recover the database to any point in time using the archived logs. Production systems are run in archivelog mode. This is a mandate prelimiary requirement needed for performing hot backup in Oracle databases. The hot backup can be use managed hot backup as well as utilization of oracle supplied utility RMAN
Noarchivelog Mode – Filled redo logs are overwritten and not saved. We can recover only from the crash of a database instance. It is not the recommended method to run an oracle database. In no archivelog mode database is unsafe. This is typically recommended in cases when database critical is very minimal, data loss can be compromised, there is no sufficient disk space to store archived redo logs. When the database runs in noarchivelog mode periodically we should bring down database, perform cold copy of database folder

Free Oracle Database Articles, Tips, Jobs :

Delivered by FeedBurner

Grant RECOVERY_CATALOG_OWNER to resolve RMAN-04004

There are two major steps in using a recovery catalog in oracle database 
1) Create recovery catalog schema in the database – This includes creating a separate tablespace for recovery catalog (if not created SYSTEM tablespace will be taken by default), create a recovery catalog schema user, assign RECOVERY_CATALOG_OWNER privilege to the schema user
2) Create the recovery catalog – Connect to the recovery catalog as recovery catalog user, create catalog
I was doing the first step of creating recovery catalog schema. I wanted to check what happens if RECOVERY_CATALOG_OWNER privilege is not granted to the schema user. I got this error
First create a tablespace to avoid using default SYSTEM tablespace
SQL> create tablespace reccat datafile ‘loc.dbf’ size 50M;
Tablespace created.
Its time to create the schema user and grant quota on the tablespace to this user
SQL> create user rman identified by password temporary tablespace temp default table space reccat quota unlimited on reccat;
User created.
Now I connected to RMAN. I try connecting to recovery catalog
RMAN> connect catalog rman/password
RMAN-00571: ===========================================================
RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
RMAN-00571: ===========================================================
RMAN-04004: error from recovery catalog database: ORA-01045: user RMAN lacks CREATE SESSION privilege; logon denied
Now I grant RECOVERY_CATALOG_OWNER privilege to the rman user and lets see what happens next
SQL> grant recovery_catalog_owner to rman;
Grant succeeded.
Now we connect to the recovery catalog and we see that it is a successful connection.
RMAN> connect catalog rman/password
connected to recovery catalog database
Now lets proceed with the second step of creating the recovery catalog
RMAN> create catalog;
recovery catalog created
Recovery catalog can now save RMAN backup and recovery metadata.

Free Oracle Database Articles, Tips, Jobs :

Delivered by FeedBurner

Duplicate rman connection raises RMAN-06167

We connect to a target database and we try reconnecting to the same database. We will get the following error:
OS#rman
RMAN> connect target username/pass@oracle_sid
connected to target database: oracle_sid (DBID=192324234813)
RMAN> connect target username/password@oracle_sid
RMAN-06167: already connected

Free Oracle Database Articles, Tips, Jobs :

Delivered by FeedBurner

Oracle database vault available only in enterprise edition of database

I installed an Oracle Database standard edition recently and tried working with database vault. I got this error.
SQL> alter system set wallet open identified by “wallettest”;
alter system set wallet open identified by “wallettest”
*
ERROR at line 1:
ORA-28367: wallet does not exist
This error is self explanatory. Oracle Database Vault is a default feature in Oracle Database 11g Enterprise Edition and doesn’t come with standard edition.Here is a snapshot of default option in case of enterprise edition installation. We click on select options and this window opens. We see that Oracle Database Vault is unchecked. If we need it to be installed we have to check it.

Free Oracle Database Articles, Tips, Jobs :

Delivered by FeedBurner