| Error message: RMAN-06099 [message #70000] |
Thu, 28 March 2002 12:38  |
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 #70008 is a reply to message #70000] |
Tue, 02 April 2002 07:38  |
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 #70020 is a reply to message #70000] |
Wed, 03 April 2002 12:14 |
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 |
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 |
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.
|
|
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
