Article View: comp.databases.oracle.misc
Article #89Re: DATABASE FULL BACKUP IN RMAN
From: James Williams
Date: Mon, 16 Apr 2001 17:29
Date: Mon, 16 Apr 2001 17:29
57 lines
3254 bytes
3254 bytes
On Tue, 17 Apr 2001 01:42:34 +0900, "�����" <myunggyu@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>
>
>
Technical Details
Message-ID:
<3adb2bc2.65132977@nntp.mindspring.com>Path:
arc1-ca.pugleaf.net!supernews.google.com!sn-xit-03!supernews.com!logbridge.uoregon.edu!howland.erols.net!newsfeed.mindspring.net.MISMATCH!news.mindspring.net!not-for-mailReferences:
<9bf73l$6sa$1@news2-2.kornet.net>Show Full Headers
Complete Article Headers
X-Google-Language: ENGLISH,ASCII X-Google-Thread: fa4f9,3820a3aab80567b3 X-Google-Attributes: gidfa4f9,public X-Google-Thread: 104bdf,3820a3aab80567b3 X-Google-Attributes: gid104bdf,public X-Google-Thread: f99a8,3820a3aab80567b3 X-Google-Attributes: gidf99a8,public X-Google-Thread: f5464,3820a3aab80567b3 X-Google-Attributes: gidf5464,public X-Google-ArrivalTime: 2001-04-16 10:30:07 PST Path: arc1-ca.pugleaf.net!supernews.google.com!sn-xit-03!supernews.com!logbridge.uoregon.edu!howland.erols.net!newsfeed.mindspring.net.MISMATCH!news.mindspring.net!not-for-mail From: willjamu@mindspring.com (James Williams) Newsgroups: comp.databases.oracle.misc,comp.databases.oracle.server,comp.databases.oracle.tools,han.comp.database Subject: Re: DATABASE FULL BACKUP IN RMAN Date: Mon, 16 Apr 2001 17:29:18 GMT Organization: MindSpring Enterprises Lines: 58 Message-ID: <3adb2bc2.65132977@nntp.mindspring.com> References: <9bf73l$6sa$1@news2-2.kornet.net> NNTP-Posting-Host: d1.56.4e.c1 X-Server-Date: 16 Apr 2001 17:28:00 GMT X-Newsreader: Forte Free Agent 1.21/32.243