Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.tools -> Re: DATABASE FULL BACKUP IN RMAN
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...Received on Mon Apr 16 2001 - 14:07:43 CDT
> 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>
> >
> >
>