OraFAQ Forum: Backup & Recovery » No RMAN records in control file

Home » RDBMS Server » Backup & Recovery » No RMAN records in control file (Oracle RDBMS, 10.2.0.4, AIX)

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

No RMAN records in control file [message #572206]

Fri, 07 December 2012 07:00

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

Report message to a moderator

Re: No RMAN records in control file [message #572209 is a reply to message #572206]

Fri, 07 December 2012 07:14

Michel Cadot
Messages: 68733
Registered: March 2007
Location: Saint-Maur, France, https...

Senior Member
Account Moderator

Something is wrong in what you (think you) did.

Regards
Michel

Report message to a moderator

Re: No RMAN records in control file [message #572210 is a reply to message #572206]

Fri, 07 December 2012 07:24

John Watson
Messages: 8964
Registered: January 2010
Location: Global Village

Senior Member

Or perhaps you are cresting copies rather than backup sets?

Report message to a moderator

Re: No RMAN records in control file [message #572217 is a reply to message #572210]

Fri, 07 December 2012 08:13

csm.dba
Messages: 12
Registered: July 2012
Location: India

Junior Member

What could be that something Sir??

Report message to a moderator

Re: No RMAN records in control file [message #572220 is a reply to message #572217]

Fri, 07 December 2012 08:40

Michel Cadot
Messages: 68733
Registered: March 2007
Location: Saint-Maur, France, https...

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

Report message to a moderator

Re: No RMAN records in control file [message #572221 is a reply to message #572220]

Fri, 07 December 2012 08:47

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

BlackSwan
Messages: 26766
Registered: January 2009
Location: SoCal

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.

Report message to a moderator

Re: No RMAN records in control file [message #572223 is a reply to message #572222]

Fri, 07 December 2012 09:19

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

Report message to a moderator

Re: No RMAN records in control file [message #572224 is a reply to message #572223]

Fri, 07 December 2012 09:25

BlackSwan
Messages: 26766
Registered: January 2009
Location: SoCal

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.

Report message to a moderator

Re: No RMAN records in control file [message #572225 is a reply to message #572224]

Fri, 07 December 2012 09:40

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.

Report message to a moderator

Re: No RMAN records in control file [message #572226 is a reply to message #572225]

Fri, 07 December 2012 09:54

Michel Cadot
Messages: 68733
Registered: March 2007
Location: Saint-Maur, France, https...

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

Report message to a moderator