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

Home -> Community -> Usenet -> c.d.o.server -> Re: DATABASE FULL BACKUP IN RMAN

Re: DATABASE FULL BACKUP IN RMAN

From: James Williams <willjamu_at_mindspring.com>
Date: Mon, 16 Apr 2001 17:29:18 GMT
Message-ID: <3adb2bc2.65132977@nntp.mindspring.com>

On Tue, 17 Apr 2001 01:42:34 +0900, "°­¸í±Ô" <myunggyu_at_piamail.net> wrote:

Looks like you are doing a hot backup under the covers which requires archivelog since block writes are done between begin backup and end backup

>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 - 12:29:18 CDT

Original text of this message

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