rman SBT_TAPE NFS disk 模拟NBU带库 FRA

本文介绍: —————-rman 将本地磁盘变成磁带———————————–##RAC 本地 /nfs—-两个备份策略 cluster=nrun {run {run {run {

—————–rman 将本地磁盘变成磁带———————————–

##RAC 本地 /nfs—-两个备份策略 cluster=n

run {
alloc a t e channel ch00 device type ‘SBT_TAPE’
PARMS=”SBT_LIBRARY=oracle.di sk sbt,
ENV=(BACKUP_DIR=/nfs)”;
b ack up recovery ar ea ; }

run {
allocat e chann el ch00 device type ‘SBT_TAPE’
PARMS=”SBT_LIBRARY=oracle.di s k sbt,
ENV=(BACKUP_DIR=/nfs)”;
re store data file 3 ; }

run {
allocate chann el ch00 device ty pe ‘SBT_TAPE’
PARMS=”SBT_LIBRARY=oracle.di sksbt,
ENV=(BACKUP_DIR=/nfs)”;
delete obs o let e dev i ce ty pe sbt;
}

run {
allocate chann el ch00 device ty pe ‘SBT_TAPE’
PARMS=”SBT_LIBRARY=oracle.di s ks bt,
ENV=(BACKUP_DIR=/nfs)”;
re store database;
recover data base;
}

————————磁盘磁带两个策略

To maintain two di s ct inct retention p o li ci es fo r disk and tape b ackups.

SOLUTION

Dec ide whi ch device need s the long est recovery window – ty pi cally thi s will be TAPE.
Con fi gure the default retention policy to your long est recovery window egt 60 days.

RMAN>CONFIGURE RETENTION POLICY TO RECOVERY WINDOW OF 60 DAYS;

This ensu res that if ‘delete obs o lete’ is run wi thout any furt he r specification, your hig hest retention p o li cy is always observed.
The d aily h o use keep in g r out ine will then de lete obs o lete tape b ackups using the default, and de lete obsolete disk b ackups using an exp li cit recovery window ov err id in g the default.
For example, if tapes are to be kept 28 days but disk backups are kept for just 7 days:

RMAN>DELETE OBSOLETE DEVICE TYPE TAPE;
RMAN>DELETE OBSOLETE RECOVERY WINDOW OF 7 DAYS DEVICE TYPE DISK ;

RMAN> back up archive log all de lete input;

all, or until time ‘sys date -7′

RMAN> run {
back up archive log all;
de lete archive log until time ‘sysdate -1′ like ‘/u01/archives/TEST/%’;
delete archive log until time ‘sysdate -5′ like ‘/u02/arc hives/TEST/%’;
}

RMAN> run {
allocate c ha nn el c1 type ‘sbt_tape‘;
set arc hive log destination to ‘+FRA/TEST/ARCHIVELOG/2010_08_13’;
restore arc hive log
fro m time “to_date(’13/08/2010-00:00:00′,’dd/mm/yyyy–hh24:mi:ss‘)”
until time “to_date(’14/08/2010-00:00:00′,’dd/mm/yyyy–hh24:mi:ss‘)”;
}

SQL>Sel ect file_type, per cent_sp ace_used as used,percent_sp ace_reclaim able as reclaim able,
number_of_files as “number” from v$recovery_area_usage;

SQL> select name, sp ace_limit as Total_size ,sp ace_used as Used,
SPACE_RECLAIMABLE as reclaim able ,NUMBER_OF_FILES as “number”
from V$RECOVERY_FILE_DEST;

CROSSCHECK FOREIGN ARCHIVELOG ALL;
DELETE EXPIRED FOREIGN ARCHIVELOG ALL;

back up as compressed back up set data base plus archivelog ;
Delete obs olete dev ice type disk;
cross check archivelog all

You have a number of choices on how to resolve a full Fast Reco very Area when no files are eligible for deletion:

1. Make more disk sp ace av ai lable and increase DB_RECOVERY_FILE_DEST_SIZE

SQL> alter system set db_recovery_file_dest_size=xG SCOPE=BOTH; — (larger amount)

2. Move backups from the fast recovery area to tert iary storage su ch as tape.

RMAN>BACKUP RECOVERY AREA;

Note : Flashback logs cannot be backed up outside the recovery area and so are not backed up by BACKUP RECOVERY AREA.

3. Run DELETE for any files that ha ve been rem oved wi th an operating system utility. If you use host operating system commands to delete files, then the database will not be aware of the result ing free sp ace.

RMAN>CROSSCHECK BACKUP;
RMAN>CROSSCHECK ARCHIVELOG ALL;

RMAN>Delete expired backup;
RMAN>Delete expired archivelog all;
RMAN>Delete force obs olete;

4. Make sure that your guaranteed restore points are necessary. If not, delete them

SQL>Drop restore point <restore_point_name>;

5. If flashback logs are enable then make sure you have enough sp ace for all the flashback logs. If its not required then you can turn off flashback.

SQL>Alter database FLASHBACK OFF;

6. Review your backup retention poli cy and if required change the RMAN RETENTION POLICY

RMAN>CONFIGURE RETENTION POLICY TO RECOVERY WINDOW OF 7 DAYS;

Exc ept ions :

– If RMAN is not part of backup strategy and archivelogs are go ing to FRA then manual intervention required for deletion of archivelogs. Periodically purse old archivelogs

for example

RMAN>Delete archivelog all completed before ‘SYSDATE-7’;

– By default RMAN backup goes to FRA. While taking RMAN backup if backup location ex pli citly specified to fast recovery area location then those backup pi eces are not conside red as part of FRA for auto management.

– For Archivelogs backup to FRA use USE_DB_RECOVERY_FILE_DEST rather than giving expli cit path of FRA

SQL> alter system set log_archive_dest_10=’LOCATION=USE_DB_RECOVERY_FILE_DEST’ scope=both;

————————archive log 备份

RMAN> backup as compressed backupset archivelog all;

Starting backup at 02-DEC-23
current log archived
Fini shed Contr ol File and SPFILE Autobackup at 02-DEC-23

RMAN> delete noprompt force archivelog all backed up 1 times to dev ice type sbt;

没有可以删除的，因为只是备份到了disk

RMAN> run {
2> allocate channel ch00 device type ‘SBT_TAPE’
3> PARMS=”SBT_LIBRARY=oracle.disksbt,
4> ENV=(BACKUP_DIR=/nfs)”;
5> backup recovery area ; }

released channel: ORA_DISK_1
allocated channel: ch00
channel ch00: SID=813 instance=cdb2 device type=SBT_TAPE
channel ch00: WARNING: Oracle Test Disk API

Starting backup at 02-DEC-23
speci fi cation does not match any datafile copy in the repository
skip ping backup set key 82; already backed up 1 time(s)

channel ch00: starting archived log backup set
channel ch00: specifying archived log(s) in backup set
input archived log thread=2 seq ue nce=39 RECID=407 STAMP=1154562772
input archived log thread=2 sequence=40 RECID=408 STAMP=1154562774
input archived log thread=2 sequence=41 RECID=409 STAMP=1154562778
input archived log thread=2 sequence=42 RECID=410 STAMP=1154562781
input archived log thread=2 sequence=43 RECID=411 STAMP=1154562795
channel ch00: starting pi ece 1 at 02-DEC-23
channel ch00: finished pi ece 1 at 02-DEC-23
piece handle=5f2d2eoi_175_1_1 tag=TAG20231202T235354 comment=API Version 2.0,MMS Version 8.1.3.0

RMAN> delete noprompt force archivelog all backed up 1 times to device type sbt;
Deleted 5 objects

删除了archivelog 但是磁盘和SBT都有一个备份

RMAN> alter system switch logfile;

Statement processed

RMAN> run {
2> allocate channel ch00 device type ‘SBT_TAPE’
3> PARMS=”SBT_LIBRARY=oracle.disksbt,
4> ENV=(BACKUP_DIR=/nfs)”;
5> backup recovery area ; }

released channel: ORA_DISK_1
allocated channel: ch00
channel ch00: SID=813 instance=cdb2 device type=SBT_TAPE
channel ch00: WARNING: Oracle Test Disk API

Starting backup at 02-DEC-23
speci fi cation does not match any datafile copy in the repository
skip ping backup set key 99; already backed up 1 time(s)
channel ch00: starting archived log backup set
channel ch00: specifying archived log(s) in backup set
input archived log thread=2 sequence=44 RECID=412 STAMP=1154562880
input archived log thread=2 sequence=45 RECID=413 STAMP=1154562882
input archived log thread=2 sequence=46 RECID=414 STAMP=1154562887
channel ch00: starting piece 1 at 02-DEC-23
channel ch00: finished piece 1 at 02-DEC-23
piece handle=5j2d2eqt_179_1_1 tag=TAG20231202T235509 comment=API Version 2.0,MMS Version 8.1.3.0
channel ch00: backup set complete, elap sed time: 00:00:01
Fini shed backup at 02-DEC-23

Starting Control File and SPFILE Autobackup at 02-DEC-23
piece handle=c-2265125454-20231202-22 comment=API Version 2.0,MMS Version 8.1.3.0
Fini shed Control File and SPFILE Autobackup at 02-DEC-23
released channel: ch00

RMAN> delete noprompt force archivelog all backed up 1 times to device type sbt;
Deleted 3 objects

只是备份FRA，Archivelog也是FRA一部分，SBT上有一个备份，DISK上没有备份，删了就没了

RMAN> delete noprompt force archivelog all;

released channel: ORA_DISK_1
allocated channel: ORA_DISK_1
channel ORA_DISK_1: SID=813 instance=cdb2 device type=DISK
specification does not match any archived log in the repo sitory

本地和FRA都没了，删不了。。。。。。。

RMAN> alter system switch logfile;

RMAN> run {
2> allocate channel ch00 device type ‘SBT_TAPE’
3> PARMS=”SBT_LIBRARY=oracle.disksbt,
4> ENV=(BACKUP_DIR=/nfs)”;
5> backup recovery area ; }

RMAN> delete noprompt force archivelog all backed up 1 times to device type disk;

allocated channel: ORA_DISK_1
channel ORA_DISK_1: SID=813 instance=cdb2 device type=DISK

—–disk 确实没有备份，删除策略不生效

RMAN> backup recovery area; ————--backup fra 到disk 不行

RMAN> backup recovery area device type disk;

Starting backup at 02-DEC-23
using channel ORA_DISK_1
specification does not match any datafile copy in the repo sitory
RMAN-00571: ===========================================================
RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
RMAN-00571: ===========================================================
RMAN-03002: failure of backup command at 12/02/2023 23:56:56
RMAN-06603: TO DESTINATION option must be specified with RECOVERY AREA, RECOVERY FILES or DB_RECOVERY_FILE_DEST on disk device
RMAN-01007: at line 1 column 22 file: standard input

RMAN> delete noprompt force archivelog all backed up 1 times to device type disk;

released channel: ORA_DISK_1
allocated channel: ORA_DISK_1
channel ORA_DISK_1: SID=813 instance=cdb2 device type=DISK

—备份到本地可以删除也可以本地恢复

RMAN> backup archivelog all;
Fini shed Control File and SPFILE Autobackup at 02-DEC-23

RMAN> delete noprompt force archivelog all backed up 1 times to device type disk;

Deleted 5 objects

RMAN> restore archivelog from sequence 47 thread 2;

Starting restore at 02-DEC-23
using channel ORA_DISK_1

channel ORA_DISK_1: starting archived log restore to default destination
channel ORA_DISK_1: rest oring archived log
archived log thread=2 sequence=47
channel ORA_DISK_1: rest oring archived log
archived log thread=2 sequence=48
channel ORA_DISK_1: rest oring archived log
archived log thread=2 sequence=49
channel ORA_DISK_1: rest oring archived log
archived log thread=2 sequence=50
channel ORA_DISK_1: restoring archived log
archived log thread=2 sequence=51
channel ORA_DISK_1: reading from backup piece +DATA1/CDB/BACKUPSET/2023_12_02/annnf0_tag20231202t235747_0.318.1154516267
channel ORA_DISK_1: piece handle=+DATA1/CDB/BACKUPSET/2023_12_02/annnf0_tag20231202t235747_0.318.1154516267 tag=TAG20231202T235747
channel ORA_DISK_1: restored backup piece 1
channel ORA_DISK_1: restore co mplete, elap sed time: 00:00:01
Finished restore at 02-DEC-23