OraFAQ Forum: Backup & Recovery

Home » RDBMS Server » Backup & Recovery » backup error

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

backup error [message #153940]

Thu, 05 January 2006 01:00

quytc
Messages: 81
Registered: November 2005
Location: Viet Nam

Member

I have database name QUY. I run command backup by using RMAN
rman target sys/change_on_install nocatalog

Recovery Manager: Release 8.1.7.0.0 - Production

RMAN-06005: connected to target database: QUY (DBID=2843341974)
RMAN-06009: using target database controlfile instead of recovery catalog
RMAN> run {
2> allocate channel t1 type disk;
3> backup
4> format 'D:/%d_t%t_s%s_p%p'
5> (database);
6> release channel t1;
7> }

RMAN-08031: released channel: t1
RMAN-03022: compiling command: allocate
RMAN-03023: executing command: allocate
RMAN-08030: allocated channel: t1
RMAN-08500: channel t1: sid=16 devtype=DISK

RMAN-03022: compiling command: backup
RMAN-03023: executing command: backup
RMAN-08008: channel t1: starting full datafile backupset
RMAN-08502: set_count=3 set_stamp=578930301 creation_time=05-JAN-06
RMAN-08010: channel t1: 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 t1
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

Can anybody help me to find where is error.
thanks

Report message to a moderator

Re: backup error [message #153941 is a reply to message #153940]

Thu, 05 January 2006 01:04

Frank Naude
Messages: 4581
Registered: April 1998

Senior Member

See http://www.orafaq.com/faq/how_does_one_put_a_database_into_archivelog_mode

Report message to a moderator

Re: backup error [message #153945 is a reply to message #153941]

Thu, 05 January 2006 01:24

quytc
Messages: 81
Registered: November 2005
Location: Viet Nam

Member

this mean: I must put my database into archivelog mode. Then run command backup.
I haved put my database with command
SQL> CONNECT sys AS SYSDBA
SQL> STARTUP MOUNT EXCLUSEVE;
SQL> ALTER DATABASE ARCHIVELOG;
SQL> ARCHIVE LOG START;
SQL> ALTER DATABASE OPEN;

but when i run command STARTUP MOUNT EXCLUSEVE; there a error is ORA-01031: insufficient privileges and subsequent command is error

Report message to a moderator

Re: backup error [message #153946 is a reply to message #153945]

Thu, 05 January 2006 01:28

Frank Naude
Messages: 4581
Registered: April 1998

Senior Member

It's working for me. Have you set your environment variables properly (. oraenv)?

SQL> startup mount exclusive
ORACLE instance started.

Total System Global Area  612368384 bytes
Fixed Size                  1980616 bytes
Variable Size             121636664 bytes
Database Buffers          486539264 bytes
Redo Buffers                2211840 bytes
Database mounted.

Report message to a moderator

Re: backup error [message #153951 is a reply to message #153946]

Thu, 05 January 2006 01:36

quytc
Messages: 81
Registered: November 2005
Location: Viet Nam

Member

Can you tell me How to set set my environment variables properly?
I connect database from SQL*plus with user SYS. and then run STARTUP MOUNT EXCLUSEVE; but still error ORA-01031: insufficient privileges

Report message to a moderator

Previous Topic:	Backup Sets of Oracle 10g
Next Topic:	connect sys/*** as sysdba errors

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Thu Nov 21 15:37:41 CST 2024