Home » RDBMS Server » Backup & Recovery » RMAN stuck in scheduled status ...
icon9.gif  RMAN stuck in scheduled status ... [message #117668] Thu, 28 April 2005 15:50 Go to next message
nnamdia
Messages: 3
Registered: April 2005
Junior Member
Newbie here folks so please bear with me. I'm trying to configure RMAN in OEM 9.2 to do scheduled backups. I created a test job and submitted it with no errors. I scheduled it to run immediately but it just sits there with the status as "scheduled". I've read the OEM document and getting all my info from chapter 11 (Managing backup and recovery). I've searched online and can't find a possible cause for this apparent hang. It's a test database I set up before I implement on the production box. Any help or ideas on what to look for will be appreciated.
Thanks,
Nnamdi

My config:
Windows 2000 Pro
Oracle 9i (9.2.0.1.0)
Configuring RMAN through Oracle Management Server OEM

[Updated on: Thu, 28 April 2005 16:51]

Report message to a moderator

Re: RMAN stuck in scheduled status ... [message #117682 is a reply to message #117668] Thu, 28 April 2005 17:19 Go to previous messageGo to next message
Mahesh Rajendran
Messages: 10708
Registered: March 2002
Location: oracleDocoVille
Senior Member
Account Moderator
look into the OEM logs.
Post specific errors/logs.

YOu did stuff with OEM.
What kind of Configuration did you do with RMAN?
Re: RMAN stuck in scheduled status ... [message #117685 is a reply to message #117668] Thu, 28 April 2005 18:10 Go to previous messageGo to next message
nnamdia
Messages: 3
Registered: April 2005
Junior Member
Sorry, I did a search by name and date and could not find any OEM log files. Could you tell me what the OEM log file would be called? Would my listenere log file be of any value ?

To configure backups:
1. I logged into Oracle management server, right clicked on my databse and selected backup.
2. Selected "Customize backup strategy".
3. Selected "Entire database".
4. Select "NO" to not include archived logs.
5. Select "Full backup".
6. Select "Online Backup"
7. Select "Keep this backup or copy until 'April 30th, 2005'".
8. Select run "Immediately".
9. Left default name and descriptions.
10. Select "Submit the job now". Click Finish, then OK.

I then got a message saying " The job has been successfully submitted......."




Prior to do I had created a backup configuration with two channels pointing to disk locations with this format:
F:\rman_backup\ADGIS04\b_%u_%p_%c
leaving everything else as default.

Re: RMAN stuck in scheduled status ... [message #117785 is a reply to message #117685] Fri, 29 April 2005 10:37 Go to previous messageGo to next message
Mahesh Rajendran
Messages: 10708
Registered: March 2002
Location: oracleDocoVille
Senior Member
Account Moderator
should be something like oem.log or *nohup*.
I havent used OEM to do RMAN backup.

RMAN backup needs some configurations ( catalog/nocatalog etc).
and OEM needs some configs too( OEM repository etc).
Did you do all these?


Re: RMAN stuck in scheduled status ... [message #117789 is a reply to message #117785] Fri, 29 April 2005 10:57 Go to previous message
nnamdia
Messages: 3
Registered: April 2005
Junior Member
Thanks again for your follow up. I did configure the test run once with the catalog option and once with the no catalog option with the appropriate user names and passwords with no problems.
I also configured the repository that enables me to use the OEM /Management server to do these backups. So it seems everything is setup as documented, i just must be missing something or have a wrong parameter somwhere.
I still can't find any meaningful logs that would provide any sort of insight.
It seems like a pretty intuitive tool to use once its configured but can't get past this hanging issue.

I searched my computer for any files with "nohup" in there name, here my result.

OracleoracleAgent.nohup
Contents:
-----------------------------------------------------------------
-----------------------------------------------------------------
--------------------------- 04/21/2005 1:52p -------------------------
-----------------------------------------------------------------
-----------------------------------------------------------------
--------------------------- 04/25/2005 7:51a -------------------------
-----------------------------------------------------------------
-----------------------------------------------------------------
--------------------------- 04/26/2005 10:39a -------------------------
-----------------------------------------------------------------
-----------------------------------------------------------------
--------------------------- 04/26/2005 11:48a -------------------------
-----------------------------------------------------------------
-----------------------------------------------------------------
--------------------------- 04/26/2005 3:08p -------------------------
-----------------------------------------------------------------
-----------------------------------------------------------------
--------------------------- 04/29/2005 8:02a -------------------------
-----------------------------------------------------------------

oms.nohup
Contents:[/B]
OEMCTL for Windows NT: Version 9.2.0.1.0 Production
Copyright (c) 1998, 2002, Oracle Corporation. All rights reserved.
Starting the Oracle Management Server...VXA-3008 : Starting OMS Services, Wait.


The OMS is now started and ready.
initCreating
initCreating
initCreating
initExisting
initCreating
initCreating
*** VDD: INITIATING OMS SHUTDOWN : OMS REPOSITORY SESSION LOST ***
VXA: Doing a shutdown and restart
"Management server thrashing. Exiting oemctrl.bat"
OEMCTL for Windows NT: Version 9.2.0.1.0 Production
Copyright (c) 1998, 2002, Oracle Corporation. All rights reserved.
Starting the Oracle Management Server...VXA-3008 : Starting OMS Services, Wait.


The OMS is now started and ready.
initCreating
initExisting
initExisting
initCreating
initExisting
initCreating
in readObject VboDBJobObjectAttributes
initCreating
initCreating
initCreating
initExisting
initCreating
initExisting
initCreating
initExisting
initExisting
initCreating
initCreating
initCreating
initCreating
initExisting
initExisting
initCreating
initCreating
initCreating
initExisting
initCreating
initCreating
initCreating
initExisting
initExisting
initExisting
*** VDD: INITIATING OMS SHUTDOWN : OMS REPOSITORY SESSION LOST ***
VXA: Doing a shutdown and restart
"Management server thrashing. Exiting oemctrl.bat"
OEMCTL for Windows NT: Version 9.2.0.1.0 Production
Copyright (c) 1998, 2002, Oracle Corporation. All rights reserved.
Starting the Oracle Management Server...VXA-3008 : Starting OMS Services, Wait.


The OMS is now started and ready.

Previous Topic: Syntax for dump logfile options?
Next Topic: Database not opening.
Goto Forum:
  


Current Time: Sun Nov 24 07:11:48 CST 2024