Article View: comp.databases.oracle.misc
Article #88DATABASE FULL BACKUP IN RMAN
From: �����
Date: Mon, 16 Apr 2001 16:42
Date: Mon, 16 Apr 2001 16:42
48 lines
3172 bytes
3172 bytes
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:
<9bf73l$6sa$1@news2-2.kornet.net>Path:
arc1-ca.pugleaf.net!supernews.google.com!sn-xit-02!supernews.com!bignews.mediaways.net!nntp.kreonet.re.kr!feeder.kornet.net!news1.kornet.net!not-for-mailShow Full Headers
Complete Article Headers
X-Google-Language: ENGLISH,ASCII-7-bit X-Google-Thread: fa4f9,3820a3aab80567b3,start X-Google-Attributes: gidfa4f9,public X-Google-Thread: f99a8,3820a3aab80567b3,start X-Google-Attributes: gidf99a8,public X-Google-Thread: 104bdf,3820a3aab80567b3,start X-Google-Attributes: gid104bdf,public X-Google-Thread: f5464,3820a3aab80567b3,start X-Google-Attributes: gidf5464,public X-Google-ArrivalTime: 2001-04-16 09:45:52 PST Path: arc1-ca.pugleaf.net!supernews.google.com!sn-xit-02!supernews.com!bignews.mediaways.net!nntp.kreonet.re.kr!feeder.kornet.net!news1.kornet.net!not-for-mail From: "�����" <myunggyu@piamail.net> Newsgroups: comp.databases.oracle.misc,comp.databases.oracle.server,comp.databases.oracle.tools,han.comp.database Subject: DATABASE FULL BACKUP IN RMAN Date: Tue, 17 Apr 2001 01:42:34 +0900 Organization: Korea Telecom Lines: 50 Message-ID: <9bf73l$6sa$1@news2-2.kornet.net> NNTP-Posting-Host: 211.222.174.128 X-Trace: news2-2.kornet.net 987439029 7050 211.222.174.128 (16 Apr 2001 16:37:09 GMT) X-Complaints-To: usenet@news.kornet.net NNTP-Posting-Date: Mon, 16 Apr 2001 16:37:09 +0000 (UTC) X-Priority: 3 X-MSMail-Priority: Normal X-Newsreader: Microsoft Outlook Express 5.50.4133.2400 X-MimeOLE: Produced By Microsoft MimeOLE V5.50.4133.2400