Home » RDBMS Server » Backup & Recovery » Error message: RMAN-06099
Error message: RMAN-06099 [message #70000] Thu, 28 March 2002 12:38 Go to next message
Michael C
Messages: 10
Registered: March 2002
Junior Member
Any input appreciate.
I got this error message while I tried to backup the database, how I can address the problem?

RMAN> run {
2> startup mount pfile=d:oracleAdminACSPfileinitACS.ora;
3> allocate channel d1 type disk;
4> allocate channel d2 type disk;
5> setlimit channel d1 kbytes 1900000;
6> setlimit channel d2 kbytes 1900000;
7> backup format '/oracle/dba/prod/rman%U.bus' database;
8> release channel d1;
9> release channel d2;
10> }

RMAN-03022: compiling command: startup
RMAN-06193: connected to target database (not started)
RMAN-06196: Oracle instance started
RMAN-06199: database mounted

Total System Global Area 37094668 bytes

Fixed Size 70924 bytes
Variable Size 29937664 bytes
Database Buffers 6553600 bytes
Redo Buffers 532480 bytes

RMAN-03022: compiling command: allocate
RMAN-03026: error recovery releasing channel resources
RMAN-00571: ===========================================================
RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
RMAN-00571: ===========================================================
RMAN-03002: failure during compilation of command
RMAN-03013: command type: allocate
RMAN-06004: ORACLE error from recovery catalog database: ORA-12571: TNS:packet writer failure
RMAN-06097: text of failing SQL statement: begin dbms_rcvman . resetAll ; :success := dbms_rcvman . SUCCESS ; :av
RMAN-06099: error occurred in source file: krmk.pc, line: 9335
Re: Error message: RMAN-06099 [message #70003 is a reply to message #70000] Fri, 29 March 2002 06:04 Go to previous messageGo to next message
Grant
Messages: 578
Registered: January 2002
Senior Member
The command should be:

sql 'startup mount pfile=d:oracleAdminACSPfileinitACS.ora';
Re: Error message: RMAN-06099 [message #70008 is a reply to message #70000] Tue, 02 April 2002 07:38 Go to previous messageGo to next message
Michael C
Messages: 10
Registered: March 2002
Junior Member
Thanks Grant.

Now it's giving me another error message:
RMAN-03022: compiling command: sql
RMAN-06162: sql statement: startup mount pfile=d:oracleAdminACSPfileinitACS.ora
RMAN-03023: executing command: sql
RMAN-03026: error recovery releasing channel resources
RMAN-00571: ===========================================================
RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
RMAN-00571: ===========================================================
RMAN-03006: non-retryable error occurred during execution of command: sql
RMAN-07004: unhandled exception during command execution on channel default
RMAN-20000: abnormal termination of job step
RMAN-11003: failure during parse/execution of SQL statement: startup mount pfile=d:oracleAdminACSPfileinitACS.o
RMAN-11001: Oracle Error: ORA-00900: invalid SQL statement

Any idea?

Thanks again

Michael
Re: Error message: RMAN-06099 [message #70010 is a reply to message #70000] Tue, 02 April 2002 08:22 Go to previous messageGo to next message
Grant
Messages: 578
Registered: January 2002
Senior Member
What version of Oracle are you using?
Re: Error message: RMAN-06099 [message #70013 is a reply to message #70000] Tue, 02 April 2002 11:29 Go to previous messageGo to next message
Michael C
Messages: 10
Registered: March 2002
Junior Member
Oracle 8i on NT

thanks
Michael
Re: Error message: RMAN-06099 [message #70016 is a reply to message #70000] Wed, 03 April 2002 05:21 Go to previous messageGo to next message
Grant
Messages: 578
Registered: January 2002
Senior Member
Obvious error isn't it. You can't mount the db if it is already mounted. Go into server manager and do a shutdown before you run your script.
Re: Error message: RMAN-06099 [message #70020 is a reply to message #70000] Wed, 03 April 2002 12:14 Go to previous messageGo to next message
Michael C
Messages: 10
Registered: March 2002
Junior Member
Grant,
Taking your advise, i did two situation test as follow:

Situation 1)

SVRMGR> shutdown immediate;
Database closed.
Database dismounted.
ORACLE instance shut down.
SVRMGR> startup
ORACLE instance started.
Total System Global Area 37094668 bytes
Fixed Size 70924 bytes
Variable Size 29937664 bytes
Database Buffers 6553600 bytes
Redo Buffers 532480 bytes
Database mounted.
Database opened.

C:>rman target xxxx/xxxx@sid
Recovery Manager: Release 8.1.6.0.0 - Production

RMAN-06005: connected to target database: sid (DBID=874348719)

RMAN> connect rcvcat rman/rman@sid

RMAN-06008: connected to recovery catalog database

RMAN> run {
2> startup mount pfile=d:oracleAdminACSPfileinitACS.ora;
3> allocate channel d1 type disk;
4> allocate channel d2 type disk;
5> setlimit channel d1 kbytes 1900000;
6> setlimit channel d2 kbytes 1900000;
7> backup format '/oracle/dba/prod/rman%U.bus' database;
8> release channel d1;
9> release channel d2;
10> }

RMAN-03022: compiling command: startup
RMAN-06401: database is already started

RMAN-03022: compiling command: allocate
RMAN-03023: executing command: allocate
RMAN-08030: allocated channel: d1
RMAN-08500: channel d1: sid=15 devtype=DISK

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

RMAN-03022: compiling command: set limit
RMAN-03023: executing command: set limit

RMAN-03022: compiling command: set limit
RMAN-03023: executing command: set limit

RMAN-03022: compiling command: backup
RMAN-03023: executing command: backup
RMAN-08008: channel d1: starting full datafile backupset
RMAN-08502: set_count=3 set_stamp=458218608 creation_time=03-APR-02
RMAN-08010: channel d1: 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 d1
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

Question: How to do backup with "NOARCHIVELOG mode"? I did the cleanly shutdown in Situation 2(as below)
and tried the "backup" in RMAN.

Situation 2)

SVRMGR> shutdown immediate;
Database closed.
Database dismounted.
ORACLE instance shut down.
SVRMGR> startup mount;
ORACLE instance started.
Total System Global Area 37094668 bytes
Fixed Size 70924 bytes
Variable Size 29937664 bytes
Database Buffers 6553600 bytes
Redo Buffers 532480 bytes
Database mounted.

RMAN> run {
2> allocate channel d1 type disk;
3> allocate channel d2 type disk;
4> setlimit channel d1 kbytes 1900000;
5> setlimit channel d2 kbytes 1900000;
6> backup format 'd:/oracle/dba/prod/rman%U.bus' database;
7> release channel d1;
8> release channel d2;
9> }

RMAN-03022: compiling command: allocate
RMAN-03026: error recovery releasing channel resources
RMAN-00571: ===========================================================
RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
RMAN-00571: ===========================================================
RMAN-03002: failure during compilation of command
RMAN-03013: command type: allocate
RMAN-06172: not connected to recovery catalog database

RMAN> connect rcvcat rman/rman@sid

RMAN-00571: ===========================================================
RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
RMAN-00571: ===========================================================
RMAN-04004: error from recovery catalog database: ORA-01033: ORACLE initialization or shutdown in progress

Question: how to connect recovery catalog database when the database "startup mount" and get the backup done?

Alway appreciate your patient to help me address the backup problem!

Michael C
Re: Error message: RMAN-06099 [message #70028 is a reply to message #70020] Thu, 04 April 2002 04:43 Go to previous messageGo to next message
Grant
Messages: 578
Registered: January 2002
Senior Member
If you want to backup using RMAN and the target is in NO ARCHIVE mode the target cannot be OPEN. You have to shut it down and put it in a MOUNT state. Note that if you backup this way you will only be able to restore the DB from the last backup and you will lose all data between backups. Also, if you use ARCHIVE mode you do not have to shutdown the database at all and you can do a full recover up to the point of failure.

If you put the target DB in ARCHIVE mode the first example will work but you do not have to shut down. You would connect to both target and catalog and remove the mount command. You would also need to include backing up your archive logs.

In the second example you are not connected to the catalog DB and RMAN needs to be to do the type of backup you are trying to do.

When you try to connect to the catalog it says is is down or shutting down. Verify the catalog DB is up and running.

If you decide to do RMAN backups in NO ARCHIVE mode you will not need to connect to a catalog. Shutdown the target DB, connect to the target, and run your script with the MOUNT command. You will then need an "alter database open;" at the end.

Another option is to use export.
Re: Error message: RMAN-06099 [message #70030 is a reply to message #70020] Thu, 04 April 2002 04:53 Go to previous messageGo to next message
Grant
Messages: 578
Registered: January 2002
Senior Member
This is added to last message.

Doing some reading on NO ARCHIVE backups you will need a catalog and be connected to it. I had stated that you didn't. You will not be able to do a hot backup so the target DB will need to be mounted and not open.
Re: Error message: RMAN-06099 [message #70041 is a reply to message #70020] Thu, 04 April 2002 14:46 Go to previous message
Michael C
Messages: 10
Registered: March 2002
Junior Member
I got it work finally, thanks for your help Grant
Previous Topic: how to recreate database on the same host from level 0 backup
Next Topic: Oracle 9i- RMAN FAILS
Goto Forum:
  


Current Time: Thu Mar 28 17:42:49 CDT 2024