Shulou(Shulou.com)06/01 Report--

RMAN> BACKUP DATABASE;

Backup started on March-June-14

Use channel ORA_DISK_1

Channel ORA_DISK_1: Start backup set of all data files

Channel ORA_DISK_1: Specify data files in backup set

MAN-03009: Backup command (on ORA_DISK_1 channel, on 06/03/2014 22:43:56) failed

RA-19602: Unable to backup or copy active files in NOARCHIVELOG mode

Continue with the other job steps and the failed job will not be rerun

Channel ORA_DISK_1: Start backup set of all data files

Channel ORA_DISK_1: Specify data files in backup set

MAN-03009: Backup command (on ORA_DISK_1 channel, on 06/03/2014 22:43:56) failed

ORA-19602: Unable to backup or copy active files in NOARCHIVELOG mode

The backup set includes the current control file

Include current SPFILE in backup set

Channel ORA_DISK_1: Starting segment 1 on 03-Jun-14

Channel ORA_DISK_1: Completed Segment 1 on 03-Jun-14

Segment handle =C:\ORACLE\PRODUCT\10.2.0\FLASH_RECOVERY_AREA\ORCL\BACKUPSET\2014_06_03\O1

MF_NCSNF_TAG20140603T224356_9RVQSGDN_.BKP Tag = TAG20140603 T224356 Comment =NONE

Channel ORA_DISK_1: Backup set completed, elapsed time:00:00:03

RMAN-00571: ===========================================================

RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============

RMAN-00571: ===========================================================

As posted above, always prompt when doing BACKUP DATABASE "

MAN-03009: Backup command (on ORA_DISK_1 channel, on 06/03/2014 22:43:56) failed

RA-19602: Active files cannot be backed up or copied in NOARCHIVELOG mode ",

Find a solution online, the reason is because when you close the database (with SHUTDOWN IMMEDIATE) and start the database (with STARTUP), there is no load data (MOUNT) error caused.

Solution: Close database: SHUTDOWN IMMEDIATE,

Start database: STARTUP MOUNT.

The prompt to do BACKUP DATABASE again is as follows:

RMAN> BACKUP DATABASE;

Backup started on March-June-14

Allocated channel: ORA_DISK_1

Channel ORA_DISK_1: sid=157 devtype=DISK

Channel ORA_DISK_1: Start backup set of all data files

Channel ORA_DISK_1: Specify data files in backup set

Input data file fno=00001 name=C:\ORACLE\PRODUCT\10.2.0\ORADATA\ORCL\SYSTEM01.DBF

Input data file fno=00003 name=C:\ORACLE\PRODUCT\10.2.0\ORADATA\ORCL\SYSAUX01.DBF

Input data file fno=00005 name=C:\ORACLE\PRODUCT\10.2.0\ORADATA\ORCL\EXAMPLE01.DBF

Input data file fno=00002 name=C:\ORACLE\PRODUCT\10.2.0\ORADATA\ORCL\UNDOTBS01.DBF

Input data file fno=00006 name=C:\A.0RA

Input data file fno=00004 name=C:\ORACLE\PRODUCT\10.2.0\ORADATA\ORCL\USERS01.DBF

Input data file fno=00007 name=C:\B.ORA

Channel ORA_DISK_1: Starting segment 1 on 03-Jun-14

Channel ORA_DISK_1: Completed Segment 1 on 03-Jun-14

Segment handle =C:\ORACLE\PRODUCT\10.2.0\FLASH_RECOVERY_AREA\ORCL\BACKUPSET\2014_06_03\O1

_MF_NNNDF_TAG20140603T224922_9RVR3MD4_.BKP Tag = TAG20140603 T224922 Comment =NONE

Channel ORA_DISK_1: Backup set completed, elapsed time:00:00:55

Channel ORA_DISK_1: Start backup set of all data files

Channel ORA_DISK_1: Specify data files in backup set

The backup set includes the current control file

Include current SPFILE in backup set

Channel ORA_DISK_1: Starting segment 1 on 03-Jun-14

Channel ORA_DISK_1: Completed Segment 1 on 03-Jun-14

Segment handle =C:\ORACLE\PRODUCT\10.2.0\FLASH_RECOVERY_AREA\ORCL\BACKUPSET\2014_06_03\O1

_MF_NCSNF_TAG20140603T224922_9RVR5D87_.BKP Tag = TAG20140603 T224922 Comment =NONE

Channel ORA_DISK_1: Backup set completed, elapsed time:00:00:03

Backup completed on 03-Jun-14

Welcome to subscribe "Shulou Technology Information " to get latest news, interesting things and hot topics in the IT industry, and controls the hottest and latest Internet news, technology news and IT industry trends.