Home » RDBMS Server » Backup & Recovery » backup error
backup error [message #153940] Thu, 05 January 2006 01:00 Go to next message
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
Re: backup error [message #153941 is a reply to message #153940] Thu, 05 January 2006 01:04 Go to previous messageGo to next message
Frank Naude
Messages: 4579
Registered: April 1998
Senior Member
See http://www.orafaq.com/faq/how_does_one_put_a_database_into_archivelog_mode
Re: backup error [message #153945 is a reply to message #153941] Thu, 05 January 2006 01:24 Go to previous messageGo to next message
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


Re: backup error [message #153946 is a reply to message #153945] Thu, 05 January 2006 01:28 Go to previous messageGo to next message
Frank Naude
Messages: 4579
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.
Re: backup error [message #153951 is a reply to message #153946] Thu, 05 January 2006 01:36 Go to previous message
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
Previous Topic: Backup Sets of Oracle 10g
Next Topic: connect sys/*** as sysdba errors
Goto Forum:
  


Current Time: Thu Mar 28 04:46:46 CDT 2024