RMAN Stored Scripts
Gli script RMAN possono essere salvati all'interno del catalog inveche che su file system.
RMAN> CREATE GLOBAL SCRIPT global_full_backup
{
BACKUP DATABASE PLUS ARCHIVELOG;
DELETE OBSOLETE;
}
Per vedere la lista degli script.
RMAN> LIST SCRIPT NAMES;
List of Stored Scripts in Recovery Catalog
Scripts of Target Database ORCL
Script Name
Description
-----------------------------------------------------------------------
full_backup
Global Scripts
Script Name
Description
-----------------------------------------------------------------------
global_full_backup
Per vedere il conenuto dello script.
RMAN> print script global_full_backup;
printing stored global script: global_full_backup
{
BACKUP DATABASE PLUS ARCHIVELOG;
DELETE OBSOLETE;
}
Creare su file system uno script, leggendo i suoi contenui da un file text.
$ vi backup_script.txt
{
BACKUP DATABASE PLUS ARCHIVELOG;
DELETE OBSOLETE;
}
RMAN> CREATE SCRIPT from_file
FROM FILE '/home/oracle/backup_script.txt';
to list only global script names
RMAN> LIST GLOBAL SCRIPT NAMES;
to list the names of all scripts stored in the current recovery catalog
RMAN> LIST ALL SCRIPT NAMES;
Come si esegue lo stored script:
RMAN> RUN
{
EXECUTE SCRIPT full_backup;
}
Per eseguire invece un command file modificare il file come segue aggiungendo RUN:vi /home/oracle/backup_script.txt
Per copiare il contenuto di uno script su un file:
to delete a stored script
RMAN> DELETE SCRIPT 'full_backup';
--to delete a global stored script
RMAN> DELETE GLOBAL SCRIPT 'global_full_backup';
Collegarsi al catalogo dal db che contiene RMAN catalog che nell'esempio è un pluggable database.
[oracle@rmancat ~]$ rman target sys/system@primary catalog rcatown/rcatown@rcatpdb
RMAN> CREATE SCRIPT full_backup { backup database plus archivelog;}
{
BACKUP DATABASE PLUS ARCHIVELOG;
DELETE OBSOLETE;
}
Per vedere la lista degli script.
RMAN> LIST SCRIPT NAMES;
List of Stored Scripts in Recovery Catalog
Scripts of Target Database ORCL
Script Name
Description
-----------------------------------------------------------------------
full_backup
Global Scripts
Script Name
Description
-----------------------------------------------------------------------
global_full_backup
Per vedere il conenuto dello script.
RMAN> print script global_full_backup;
printing stored global script: global_full_backup
{
BACKUP DATABASE PLUS ARCHIVELOG;
DELETE OBSOLETE;
}
$ vi backup_script.txt
{
BACKUP DATABASE PLUS ARCHIVELOG;
DELETE OBSOLETE;
}
RMAN> CREATE SCRIPT from_file
FROM FILE '/home/oracle/backup_script.txt';
to list only global script names
RMAN> LIST GLOBAL SCRIPT NAMES;
to list the names of all scripts stored in the current recovery catalog
RMAN> LIST ALL SCRIPT NAMES;
RMAN> RUN
{
EXECUTE SCRIPT full_backup;
}
RUN
{
BACKUP DATABASE PLUS ARCHIVELOG;
DELETE OBSOLETE;
}
{
BACKUP DATABASE PLUS ARCHIVELOG;
DELETE OBSOLETE;
}
Come si esegue uno script salvato su file system:
RMAN> @/home/oracle/backup_script.txtRMAN> PRINT SCRIPT full_backup TO FILE '/home/oracle/backup2.txt';
RMAN> DELETE SCRIPT 'full_backup';
--to delete a global stored script
RMAN> DELETE GLOBAL SCRIPT 'global_full_backup';