The database backup will be performed in no
catalog mode. The expected time of backup is around 2.5 hours. Full Backup
would be performed on daily basis, five days a week at 12:00. Old backups
(Yesterday’s) will be removed after the completion of full backup.
root@erp2.mydomain.com
# mkdir /development/crpbackup/amc
root@erp2.mydomain.com
# chmod -fR 777 /development/crpbackup/amc/
$ mkdir /u2/crpamc
$ mkdir /u2/crpamc/archive
$ chown -Rh oraamc:oinstall
/u2/crpamc/archive
$ chmod -fR 777 /u2/crpamc/archive
chown -Rh oraeme:oinstall
/export/home/oraamc/
mkdir /mnt/crpbackup
mount -F nfs 10.40.0.89:/development/crpbackup
/mnt/crpbackup/
shutdown immediate;
startup mount;
alter system set log_archive_dest=/u2/crpamc/archive
alter database archivelog;
alter database open;
sqlplus > alter database enable block change
tracking using file ‘/u1/oradev/DEV/db/apps_st/data/ch_track.log’;
Connect to RMAN
as OS Database
$ rman
Now get
connected with the database
RMAN>connect target
Now execute
following commands to configure RMAN
CONFIGURE RETENTION POLICY TO REDUNDANCY 1;
CONFIGURE BACKUP OPTIMIZATION ON; # default
CONFIGURE DEFAULT DEVICE TYPE TO DISK; # default
CONFIGURE CONTROLFILE AUTOBACKUP ON;
CONFIGURE CONTROLFILE AUTOBACKUP FORMAT FOR DEVICE
TYPE DISK TO '/mnt/crpbackup/amc/ORA_CF%F';
CONFIGURE DEVICE TYPE DISK PARALLELISM 1 BACKUP TYPE
TO BACKUPSET; # default
CONFIGURE DATAFILE BACKUP COPIES FOR DEVICE TYPE DISK
TO 1; #
default
CONFIGURE ARCHIVELOG BACKUP COPIES FOR DEVICE TYPE
DISK TO 1; # default
CONFIGURE CHANNEL DEVICE TYPE DISK FORMAT '/mnt/crpbackup/amc/amc_df%t_s%s_s%p';
CONFIGURE MAXSETSIZE TO UNLIMITED; # default
CONFIGURE ENCRYPTION FOR DATABASE OFF; # default
CONFIGURE ENCRYPTION ALGORITHM 'AES128'; # default
CONFIGURE COMPRESSION ALGORITHM 'BZIP2'; # default
CONFIGURE ARCHIVELOG DELETION POLICY TO NONE; # default
CONFIGURE SNAPSHOT CONTROLFILE NAME TO
'/mnt/crpbackup/amc/snapcf_amc.f';
/export/home/oraamc/amcbkp.sh
LOG_FILE="AMCBKP_`hostname`_`date
'+%d%m%y_%H%M'`.txt"
echo "**Start Date: `date
'+%d%m%y_%H%M'`*********************">>$LOG_FILE
cd /export/home/oraamc>>$LOG_FILE
. .profile
rman target system/systemdev cmdfile amcbkp.scr msglog amcbkp.log>>$LOG_FILE
echo "**End Date: `date
'+%d%m%y_%H%M'`*********************">>$LOG_FILE
/export/home/oraamc/amcbkp.scr
run
{
backup database;
delete noprompt obsolete redundancy=1;
backup archivelog all format '/mnt/crpbackup/amc/arch_%d_%u_%s_%T';
delete noprompt archivelog all backed up 1 times to
device type disk;
}
bash-3.00# chown -Rh oraamc:oinstall
/export/home/oraamc/amcbkp.scr
bash-3.00# chown -Rh oraamc:oinstall
/export/home/oraamc/amcbkp.sh
bash-3.00# chmod -fR 777 /export/home/oraamc/amcbkp.scr
bash-3.00# chmod -fR 777 /export/home/oraamc/amcbkp.sh
$ ls –lh rvf*
-rwxrwxrwx 1
oraamc
oinstall 202 May 19 15:58 amcbkp.scr
-rwxrwxrwx 1
oraamc
oinstall 325 May 19 15:55 amcbkp.sh
bash-3.00#
crontab -e oraamc
0 0 * * 1,2,3,4,5 /export/home/oraamc/amcbkp.sh
The database backup will be performed in no
catalog mode. The expected time of backup is around 2.5 hours. Full Backup
would be performed on daily basis, five days a week at 12:00. Old backups
(Yesterday’s) will be removed after the completion of full backup.
root@erp2.mydomain.com
# mkdir /development/crpbackup/rvf
root@erp2.mydomain.com
# chmod -fR 777 /development/crpbackup/rvf/
$ mkdir /u2/crprvf
$ mkdir /u2/crprvf/archive
$ chown -Rh orarvf:oinstall
/u2/crprvf/archive
$ chmod -fR 777 /u2/crprvf/archive
chown -Rh oraeme:oinstall /export/home/orarvf/
mkdir /mnt/crpbackup
mount -F nfs 10.40.0.89:/development/crpbackup
/mnt/crpbackup/
shutdown immediate;
startup mount;
alter system set log_archive_dest=/u2/crprvf/archive
alter database archivelog;
alter database open;
sqlplus > alter database enable block change
tracking using file ‘/u1/oradev/DEV/db/apps_st/data/ch_track.log’;
Connect to RMAN
as OS Database
$ rman
Now get
connected with the database
RMAN>connect target
Now execute
following commands to configure RMAN
CONFIGURE RETENTION POLICY TO REDUNDANCY 1;
CONFIGURE BACKUP OPTIMIZATION ON; # default
CONFIGURE DEFAULT DEVICE TYPE TO DISK; # default
CONFIGURE CONTROLFILE AUTOBACKUP ON;
CONFIGURE CONTROLFILE AUTOBACKUP FORMAT FOR DEVICE
TYPE DISK TO '/mnt/crpbackup/rvf/ORA_CF%F';
CONFIGURE DEVICE TYPE DISK PARALLELISM 1 BACKUP TYPE
TO BACKUPSET; # default
CONFIGURE DATAFILE BACKUP COPIES FOR DEVICE TYPE DISK
TO 1; #
default
CONFIGURE ARCHIVELOG BACKUP COPIES FOR DEVICE TYPE
DISK TO 1; # default
CONFIGURE CHANNEL DEVICE TYPE DISK FORMAT '/mnt/crpbackup/rvf/rvf_df%t_s%s_s%p';
CONFIGURE MAXSETSIZE TO UNLIMITED; # default
CONFIGURE ENCRYPTION FOR DATABASE OFF; # default
CONFIGURE ENCRYPTION ALGORITHM 'AES128'; # default
CONFIGURE COMPRESSION ALGORITHM 'BZIP2'; # default
CONFIGURE ARCHIVELOG DELETION POLICY TO NONE; # default
CONFIGURE SNAPSHOT CONTROLFILE NAME TO
'/mnt/crpbackup/rvf/snapcf_rvf.f';
/export/home/orarvf/rvfbkp.sh
LOG_FILE="RVFBKP_`hostname`_`date
'+%d%m%y_%H%M'`.txt"
echo "**Start Date: `date '+%d%m%y_%H%M'`*********************">>$LOG_FILE
cd /export/home/orarvf>>$LOG_FILE
. .profile
rman target system/systemdev cmdfile rvfbkp.scr msglog rvfbkp.log>>$LOG_FILE
echo "**End Date: `date
'+%d%m%y_%H%M'`*********************">>$LOG_FILE
/export/home/orarvf/rvfbkp.scr
run
{
backup database;
delete noprompt obsolete redundancy=1;
backup archivelog all format '/mnt/crpbackup/rvf/arch_%d_%u_%s_%T';
delete noprompt archivelog all backed up 1 times to
device type disk;
}
bash-3.00# chown -Rh orarvf:oinstall
/export/home/orarvf/rvfbkp.scr
bash-3.00# chown -Rh orarvf:oinstall
/export/home/orarvf/rvfbkp.sh
bash-3.00# chmod -fR 777 /export/home/orarvf/rvfbkp.scr
bash-3.00# chmod -fR 777 /export/home/orarvf/rvfbkp.sh
$ ls –lh rvf*
-rwxrwxrwx 1
orarvf
oinstall 202 May 19 15:58 rvfbkp.scr
-rwxrwxrwx 1
orarvf
oinstall 325 May 19 15:55 rvfbkp.sh
bash-3.00#
crontab -e orarvf
0 0 * * 1,2,3,4,5 /export/home/orarvf/rvfbkp.sh
The database backup will be performed in no
catalog mode. The expected time of backup is around 2.5 hours. Full Backup
would be performed on daily basis, five days a week at 12:00. Old backups
(Yesterday’s) will be removed after the completion of full backup.
root@erp2.mydomain.com
# mkdir /development/crpbackup/snt
root@erp2.mydomain.com
# chmod -fR 777 /development/crpbackup/snt/
$ mkdir /u2/crpsnt
$ mkdir /u2/crpsnt/archive
$ chown -Rh orasnt:oinstall
/u2/crpsnt/archive
$ chmod -fR 777 /u2/crpsnt/archive
chown -Rh oraeme:oinstall /export/home/orasnt/
mkdir /mnt/crpbackup
mount -F nfs 10.40.0.89:/development/crpbackup
/mnt/crpbackup/
shutdown immediate;
startup mount;
alter system set log_archive_dest=/u2/crpsnt/archive
alter database archivelog;
alter database open;
sqlplus > alter database enable block change
tracking using file ‘/u1/oradev/DEV/db/apps_st/data/ch_track.log’;
Connect to RMAN
as OS Database
$ rman
Now get
connected with the database
RMAN>connect target
Now execute
following commands to configure RMAN
CONFIGURE RETENTION POLICY TO REDUNDANCY 1;
CONFIGURE BACKUP OPTIMIZATION ON; # default
CONFIGURE DEFAULT DEVICE TYPE TO DISK; # default
CONFIGURE CONTROLFILE AUTOBACKUP ON;
CONFIGURE CONTROLFILE AUTOBACKUP FORMAT FOR DEVICE
TYPE DISK TO '/mnt/crpbackup/snt/ORA_CF%F';
CONFIGURE DEVICE TYPE DISK PARALLELISM 1 BACKUP TYPE
TO BACKUPSET; # default
CONFIGURE DATAFILE BACKUP COPIES FOR DEVICE TYPE DISK
TO 1; #
default
CONFIGURE ARCHIVELOG BACKUP COPIES FOR DEVICE TYPE
DISK TO 1; # default
CONFIGURE CHANNEL DEVICE TYPE DISK FORMAT '/mnt/crpbackup/snt/snt_df%t_s%s_s%p';
CONFIGURE MAXSETSIZE TO UNLIMITED; # default
CONFIGURE ENCRYPTION FOR DATABASE OFF; # default
CONFIGURE ENCRYPTION ALGORITHM 'AES128'; # default
CONFIGURE COMPRESSION ALGORITHM 'BZIP2'; # default
CONFIGURE ARCHIVELOG DELETION POLICY TO NONE; # default
CONFIGURE SNAPSHOT CONTROLFILE NAME TO
'/mnt/crpbackup/snt/snapcf_snt.f';
/export/home/orasnt/sntbkp.sh
LOG_FILE="SNTBKP_`hostname`_`date
'+%d%m%y_%H%M'`.txt"
echo "**Start Date: `date
'+%d%m%y_%H%M'`*********************">>$LOG_FILE
cd /export/home/orasnt>>$LOG_FILE
. .profile
rman target system/systemdev cmdfile sntbkp.scr msglog sntbkp.log>>$LOG_FILE
echo "**End Date: `date
'+%d%m%y_%H%M'`*********************">>$LOG_FILE
/export/home/orasnt/sntbkp.scr
run
{
backup database;
delete noprompt obsolete redundancy=1;
backup archivelog all format '/mnt/crpbackup/snt/arch_%d_%u_%s_%T';
delete noprompt archivelog all backed up 1 times to
device type disk;
}
bash-3.00# chown -Rh orasnt:oinstall
/export/home/orasnt/sntbkp.scr
bash-3.00# chown -Rh orasnt:oinstall
/export/home/orasnt/sntbkp.sh
bash-3.00# chmod -fR 777 /export/home/orasnt/sntbkp.scr
bash-3.00# chmod -fR 777 /export/home/orasnt/sntbkp.sh
$ ls –lh snt*
-rwxrwxrwx 1
orasnt
oinstall 202 May 19 15:58 sntbkp.scr
-rwxrwxrwx 1
orasnt
oinstall 325 May 19 15:55 sntbkp.sh
bash-3.00#
crontab -e orasnt
0 0 * * 1,2,3,4,5 /export/home/orasnt/sntbkp.sh
The database backup will be performed in no
catalog mode. The expected time of backup is around 2.5 hours. Full Backup
would be performed on daily basis, five days a week at 12:00. Old backups
(Yesterday’s) will be removed after the completion of full backup.
root@erp2.mydomain.com
# mkdir /development/crpbackup/ord
root@erp2.mydomain.com
# chmod -fR 777 /development/crpbackup/ord/
$ mkdir /u2/crpord
$ mkdir /u2/crpord/archive
$ chown -Rh oraord:oinstall
/u2/crpord/archive
$ chmod -fR 777 /u2/crpord/archive
chown -Rh oraord:oinstall /export/home/oraord/
mkdir /mnt/crpbackup
mount -F nfs 10.40.0.89:/development/crpbackup
/mnt/crpbackup/
shutdown immediate;
startup mount;
alter system set log_archive_dest=/u2/crpord/archive
alter database archivelog;
alter database open;
sqlplus > alter database enable block change
tracking using file ‘/u1/oradev/DEV/db/apps_st/data/ch_track.log’;
Connect to RMAN
as OS Database
$ rman
Now get
connected with the database
RMAN>connect target
Now execute
following commands to configure RMAN
CONFIGURE RETENTION POLICY TO REDUNDANCY 1;
CONFIGURE BACKUP OPTIMIZATION ON; # default
CONFIGURE DEFAULT DEVICE TYPE TO DISK; # default
CONFIGURE CONTROLFILE AUTOBACKUP ON;
CONFIGURE CONTROLFILE AUTOBACKUP FORMAT FOR DEVICE
TYPE DISK TO '/mnt/crpbackup/ord/ORA_CF%F';
CONFIGURE DEVICE TYPE DISK PARALLELISM 1 BACKUP TYPE
TO BACKUPSET; # default
CONFIGURE DATAFILE BACKUP COPIES FOR DEVICE TYPE DISK
TO 1; #
default
CONFIGURE ARCHIVELOG BACKUP COPIES FOR DEVICE TYPE
DISK TO 1; # default
CONFIGURE CHANNEL DEVICE TYPE DISK FORMAT '/mnt/crpbackup/ord/ord_df%t_s%s_s%p';
CONFIGURE MAXSETSIZE TO UNLIMITED; # default
CONFIGURE ENCRYPTION FOR DATABASE OFF; # default
CONFIGURE ENCRYPTION ALGORITHM 'AES128'; # default
CONFIGURE COMPRESSION ALGORITHM 'BZIP2'; # default
CONFIGURE ARCHIVELOG DELETION POLICY TO NONE; # default
CONFIGURE SNAPSHOT CONTROLFILE NAME TO
'/mnt/crpbackup/ord/snapcf_ord.f';
/export/home/oraord/ordbkp.sh
LOG_FILE="ORDBKP_`hostname`_`date
'+%d%m%y_%H%M'`.txt"
echo "**Start Date: `date '+%d%m%y_%H%M'`*********************">>$LOG_FILE
cd /export/home/oraord>>$LOG_FILE
. .profile
rman target system/systemdev cmdfile ordbkp.scr msglog ordbkp.log>>$LOG_FILE
echo "**End Date: `date
'+%d%m%y_%H%M'`*********************">>$LOG_FILE
/export/home/oraord/ordbkp.scr
run
{
backup database;
delete noprompt obsolete redundancy=1;
backup archivelog all format '/mnt/crpbackup/ord/arch_%d_%u_%s_%T';
delete noprompt archivelog all backed up 1 times to
device type disk;
}
bash-3.00# chown -Rh oraord:oinstall
/export/home/oraord/ordbkp.scr
bash-3.00# chown -Rh oraord:oinstall
/export/home/oraord/ordbkp.sh
bash-3.00# chmod -fR 777 /export/home/oraord/ordbkp.scr
bash-3.00# chmod -fR 777 /export/home/oraord/ordbkp.sh
$ ls –lh ord*
-rwxrwxrwx 1
oraord
oinstall 202 May 19 15:58 ordbkp.scr
-rwxrwxrwx 1
oraord
oinstall 325 May 19 15:55 ordbkp.sh
bash-3.00#
crontab -e oraord
0 0 * * 1,2,3,4,5 /export/home/oraord/ordbkp.sh
The database backup will be performed in no
catalog mode. The expected time of backup is around 2.5 hours. Full Backup
would be performed on daily basis, five days a week at 12:00. Old backups
(Yesterday’s) will be removed after the completion of full backup.
root@erp2.mydomain.com
# mkdir /development/crpbackup/eme
root@erp2.mydomain.com
# chmod -fR 777 /development/crpbackup/eme/
$ mkdir /u2/crpeme
$ mkdir /u2/crpeme/archive
$ chown -Rh oraeme:oinstall
/u2/crpeme/archive
$ chmod -fR 777 /u2/crpeme/archive
chown -Rh oraeme:oinstall /export/home/oraeme/
mkdir /mnt/crpbackup
mount -F nfs 10.40.0.89:/development/crpbackup
/mnt/crpbackup/
shutdown immediate;
startup mount;
alter system set log_archive_dest=/u2/crpeme/archive
alter database archivelog;
alter database open;
sqlplus > alter database enable block change
tracking using file ‘/u1/oradev/DEV/db/apps_st/data/ch_track.log’;
Connect to RMAN
as OS Database
$ rman
Now get connected
with the database
RMAN>connect target
Now execute
following commands to configure RMAN
CONFIGURE RETENTION POLICY TO REDUNDANCY 1;
CONFIGURE BACKUP OPTIMIZATION ON; # default
CONFIGURE DEFAULT DEVICE TYPE TO DISK; # default
CONFIGURE CONTROLFILE AUTOBACKUP ON;
CONFIGURE CONTROLFILE AUTOBACKUP FORMAT FOR DEVICE
TYPE DISK TO '/mnt/crpbackup/eme/ORA_CF%F';
CONFIGURE DEVICE TYPE DISK PARALLELISM 1 BACKUP TYPE
TO BACKUPSET; # default
CONFIGURE DATAFILE BACKUP COPIES FOR DEVICE TYPE DISK
TO 1; #
default
CONFIGURE ARCHIVELOG BACKUP COPIES FOR DEVICE TYPE
DISK TO 1; # default
CONFIGURE CHANNEL DEVICE TYPE DISK FORMAT '/mnt/crpbackup/eme/eme_df%t_s%s_s%p';
CONFIGURE MAXSETSIZE TO UNLIMITED; # default
CONFIGURE ENCRYPTION FOR DATABASE OFF; # default
CONFIGURE ENCRYPTION ALGORITHM 'AES128'; # default
CONFIGURE COMPRESSION ALGORITHM 'BZIP2'; # default
CONFIGURE ARCHIVELOG DELETION POLICY TO NONE; # default
CONFIGURE SNAPSHOT CONTROLFILE NAME TO
'/mnt/crpbackup/eme/snapcf_eme.f';
/export/home/oraeme/emebkp.sh
LOG_FILE="EMEBKP_`hostname`_`date
'+%d%m%y_%H%M'`.txt"
echo "**Start Date: `date
'+%d%m%y_%H%M'`*********************">>$LOG_FILE
cd /export/home/oraeme>>$LOG_FILE
. .profile
rman target system/systemdev cmdfile emebkp.scr msglog emebkp.log>>$LOG_FILE
echo "**End Date: `date
'+%d%m%y_%H%M'`*********************">>$LOG_FILE
/export/home/oraeme/emebkp.scr
run
{
backup database;
delete noprompt obsolete redundancy=1;
backup archivelog all format '/mnt/crpbackup/eme/arch_%d_%u_%s_%T';
delete noprompt archivelog all backed up 1 times to
device type disk;
}
bash-3.00# chown -Rh oraeme:oinstall
/export/home/oraeme/emebkp.scr
bash-3.00# chown -Rh oraeme:oinstall
/export/home/oraeme/emebkp.sh
bash-3.00# chmod -fR 777 /export/home/oraeme/emebkp.scr
bash-3.00# chmod -fR 777 /export/home/oraeme/emebkp.sh
$ ls –lh eme*
-rwxrwxrwx 1
oraeme
oinstall 202 May 19 15:58 emebkp.scr
-rwxrwxrwx 1
oraeme
oinstall 325 May 19 15:55 emebkp.sh
bash-3.00#
crontab -e oraeme
0 0 * * 1,2,3,4,5 /export/home/oraeme/emebkp.sh