Cold Backup and Recovery From Archivelog

Let’s have look on the steps used for Cold Backup and Recovery From Archivelog. Check the archive log status

Enable the archive logs

create a table for the testing purpose

Shutdown the database and make of necessary files

Start the database and insert some records

Shut down the database and […]

Read More

Delete applied archivelog script

We need to delete archivelogs which are applied on standby servers. Following script will do the job for you. vi /home/oracle/crons/remove_applied_archivelog.sh

2. Give executable permission to the file

3. Add to cron. It runs everyday at 22:05

 

Read More