ﺍﻷﻤﺭ LIST:

ﺍﺴﺘﺨﺩﻤﻨﺎ ﺍﻷﻤﺭ LIST ﻜﺜﻴﺭﺍﹰ ﺃﺜﻨﺎﺀ ﺍﻟﺤﺩﻴﺙ ﻋﻥ ﺍﻟﻨﺴﺦ ﺍﻻﺤﺘﻴﺎﻁﻲ (Backup RMAN) ﺇﺫ ﺃﻥ ﻫﺫﺍ ﺍﻷﻤﺭ ﻴﻘﻭﻡ ﺒﻌﻤل ﺍﺴﺘﻌﻼﻡ ﻋﻥ ﺍﻟﻨﺴﺦ ﺍﻻﺤﺘﻴﺎﻁﻴﺔ ﺒﻜل ﺃﻨﻭﺍﻋﻬﺎ:

LIST BACKUPSET:

ﻟﻌﺭﺽ ﺠﻤﻴﻊ ﺍﻟﻤﻌﻠﻭﻤﺎﺕ ﻋﻥ ﺍﻟﻨﺴﺦ ﺍﻻﺤﺘﻴﺎﻁﻴﺔ ﻤﻥ ﺍﻟﻨﻭﻉ Backupset.

LIST COPY:

ﻟﻌﺭﺽ ﺠﻤﻴﻊ ﺍﻟﻤﻌﻠﻭﻤﺎﺕ ﻋﻥ ﺍﻟﻨﺴﺦ ﺍﻻﺤﺘﻴﺎﻁﻴﺔ ﻤﻥ ﺍﻟﻨﻭﻉ COPY.

LIST COPY OF TABLESPACE USERS: 

ﻟﻌﺭﺽ ﺠﻤﻴﻊ ﺍﻟﻤﻌﻠﻭﻤﺎﺕ ﻋﻥ ﺍﻟﻨﺴﺦ ﺍﻻﺤﺘﻴﺎﻁﻴﺔ ﻤﻥ ﺍﻟﻨﻭﻉ  USERS TABLESPACE COPY.

LIST ARCHIVELOG ALL: 

ﻟﻌﺭﺽ ﻤﻠﻔﺎﺕ ﺍﻷﺭﺸﻴﻑ ﺍﻟﺘﻲ ﻴﺘﻡ ﺘﺨﺯﻴﻨﻬﺎ ﻓﻲ ﺍلRecovery Flash Area.

:ALL ARCHIVELOG OF BACKUP LIST

ﻟﻌﺭﺽ ﺍﻟﻤﻌﻠﻭﻤﺎﺕ ﻋﻥ ﺍﻟﻨﺴﺦ ﺍﻻﺤﺘﻴﺎﻁﻴﺔ ﻟﻤﻠﻔﺎﺕ ﺍﻷﺭﺸﻴﻑ.

ﻫﺫﺍ ﺒﺎﻟﻁﺒﻊ ﻟﻴﺱ ﻜل ﺸﻲ ﻋﻥ ﺍﻷﻤﺭ LIST ﻭﻟﻜﻥ ﻋﻤﻭﻤﹰﺎ ﻫﺫﺍ ﺍﻷﻤﺭ ﻴﻘﻭﻡ ﺒﻌﺭﺽ ﻤﻌﻠﻭﻤﺎﺕ ﻋﻥ ﺍﻟﻨﺴﺦ ﺍﻻﺤﺘﻴﺎﻁﻴﺔ،

ﻭﺃﻨﺕ ﺘﺴﺘﻁﻴﻊ ﺃﻥ ﺘﺤﺩﺩ ﻤﺎ ﺘﺭﻴﺩ ﺃﻥ ﺘﺼل ﺇﻟﻴﻪ ﻤﻥ ﻤﻌﻭﻤﺎﺕ ﻭﻤﻥ ﺜﻡ ﺘﻘﻭﻡ ﺒﺼﻴﺎﻏﺔ ﺍﻷﻤﺭ ﺒﻨﺎﺀ ﻋﻠﻰ ﺍﻷﻤﺜﻠﺔ ﺍﻟﺴﺎﺒﻘﺔ.

:REPORT ﺍﻷﻤﺭ

ﻫﺫﺍ ﺍﻷﻤﺭ ﻴﺴﺎﻋﺩﻙ ﻓﻲ ﺘﺤﻠﻴل ﺍﻟﻤﻌﻠﻭﻤﺎﺕ ﺍﻟﺘﻲ ﻋﻨﺩﻙ ﻓﻲ ﺍلRMAN Repository.

REPORT SCHEMA:

ﻟﻌﺭﺽ ﻫﻴﻜﻠﺔ ﻗﺎﻋﺩﺓ ﺍﻟﺒﻴﺎﻨﺎﺕ ﺍﻟﻤﺴﺘﻬﺩﻓﺔ، ﻗﺩ ﺘﺤﺘﺎﺝ ﻟﻬﺫﺍ ﺍﻷﻤﺭ ﻗﺒل ﻋﻤﻠﻴﺔ ﺍﻟﻨﺴﺦ ﺍﻻﺤﺘﻴﺎﻁﻲ ﻟﻌﺭﺽ ﻫﻴﻜﻠﺔ ﻗﺎﻋﺩﺓ ﺍﻟﺒﻴﺎﻨﺎﺕ.

REPORT OBSOLETE:

ﻟﻌﺭﺽ ﻤﻠﻔﺎﺕ ﺍﻟﻨﺴﺦ ﺍﻻﺤﺘﻴﺎﻁﻲ ﺍﻟﻤﻠﻐﻴﺔ ﺃﻭ ﺍﻟﺘﻲ ﺍﻨﺘﻬﺕ ﻓﺘﺭﺓ ﺍﻻﺤﺘﻔﺎﻅ ﺒﻬﺎ،

ﺒﺎﻟﻁﺒﻊ ﺴﻭﻑ ﻴﺘﻡ ﺍﻟﺘﺄﻜﺩ ﻤﻥ ﺍﻟﻤﺘﻐﻴﺭ RETENTION POLICY ﻭﻤﻥ ﺜﻡ ﻴﺘﻡ ﻋﺭﺽ ﺍﻟﻤﻌﻠﻭﻤﺎﺕ ﺒﻨﺎﺀ ﻋﻠﻰ ﻗﻴﻤﺔ ﺍﻟﻤﺘﻐﻴﺭ.

REPORT OBSOLETE REDUNDANCY:

ﻫﺫﺍ ﺍﻷﻤﺭ ﻴﻘﻭﻡ ﺒﺘﺠﺎﻫل ﻗﻴﻤﺔ ﺍﻟﺘﻬﻴﺌﺔ ﺍﻵﻟﻴﺔ ﻟﻠﻤﺘﻐﻴﺭ 

RETENTION POLICY ﻭﻴﻘﻭﻡ ﺒﻌﺭﺽ ﻤﻠﻔﺎﺕ ﺍﻟﻨﺴﺦ ﺍﻻﺤﺘﻴﺎﻁﻲ ﺍﻟﺘﻲ ﻤﺭ ﻋﻠﻴﻬﺎ ﺃﻜﺜﺭ ﻤﻥ ﻴﻭﻤﻴﻥ.

REPORT NEED BACKUP:

ﻟﻌﺭﺽ ﻤﻠﻔﺎﺕ ﻗﺎﻋﺩﺓ ﺍﻟﺒﻴﺎﻨﺎﺕ ﺍﻟﺘﻲ ﺘﺤﺘﺎﺝ ﺇﻟﻰ ﻨﺴﺦ ﺍﺤﺘﻴﺎﻁﻲ ﻭﺫﻟﻙ ﺤﺴﺏ ﻗﻴﻤﺔ ﺍﻟﻤﺘﻐﻴﺭ RETENTION POLICY، ﻓﻠﻭ ﻜﺎﻥ ﻫﺫﺍ ﺍﻟﻤﺘﻐﻴﺭ ﻴﺄﺨﺫ ﺍﻟﻘﻴﻤﺔ 3 REDUNDANCY

ﻓﻬﺫﺍ ﻴﻌﻨﻰ ﻋﺭﺽ ﻤﻠﻔﺎﺕ ﻗﺎﻋﺩﺓ ﺍﻟﺒﻴﺎﻨﺎﺕ ﺍﻟﺘﻲ ﻟﺩﻴﻬﺎ ﺍﻗل ﻤﻥ 3 ﻨﺴﺦ ﺍﺤﺘﻴﺎﻁﻴﺔ.

REPORT NEED BACKUP REDUNDANCY 3:

ﻫﺫﺍ ﺍﻷﻤﺭ ﻟﺘﺠﺎﻫل ﻗﻴﻤﺔ ﺍﻟﺘﻬﻴﺌﺔ ﺍﻵﻟﻴﺔ ﻟﻠﻤﺘﻐﻴﺭ RETENTION POLICY ﻭﻴﻘﻭﻡ ﺒﻌﺭﺽ ﻤﻠﻔﺎﺕ ﻗﺎﻋﺩﺓ ﺍﻟﺒﻴﺎﻨﺎﺕ ﺍﻟﺘﻲ ﻟﺩﻴﻬﺎ ﺍﻗل ﻤﻥ 3 ﻨﺴﺦ ﺍﺤﺘﻴﺎﻁﻴﺔ.

:DELETE ﺍﻷﻤﺭ

ﻫﺫﺍ ﺍﻷﻤﺭ ﻴﻘﻭﻡ ﺒﺤﺫﻑ ﻤﻠﻔﺎﺕ ﺍﻟﻨﺴﺦ ﺍﻻﺤﺘﻴﺎﻁﻲ ﻤﻥ ﺍلRMAN REPOSITORY ﻭﺍﻟﻜﺘﺎﻟﻭﺝ ﻜﻤﺎ ﻴﻘﻭﻡ ﺒﺤﺫﻓﻬﺎ ﺃﻴﻀﺎﹰ ﻓﻴﺯﻴﺎﺌﻴﺎﹰ،

ﻟﺫﺍ ﻜﺎﻥ ﻤﻥ ﺍﻟﺨﻁﺄ ﺤﺫﻑ ﻤﻠﻔﺎﺕ ﺍﻟﻨﺴﺦ ﺍﻻﺤﺘﻴﺎﻁﻲ ﻓﻴﺯﻴﺎﺌﻴﺎﹰ ﻋﻥ ﻁﺭﻴﻕ ﻨﻅﺎﻡ ﺍﻟﺘﺸﻐﻴل ﻭﺫﻟﻙ ﻷﻥ ﻫﺫﻩ ﺍﻟﻤﻠﻔﺎﺕ ﺴﺘﻅل ﻤﻭﺠﻭﺩﺓ ﻓﻲ ﺍلREPOSITORY.

DELETE OBSOLETE:

ﻟﺤﺫﻑ ﺍﻟﻤﻠﻔﺎﺕ ﺍﻟﺘﻲ ﺍﻨﺘﻬﺕ ﻓﺘﺭﺓ ﺍﻻﺤﺘﻔﺎﻅ ﺒﻬﺎ ﻭﺫﻟﻙ ﺤﺴﺏ ﺍلRETENTION POLICY.

3 DELETE OBSOLETE REDUNDANCY:

ﻟﺘﺠﺎﻫل ﺍﻟﺘﻬﻴﺌﺔ ﺍﻵﻟﻴﺔ ﻟﻠﻤﺘﻐﻴﺭ RETENTION POLICY ﻭﺤﺫﻑ ﻤﻠﻔﺎﺕ ﺍﻟﻨﺴﺦ ﺍﻻﺤﺘﻴﺎﻁﻲ ﺍﻟﺘﻲ ﺯﺍﺩﺕ ﻋﺩﺩ ﻨﺴﺨﻬﺎ ﻋﻥ ﺍﻟﺜﻼﺜﺔ ﻨﺴﺦ

7303 DELETE BACKUPSET:

ﻟﺤﺫﻑ ﺍﻟﻨﺴﺨﺔ ﺍﻻﺤﺘﻴﺎﻁﻴﺔ ﺒﺎﻟﺭﻗﻡ 7303 ﻤﻥ ﺍﻟﻨﻭﻉ Backupset.

DELETE COPY OF DATAFILE 1:

ﻟﺤﺫﻑ ﺍﻟﻨﺴﺦ ﺍﻻﺤﺘﻴﺎﻁﻴﺔ ﻟل1 Data File ﻤﻥ ﺍﻟﻨﻭﻉ Image Copy.

DELETE ARCHIVELOG FROM SEQUENCE 150:

ﻟﺤﺫﻑ ﻤﻠﻔﺎﺕ ﺍﻷﺭﺸﻴﻑ ﺍﺒﺘﺩﺍﺀً ﻤﻥ ﺍلSequence 150 ﻓﻤﺎ ﻓﻭﻕ، ﻜﻤﺎ ﻴﻤﻜﻥ ﺤﺫﻑ ﺠﻤﻴﻊ ﻤﻠﻔﺎﺕ ﺍﻷﺭﺸﻴﻑ ﺒﻭﺍﺴﻁﺔ ﺍﻷﻤﺭ DELETE ARCHIVELOG ALL.

:CROSSCHECK ﺍﻷﻤﺭ

ﻤﺎﺫﺍ ﻟﻭ ﻗﻤﺕ ﺒﻌﻤل ﺤﺫﻑ ﻟﻤﻠﻔﺎﺕ ﺍﻟﻨﺴﺦ ﺍﻻﺤﺘﻴﺎﻁﻲ ﻤﺒﺎﺸﺭﺓ ﻋﻥ ﻁﺭﻴﻕ ﻨﻅﺎﻡ ﺍﻟﺘﺸﻐﻴل ﻻ ﺸﻙ ﺃﻥ ﻫﺫﻩ ﺍﻟﻨﺴﺦ ﺴﺘﻅل ﻤﻭﺠﻭﺩﺓ ﻓﻲ ﺍلRepository،

ﻭﻴﻤﻜﻥ ﺤل ﻫﺫﻩ ﺍﻟﻤﺸﻜﻠﺔ ﺒﻭﺍﺴﻁﺔ ﺍﻷﻤﺭ CROSSCHECK ﺍﻟﺫﻱ ﻴﻘﻭﻡ ﺒﻌﻤل ﺍﺨﺘﺒﺎﺭ ﻟﺠﻤﻴﻊ ﺍﻟﻨﺴﺦ ﺍﻻﺤﺘﻴﺎﻁﻴﺔ ﺍﻟﻤﻭﺠﻭﺩﺓ ﻓﻲ ﺍلRepository ﻭﻴﺘﺄﻜﺩ ﻤﻥ ﻭﺠﻭﺩﻫﺎ ﻓﻴﺯﻴﺎﺌﻴﹰﺎ،

ﺃﻤﺎ ﺍﻟﻤﻠﻔﺎﺕ ﺍﻟﺘﻲ ﻟﻥ ﻴﺠﺩﻫﺎ ﻓﻴﺯﻴﺎﺌﻴﺎﹰ ﻓﻴﻘﻭﻡ ﺒﻭﻀﻌﻬﺎ ﻓﻲ ﻗﺎﺌﻤﺔ ﺍﻟﻤﻨﺘﻬﻴﺎﺕ EXPIRED، ﺤﺘﻰ ﻨﺴﺘﻁﻴﻊ ﺤﺫﻓﻬﺎ ﻓﻴﻤﺎ ﺒﻌﺩ ﺒﻭﺍﺴﻁﺔ ﺍﻷﻤﺭ

DELETE EXPIRED BACKUPSET ﺃﻭ DELETE EXPIRED COPY.

ﻭﻗﺒل ﺫﻟﻙ ﺃﻨﺕ ﺘﺴﺘﻁﻴﻊ ﺍﻻﺴﺘﻌﻼﻡ ﻋﻥ ﻫﺫﻩ ﺍﻟﻘﺎﺌﻤﺔ ﺒﻭﺍﺴﻁﺔ ﺍﻷﻤﺭ LIST EXPIRED BACKUPSET.

ﻟﻨﻔﺘﺭﺽ ﺍﻵﻥ ﺃﻨﻙ ﻗﻤﺕ ﺒﺤﺫﻑ ﺍﺤﺩ ﻤﻠﻔﺎﺕ ﺍﻟﻨﺴﺦ ﺍﻻﺤﺘﻴﺎﻁﻲ ﻤﻥ ﺍﻟﻨﻭﻉ Backupset ﻋﻥ ﻁﺭﻴﻕ ﻨﻅﺎﻡ ﺍﻟﺘﺸﻐﻴل، ﻭﺘﺭﻴﺩ ﺃﻥ ﺘﺤﺫﻑ ﺫﻟﻙ ﺍﻟﻤﻠﻑ ﻤﻥ ﺍلREPOSITORY.

1- ﻨﻨﻔﺫ ﺍﻵﻤﺭ CROSSCHECK BACKUPSET ﻟﻌﻤل ﺍﺨﺘﺒﺎﺭ ﻟﻤﻠﻔﺎﺕ ﺍﻟﻨﺴﺦ ﺍﻻﺤﺘﻴﺎﻁﻲ ﻤﻥ ﺍﻟﻨﻭﻉ BACKUPSET ﻭﻨﺘﻴﺠﺔ ﻫﺫﺍ ﺍﻻﺨﺘﺒﺎﺭ (EXPIRED OR AVAILABLE).

2- ﻋﺭﺽ ﻗﺎﺌﻤﺔ ﺍﻟﻤﻨﺘﻬﻴﺎﺕ EXPIRED LIST:

٣- ﺤﺫﻑ ﻤﻠﻑ ﺍﻟﻨﺴﺦ ﺍﻻﺤﺘﻴﺎﻁﻲ ﻤﻥ ﻗﺎﺌﻤﺔ ﺍﻟﻤﻨﺘﻬﻴﺎﺕ DELETE EXPIRED

:CHANGE…..UNAVAILABLE ﺍﻷﻤﺭ

ﻓﻲ ﺒﻌﺽ ﺍﻷﺤﻴﺎﻥ ﺘﺤﺩﺙ ﻤﺸﻜﻠﺔ ﻓﻲ ﺍلHardware ﺘﺠﻌل ﻤﻥ ﺍﻟﻤﺘﻌﺫﺭ ﻓﻴﺯﻴﺎﺌﻴﺎﹰ ﻤﺸﺎﻫﺩﺓ ﺒﻌﺽ ﻤﻠﻔﺎﺕ ﺍﻟﻨﺴﺦ ﺍﻻﺤﺘﻴﺎﻁﻲ،

ﻓﻴﻘﻭﻡ ﻫﺫﻩ ﺍﻷﻤﺭ ﺒﻌﻤل ﺇﺸﺎﺭﺓ ﺇﻟﻰ ﺘﺠﺎﻫل ﻫﺫﺍ ﺍﻟﻤﻠﻑ ﺃﺜﻨﺎﺀ ﻋﻤﻠﻴﺔ ﺍﻻﺴﺘﺭﺠﺎﻉ (RESTORE OR RECOVERY).

ﻴﻤﻜﻥ ﺒﺎﻟﻁﺒﻊ ﺒﻌﺩ ﻤﻌﺎﻟﺠﺔ ﺍﻟﻌﻁل ﻭﺇﺘﺎﺤﺔ ﺍﻟﻤﻠﻑ ﺘﻌﺩﻴل ﺍﻟﺤﺎﻟﺔ ﺒﻭﺍﺴﻁﺔ ﺍﻟﻤﺘﻐﻴﺭ

CHANGE ….AVAILABLE

:CATALOG ﺍﻷﻤﺭ

ﻓﻲ ﺒﻌﺽ ﺍﻷﺤﻴﺎﻥ ﺘﻘﻭﻡ ﺒﻌﻤل ﻨﺴﺦ ﺍﺤﺘﻴﺎﻁﻲ ﻋﻥ ﻁﺭﻴﻕ ﻨﻅﺎﻡ ﺍﻟﺘﺸﻐﻴل User-Managed Backups ﺒﺎﻟﻁﺒﻊ ﻤﺜل ﻫﺫﺍ ﺍﻟﻨﻭﻉ ﻤﻥ ﺍﻟﻨﺴﺦ ﺍﻻﺤﺘﻴﺎﻁﻲ ﻻ ﻴﺘﻡ ﺘﺴﺠﻴﻠﻪ ﻓﻲ ﺍلRepository,

ﻭﻟﻜﻥ ﻴﻤﻜﻥ ﺘﺴﺠﻴﻠﻪ ﻴﺩﻭﻴﺎﹰ ﻋﻥ ﻁﺭﻴﻕ ﺍﻷﻤﺭ CATALOG ﺤﺘﻰ ﺘﺴﺘﻁﻴﻊ ﺍﻟﺘﻌﺎﻤل ﻤﻌﻪ ﻋﻥ ﻁﺭﻴﻕ ﺍلRMAN، ﻭﻨﻭﻉ ﺍﻟﻤﻠﻔﺎﺕ ﺍﻟﺘﻲ ﻴﺴﺘﻁﻴﻊ ﻫﺫﺍ ﺍﻷﻤﺭ ﺍﻟﺘﻌﺎﻤل ﻤﻌﻬﺎ ﻫﻲ:

1- Operating System Datafile Copy.

2- Archive Log File Copy.

3- Control File Copy.

ﻟﻘﺩ ﺘﻡ ﺘﺴﺠﻴل ﻤﻠﻑ ﺍﻟﻨﺴﺦ ﺍﻻﺤﺘﻴﺎﻁﻲ ﺍﻟﺫﻱ ﺃﻨﺠﺯ ﻋﻥ ﻁﺭﻴﻕ ﻨﻅﺎﻡ ﺍﻟﺘﺸﻐﻴل ﻓﻲ ﺍلREPOSITORY ﻭﻴﻤﻜﻥ ﺍﻵﻥ ﺍﻟﺘﻌﺎﻤل ﻤﻌﻪ ﻋﻥ ﻁﺭﻴﻕ ﺍل.RMAN.

:CHANGE….UNCATALOG ﺍﻷﻤﺭ

ﺒﺎﻟﻁﺒﻊ ﻴﻤﻜﻥ ﺇﻟﻐﺎﺀ ﺘﺴﺠﻴل ﻤﻠﻔﺎﺕ ﺍﻟﻨﺴﺦ ﺍﻻﺤﺘﻴﺎﻁﻲ ﻤﻥ ﺍلREPOSITORY ﺒﻭﺍﺴﻁﺔ ﻫﺫﺍ ﺍﻷﻤﺭ

CHANGE….UNCATALOG

ﺒﺎﻟﻁﺒﻊ ﻫﺫﺍ ﺍﻷﻤﺭ ﻴﻘﻭﻡ ﺒﺈﻟﻐﺎﺀ ﻤﻠﻔﺎﺕ ﺍﻟﻨﺴﺦ ﺍﻻﺤﺘﻴﺎﻁﻲ ﻤﻥ ﺍلREPOSITORY ﻭﻟﻜﻥ ﻴﻅل ﺍﻟﻤﻠﻑ ﻤﻭﺠﻭﺩ ﻓﻴﺯﻴﺎﺌﻴﹰﺎ.

-----------------------------------------------