Ok

En poursuivant votre navigation sur ce site, vous acceptez l'utilisation de cookies. Ces derniers assurent le bon fonctionnement de nos services. En savoir plus.

Commandes utiles RMAN

Liste des commandes utiles RMAN

RMAN> show all;

Configure the disk channel to the format /backup/ora_df%t_s%s_s%p’

RMAN> CONFIGURE CHANNEL DEVICE TYPE DISK FORMAT ‘/backup/ora_df%t_s%s_s%p’;

Configure the disk channel to the format +FLASHDG

RMAN> CONFIGURE CHANNEL DEVICE TYPE DISK FORMAT ‘+FLASHDG’;

Backup the database using the standard RMAN parameters

RMAN> backup database;

List all of the current backups for the database

RMAN> list backup;

 

List Backup summary

RMAN> list summary;

 

Crosscheck backups to see if they still exist

RMAN> crosscheck backup;

 

Crosscheck archive logs to see if they still exist

RMAN> crosscheck archivelog all;

 

Remove any expired backup

RMAN> delete expired backup;

Remove any expired archivelos

RMAN> delete expired archivelog;

Backup the database and archivelogs using the standard RMAN parameters and delete the archivelogs after the backup

RMAN> backup archivelog all delete input;

And

RMAN> run

2> {

3> backup database;

4> backup  archivelog all delete input;

5> }

Report of files that need backup due to unrecoverable operations

RMAN> report unrecoverable;

Report the obsolete backups and archivelogs

RMAN> report obsolete;

 

Delete the obsolete backups and archivelogs

RMAN> delete obsolete;

 

List all of the archivelogs

RMAN> list archivelog all;

Delete a specifed backupset

RMAN> delete backupset 1344

Sample backup command

RMAN> run

2> {

3> backup database;

4> sql “alter system switch logfile”;

5> backup archivelog all delete input;

6> sql “alter database backup controlfile to trace”;

7> }

Backup archive logs from scn 680

RMAN> run

2> {

3> ALLOCATE CHANNEL d1 DEVICE TYPE disk

4> FORMAT = ‘/app/oracle/admin/TEST/backup/df_%d_%s_%p.bak’;

5> backup as compressed backupset archivelog from sequence 680;

6> }

Backup archive logs and delete them up to scn 679

RMAN> run

2> {

3> ALLOCATE CHANNEL d1 DEVICE TYPE disk

4> FORMAT = ‘/app/oracle/admin/TEST/backup/df_%d_%s_%p.bak’;

5> backup as compressed backupset archivelog high sequence 679 delete input;

6> }

 

Point in time recovery

RMAN> run{

2> set until time “to_date(’05/07/11 09:00:00′ , ‘dd/mm/yy hh24:mi:ss’)”;

3> restore database;

4> recover database;

5> alter database open resetlogs;}

Delete archive logs up to scn 650

RMAN> delete archivelog high sequence 650;

list archivelogs from yesterday.

RMAN> list archivelog time between “sysdate -1” and “sysdate”

Delete archivelogs backed up 1 time to disk

RMAN> delete archive log all backed up 1 times to disk;

Delete backups older than 7 days

RMAN> delete backup completed before ‘sysdate -7’;

Restore archivelog between to scn numbers

RMAN> restore archivelog scn between 547484587 and 547662805;

Check For Logical And Physical Block Corruption

RMAN> backup check logical validate database;

 

source : https://oracledbazone.com/2012/04/18/useful-rman-commands/

Écrire un commentaire

Optionnel