Home » RDBMS Server » Backup & Recovery » RMAN-06403 (Oracle 11g R2 - Windows 2008 R2)
RMAN-06403 [message #560640] Mon, 16 July 2012 03:07 Go to next message
Guillaume#26
Messages: 1
Registered: July 2012
Location: France
Junior Member
Hello,
I need to configure rman backup via oracle enterprise manager.

Database is not in archive mode, rman shutdown the database and made a "startup mount" for backup.

I set up a backup on disk and the test is successful
When I plan the backup job, database shutdown but the backup is not working and after database is not started.

here is the log of the backup job :

shutdown immediate;

SP2-0640: Not connected
-> ->Connected

Database closed
Database dismounted.
ORACLE Instance shut down.
startup mount

SP2-0640: Not connected
-> ->Connected to an idle instance.
select u.username l_user,
*
ERROR at line 1:
ORA-01034: ORACLE not available
Process ID: 0
Session ID: 0 Serial number: 0

Disconnected

RMAN>
Connected to target database (not started)

RMAN>
echo set on

RMAN> set command id to 'BACKUP_VALD..........';
executing command: SET COMMAND ID
RMAN-00571: ========================================
RMAN-00569: ====== ERROR MESSAGE STACK FOLLOW ======
RMAN-00571: ========================================
RMAN-03002: failure of set command at 07/13/2012 18:00
RMAN-06403: could not obtain a fully authorized session
ORA-01034: ORACLE not available
ORA-27101: shared memory realm does not exist

RMAN> exit;
startup open

SP2-0640: Not connected
-> ->Connected to an idle instance.
select u.username l_user,
*
ERROR at line 1:
ORA-01034: ORACLE not available
Process ID: 0
Session ID: 0 Serial number: 0

disconnected


Thanks for your help.
Re: RMAN-06403 [message #560761 is a reply to message #560640] Mon, 16 July 2012 16:19 Go to previous messageGo to next message
alan.kendall@nfl.com
Messages: 163
Registered: June 2012
Location: Culver City, California
Senior Member
I usually get the "not connected" and "Idle database" errors when my $ORACLE_SID or $ORACLE_HOME are not set to the right database.
Re: RMAN-06403 [message #560773 is a reply to message #560640] Tue, 17 July 2012 01:11 Go to previous message
Michel Cadot
Messages: 68625
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
At least mount the database.

Regards
Michel
Previous Topic: Restoring later backup controlfile and recovering till past scn??
Next Topic: ORA-01135 and ORA-01110
Goto Forum:
  


Current Time: Thu Mar 28 13:35:20 CDT 2024