oracle_rman

rman target / nocatalog



CONFIGURE CONTROLFILE AUTOBACKUP OFF;
CONFIGURE DEVICE TYPE DISK PARALLELISM 2 BACKUP TYPE To COMPRESSED BACKUPSET;
RUN
{
SHOW ALL;
allocate channel ch1 device type disk maxpiecesize=40G;
allocate channel ch2 device type disk maxpiecesize=40G;
allocate channel ch3 device type disk maxpiecesize=40G;
allocate channel ch4 device type disk maxpiecesize=40G;
DELETE NOPROMPT OBSOLETE;
CROSSCHECK ARCHIVELOG ALL;
DELETE NOPROMPT EXPIRED ARCHIVELOG ALL;
backup cumulative incremental level 0 database tag 'LEVEL_0' format 'D:\RMANback\ORA_DB_%d_%T_%U.NIX.BAK';
backup archivelog all tag 'ARCH_LOG' format 'D:\RMANback\ORA_ARCH_%d_%T_%U.NIX.BAK';
DELETE NOPROMPT force archivelog all completed before 'sysdate-7';
backup current controlfile tag='CONTROL' format='D:\RMANback\ORA_CTL_%d_%T_%U.NIX.BAK';
backup spfile tag='SPFILE' format='D:\RMANback\ORA_SPFILE_%d_%T_%U.NIX.BAK';
release channel ch1;
release channel ch2;
release channel ch3;
release channel ch4;
report schema;
}

RUN
{
 STARTUP FORCE NOMOUNT;
 SET DBID=869731151;
 RESTORE CONTROLFILE FROM 'D:\RMANback\ORA_CTL_KMZL_20220905_5U1701KF_1_1.NIX.BAK';
 ALTER DATABASE MOUNT;
}
SHOW ALL;
RUN{
 CONFIGURE DEVICE TYPE DISK PARALLELISM 4 BACKUP TYPE To COMPRESSED BACKUPSET;
 ALLOCATE CHANNEL ch1 DEVICE TYPE DISK MAXPIECESIZE=40G;
 ALLOCATE CHANNEL ch2 DEVICE TYPE DISK MAXPIECESIZE=40G;
 ALLOCATE CHANNEL ch3 DEVICE TYPE DISK MAXPIECESIZE=40G;
 ALLOCATE CHANNEL ch4 DEVICE TYPE DISK MAXPIECESIZE=40G;
 CROSSCHECK BACKUP;
 DELETE NOPROMPT EXPIRED BACKUP;
 SET UNTIL SEQUENCE 0 THREAD 1;
 RESTORE DATABASE;
 RECOVER DATABASE;
 RELEASE CHANNEL ch1;
 RELEASE CHANNEL ch2;
 RELEASE CHANNEL ch3;
 RELEASE CHANNEL ch4;
}
sql 'alter database open resetlogs';