🚀 go-pugleaf

RetroBBS NetNews Server

Inspired by RockSolid Light RIP Retro Guy

Article View: comp.databases.oracle.misc
Article #91

Re: DATABASE FULL BACKUP IN RMAN

#91
From: news.kornet.net
Date: Fri, 20 Apr 2001 12:30
85 lines
4781 bytes
�����̳׿�...
hot bakcup�� �Ϸ��� db�� archivelog mode���� �մϴ�.
�̰� rman�� ���� �Ⱦ��� ��������.
noarchivelog mode��� db�� shutdown ���ѳ��� backup�� �޾߾���.
�� checkpoint�� ����� �ϴϱ�...

rman�������ٴ� db�� ���� �����ؾ� �Ұ� �����ϴ�.

"John Jones" <john.jones@duke.edu> wrote in message
news:9bffmp$3q3$1@news.duke.edu...
> For a database in NOARCHIVE mode, you first have to shutdown the database
> and then start it in "mount" mode.  Do your backup and then open the
> database.  It's all in the online help documents for RMAN.
>
>
> --
> John Jones
> Senior Oracle DBA
> Duke University, OIT
> john.jones@duke.edu
> James Williams <willjamu@mindspring.com> wrote in message
> news:3adb2bc2.65132977@nntp.mindspring.com...
> > 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: <9bp9bb$mog$1@news1.kornet.net>
Path: arc1-ca.pugleaf.net!supernews.google.com!newsfeed.google.com!newsfeed.stanford.edu!news-spur1.maxwell.syr.edu!news.maxwell.syr.edu!newsfeed.dacom.co.kr!feeder.kornet.net!news1.kornet.net!not-for-mail
References: <9bf73l$6sa$1@news2-2.kornet.net> <3adb2bc2.65132977@nntp.mindspring.com> <9bffmp$3q3$1@news.duke.edu>

Show Full Headers
Complete Article Headers
X-Google-Language: Korean,KSC
X-Google-Thread: fa4f9,3820a3aab80567b3
X-Google-Attributes: gidfa4f9,public
X-Google-Thread: f99a8,3820a3aab80567b3
X-Google-Attributes: gidf99a8,public
X-Google-Thread: 104bdf,3820a3aab80567b3
X-Google-Attributes: gid104bdf,public
X-Google-Thread: f5464,3820a3aab80567b3
X-Google-Attributes: gidf5464,public
X-Google-ArrivalTime: 2001-04-20 05:20:40 PST
Path: arc1-ca.pugleaf.net!supernews.google.com!newsfeed.google.com!newsfeed.stanford.edu!news-spur1.maxwell.syr.edu!news.maxwell.syr.edu!newsfeed.dacom.co.kr!feeder.kornet.net!news1.kornet.net!not-for-mail
From: "news.kornet.net" <librete@kornet.net>
Newsgroups: comp.databases.oracle.misc,comp.databases.oracle.server,comp.databases.oracle.tools,han.comp.database
Subject: Re: DATABASE FULL BACKUP IN RMAN
Date: Fri, 20 Apr 2001 21:30:37 +0900
Organization: Korea Telecom
Lines: 87
Message-ID: <9bp9bb$mog$1@news1.kornet.net>
References: <9bf73l$6sa$1@news2-2.kornet.net> <3adb2bc2.65132977@nntp.mindspring.com> <9bffmp$3q3$1@news.duke.edu>
NNTP-Posting-Host: 61.74.108.106
X-Trace: news1.kornet.net 987769003 23312 61.74.108.106 (20 Apr 2001 12:16:43 GMT)
X-Complaints-To: usenet@news.kornet.net
NNTP-Posting-Date: Fri, 20 Apr 2001 12:16:43 +0000 (UTC)
X-Priority: 3
X-MSMail-Priority: Normal
X-Newsreader: Microsoft Outlook Express 6.00.2462.0000
X-MimeOLE: Produced By Microsoft MimeOLE V6.00.2462.0000