Home » RDBMS Server » Backup & Recovery » No RMAN records in control file (Oracle RDBMS, 10.2.0.4, AIX)
No RMAN records in control file [message #572206] Fri, 07 December 2012 07:00 Go to next message
csm.dba
Messages: 12
Registered: July 2012
Location: India
Junior Member
Hi,

We're running 10.2.0.4 Database on AIX with no catalog Database.

We keep all the backup info in controlfiles only.

When we do that backup, we're able to successfully back it up (including archivelogs). But I'm unable to find any records in the controlfiles.

SQL> select * from V$BACKUP_SET;

no rows selected

and

SQL> sho parameter control

NAME TYPE VALUE
------------------------------------ ------------------------------
control_file_record_keep_time integer 14

Could you advice where my backup info i going?

Thanks
CSM
Re: No RMAN records in control file [message #572209 is a reply to message #572206] Fri, 07 December 2012 07:14 Go to previous messageGo to next message
Michel Cadot
Messages: 58521
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
Something is wrong in what you (think you) did.

Regards
Michel
Re: No RMAN records in control file [message #572210 is a reply to message #572206] Fri, 07 December 2012 07:24 Go to previous messageGo to next message
John Watson
Messages: 4374
Registered: January 2010
Location: Global Village
Senior Member
Or perhaps you are cresting copies rather than backup sets?
Re: No RMAN records in control file [message #572217 is a reply to message #572210] Fri, 07 December 2012 08:13 Go to previous messageGo to next message
csm.dba
Messages: 12
Registered: July 2012
Location: India
Junior Member
What could be that something Sir??
Re: No RMAN records in control file [message #572220 is a reply to message #572217] Fri, 07 December 2012 08:40 Go to previous messageGo to next message
Michel Cadot
Messages: 58521
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
What could be? Many things among:
- someone deleted the backups
- you used copy instead of backup as John said
- you are not connected to the database you backed up
- ...

Connnect on the server and execute and post (after setting the environment for your database):
rman target /
  backup database;
  exit;
sqlplus / as sysdba
  select * from V$BACKUP_SET;
  exit

Regards
Michel
Re: No RMAN records in control file [message #572221 is a reply to message #572220] Fri, 07 December 2012 08:47 Go to previous messageGo to next message
csm.dba
Messages: 12
Registered: July 2012
Location: India
Junior Member
My backups are safe, I'm connected to the same Database as that's the only one exist in that machine...

I'm seeing list of control files and archivelogs when i give 'list copy;' but not the datafiles.

The only thing I'm doing is, I'm backing up the Database using a 3rd party tool which uses RMAN in turn...

If we assume that tool is doing some mess, it's not happening on all the Databases backed up by that tool... and I'm sure that tool is not doing anything except just using RMAN code snippets.

CSM

[Updated on: Fri, 07 December 2012 08:56]

Report message to a moderator

Re: No RMAN records in control file [message #572222 is a reply to message #572221] Fri, 07 December 2012 08:57 Go to previous messageGo to next message
BlackSwan
Messages: 22489
Registered: January 2009
Senior Member
you have a mystery & we have no clues.

When thing do not seem to be as they appear, then most likely some is different.

post SQL & results from other DB where you report all is OK to confirm that reality.
Re: No RMAN records in control file [message #572223 is a reply to message #572222] Fri, 07 December 2012 09:19 Go to previous messageGo to next message
csm.dba
Messages: 12
Registered: July 2012
Location: India
Junior Member
Quote:
post SQL & results from other DB where you report all is OK to confirm that reality.


May I know what do you mean by SQL and results?

CSM
Re: No RMAN records in control file [message #572224 is a reply to message #572223] Fri, 07 December 2012 09:25 Go to previous messageGo to next message
BlackSwan
Messages: 22489
Registered: January 2009
Senior Member
csm.dba wrote on Fri, 07 December 2012 07:19
Quote:
post SQL & results from other DB where you report all is OK to confirm that reality.


May I know what do you mean by SQL and results?

CSM


>it's not happening on all the Databases backed up by that tool...

post proof (SQL & results) that the statement above is true; that RMAN backs occur on other DB using this unnamed tool.
Re: No RMAN records in control file [message #572225 is a reply to message #572224] Fri, 07 December 2012 09:40 Go to previous messageGo to next message
csm.dba
Messages: 12
Registered: July 2012
Location: India
Junior Member
Here's the output I've taken through a query which involves tables like v$backup_job,v$backup_set etc...


RECID STAMP START_TIME END_TIME MBYTES STATUS INPUT_TYPE
------- ------------ --------------------------------------------------------------------------- --------------------------------------------------------------------------- ---------- ---------- -------------
ELAPSED TIME OUT
DOW SECONDS TAKEN CF DF I0 I1 L INST
-------------------------------- ---------- ---------- ------ ------ ------ ------ ------ -----
1396 801349428 2012-12-06 21:03:49 2012-12-06 21:18:14 393 COMPLETED DB INCR
Thursday 865 00:14:25 1 0 0 3 1 1


and that tool is CA's ARCServe.
Re: No RMAN records in control file [message #572226 is a reply to message #572225] Fri, 07 December 2012 09:54 Go to previous messageGo to next message
Michel Cadot
Messages: 58521
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
Which proof have you that it uses RMAN for THIS database?
Note we have on this database and what you did and got ONLY the information you posted here, that is NOTHING.

Regards
Michel
Re: No RMAN records in control file [message #572229 is a reply to message #572226] Fri, 07 December 2012 10:23 Go to previous messageGo to next message
csm.dba
Messages: 12
Registered: July 2012
Location: India
Junior Member
The documentation says that.

After referring to that only I told you.

Re: No RMAN records in control file [message #572230 is a reply to message #572229] Fri, 07 December 2012 10:26 Go to previous messageGo to next message
Michel Cadot
Messages: 58521
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
So no proof, no clue, nothing, empty topic, the issue does not exist (at least for Oracle).

Regards
Michel
Re: No RMAN records in control file [message #572231 is a reply to message #572230] Fri, 07 December 2012 10:39 Go to previous message
csm.dba
Messages: 12
Registered: July 2012
Location: India
Junior Member
Ok...thanks for your time.
Previous Topic: archive log
Next Topic: New to Oracle - NEED HELP IMMEDIATELY
Goto Forum:
  


Current Time: Wed Jul 23 19:32:36 CDT 2014

Total time taken to generate the page: 0.11856 seconds