DATABASE FULL BACKUP IN RMAN
From: (wrong string) °¸í±Ô <myunggyu_at_piamail.net>
Date: Tue, 17 Apr 2001 01:42:34 +0900
Message-ID: <9bf73l$6sa$1_at_news2-2.kornet.net>
RMAN-08030: allocated channel: ch1
RMAN-08500: channel ch1: sid=40 devtype=DISK
[Quoted] [Quoted] RMAN-10031: ORA-19624 occurred during call to DBMS_BACKUP_RESTORE.BACKUPDATAFILE RMAN> Received on Mon Apr 16 2001 - 18:42:34 CEST
Date: Tue, 17 Apr 2001 01:42:34 +0900
Message-ID: <9bf73l$6sa$1_at_news2-2.kornet.net>
I use Oracle 8i EE(8.1.6).
When I backup DB in Recovery Manager..
[Quoted] 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 commandsRMAN-01005: syntax error: found "backup": expecting one of: "name, type" [Quoted] 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 [Quoted] RMAN-07004: unhandled exception during command execution on channel ch1 RMAN-10035: exception raised in RPC: ORA-19602: cannot backup or copy activefile in NOARCHIVELOG mode
[Quoted] [Quoted] RMAN-10031: ORA-19624 occurred during call to DBMS_BACKUP_RESTORE.BACKUPDATAFILE RMAN> Received on Mon Apr 16 2001 - 18:42:34 CEST