Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.tools -> DATABASE FULL BACKUP IN RMAN

DATABASE FULL BACKUP IN RMAN

From: °­¸í±Ô <myunggyu_at_piamail.net>
Date: Tue, 17 Apr 2001 01:42:34 +0900
Message-ID: <9bf73l$6sa$1@news2-2.kornet.net>

I use Oracle 8i EE(8.1.6).
When I backup DB in Recovery Manager..
I got strange result. I can't understand why this error occured. In Archive log mode, backup is successful.. but noarchive log mode, this operation is failed. In Oralce manual, this is not metioned.

Below, error dump

RMAN> run {
2> allocate channel ch1
3> backup format 'd:\sms_backup\%U' database;

RMAN-00571: ===========================================================
RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
RMAN-00571: ===========================================================
RMAN-00558: error encountered while parsing input commands
RMAN-01005: syntax error: found "backup": expecting one of: "name, type" RMAN-01007: at line 3 column 1 file: standard input

RMAN> run {

2> allocate channel ch1 type disk;
3> backup database format 'd:\sms_backup\%U';
4> }

RMAN-03022: compiling command: allocate
RMAN-03023: executing command: allocate

RMAN-08030: allocated channel: ch1
RMAN-08500: channel ch1: sid=40 devtype=DISK
RMAN-03022: compiling command: backup
RMAN-03023: executing command: backup
RMAN-08008: channel ch1: starting full datafile backupset
RMAN-08502: set_count=4 set_stamp=427253668 creation_time=17-APR-01
RMAN-08010: channel ch1: specifying datafile(s) in backupset
RMAN-00571: ===========================================================
RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
RMAN-00571: ===========================================================
RMAN-03007: retryable error occurred during execution of command: backup
RMAN-07004: unhandled exception during command execution on channel ch1
RMAN-10035: exception raised in RPC: ORA-19602: cannot backup or copy active
file in NOARCHIVELOG mode
RMAN-10031: ORA-19624 occurred during call to DBMS_BACKUP_RESTORE.BACKUPDATAFILE RMAN> Received on Mon Apr 16 2001 - 11:42:34 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US