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

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

Re: DATABASE FULL BACKUP IN RMAN

From: news.kornet.net <librete_at_kornet.net>
Date: Fri, 20 Apr 2001 21:30:37 +0900
Message-ID: <9bp9bb$mog$1@news1.kornet.net>

정답이네요...
hot bakcup을 하려면 db가 archivelog mode여야 합니다. 이건 rman을 쓰던 안쓰던 마찬가지죠. noarchivelog mode라면 db를 shutdown 시켜놓고 backup을 받야야죠. 왜 checkpoint를 맞춰야 하니까...

rman문제보다는 db를 좀더 이해해야 할것 같습니다.

"John Jones" <john.jones_at_duke.edu> wrote in message news:9bffmp$3q3$1_at_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_at_duke.edu
> James Williams <willjamu_at_mindspring.com> wrote in message
> news:3adb2bc2.65132977_at_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 Fri Apr 20 2001 - 07:30:37 CDT

Original text of this message

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