Monday, March 17, 2014

Configure Database in Archivelog mode

I have installed Oracle 11g R2 on my PC.

To configure A Database to an Archivelog mode you first want to  configure two parameters mentioned in SPFile/pfile.Those are(Currently database is open and running).

 NAME                                 TYPE                 Values
------------------------------------ -----------------------
db_recovery_file_dest                string
db_recovery_file_dest_size           big integer

you would set values by typing following on the SQL prompt.

Alter system set db_recovery_file_dest='D:\Oracle\Recovery\fin' scope=both;
Alter system set db_recovery_file_dest_size=1024M scope=both;

Give Appropriate values for those db_recovery_file_dest should be an existing location.


Now please shutdown the database and start with the Mount mode.

sql> shutdown immediate;
sql> startup mount;
sql> Alter database archivelog;
sql> Alter database open;


Now database is ready to go with. :)
Thank you!

No comments:

Post a Comment