🚀 go-pugleaf

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>
>
>

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>
> >
> >
>

�����̳׿�...
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>
> > >
> > >
> >
>
>