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!
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