| RMAN 8.0.5 .. please advise!!! [message #52824] |
Thu, 15 August 2002 10:57  |
Azmat
Messages: 8
Registered: July 2002
|
Junior Member |
|
|
Hi All,
I am running an 8.0.5 database on Sun Solaris in ARCHIVELOG mode.
I am trying to implement RMAN for backup and recovery.
Because my database environment is a DSS, and mostly we have data loads with NOLOGGING options.
therefore the ARCHIVELOGS are of no use for me to backup.
I want to apply Level0, level1, and level2 backups on my datafiles only. I dont want to backup the ARCHIVELOGS. I have prepared following scripts, please tell me if my strategy is wrong and why.
Also i want to delete the ARCHIVELOGS from my RMAN script therefore please tell me the SYNTAX that can fit in to my script to delete the
ARCHIVELOGS at the end.
*-----------------------------------
resync catalog;
run
{
allocate channel t1 type 'SBT_TAPE';
allocate channel t2 type 'SBT_TAPE';
allocate channel t3 type 'SBT_TAPE';
allocate channel t4 type 'SBT_TAPE';
allocate channel t5 type 'SBT_TAPE';
set maxcorrupt for datafile 1 to 0;
backup
incremental level 1
skip offline
skip readonly
skip inaccessible
tag backup_db_level_1
filesperset 2
format '%d_df_1_t%t_s%s_p%p'
(database);
# Releases all channels
release channel t1;
release channel t2;
release channel t3;
release channel t4;
release channel t5;
sql 'alter system archive log current';
}
*------------------------------------
Than you
Azmat
|
|
|
|
| Re: RMAN 8.0.5 .. please advise!!! [message #52830 is a reply to message #52824] |
Thu, 15 August 2002 13:21  |
Grant
Messages: 578
Registered: January 2002
|
Senior Member |
|
|
|
This allows you to do a point in time recovery. If you are sure you do not want the archive logs then you still need to let RMAN delete them. You can close the tape channels and open a disk channel and tell it to go to the directory you specify and then use the host command to delete them. RMAN will remove them from the archive directory then you remove them manually with "host". You will need to do it this way because the control file keeps track and if you delete them manually then you will get an RMAN error.
|
|
|
|
| Re: RMAN 8.0.5 .. please advise!!! [message #52843 is a reply to message #52824] |
Fri, 16 August 2002 04:47 |
Grant
Messages: 578
Registered: January 2002
|
Senior Member |
|
|
You would do something like this:
run
{
allocate channel t1 type 'SBT_TAPE';
allocate channel t2 type 'SBT_TAPE';
allocate channel t3 type 'SBT_TAPE';
allocate channel t4 type 'SBT_TAPE';
allocate channel t5 type 'SBT_TAPE';
set maxcorrupt for datafile 1 to 0;
backup
incremental level 1
skip offline
skip readonly
skip inaccessible
tag backup_db_level_1
filesperset 2
format '%d_df_1_t%t_s%s_p%p'
(database);
# Releases all channels
release channel t1;
release channel t2;
release channel t3;
release channel t4;
release channel t5;
sql 'alter system archive log current';
# Something like this! Backup all archive logs. Note this would be unix. Change as needed.
allocate channel c1 type disk;
backup
format '/export/OraBackups/rman_backups/al_%s_%p_%t'
(archivelog all delete input);
release channel c1;
host 'rm /export/OraBackups/rman_backups/*';
}
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
