OraFAQ Forum: Backup & Recovery » how to know the latest backup sets

Home » RDBMS Server » Backup & Recovery » how to know the latest backup sets (11.2.0.1 windows xp)

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

how to know the latest backup sets [message #535569]

Wed, 14 December 2011 23:25

andy huang
Messages: 498
Registered: July 2011

Senior Member

Dear all,
I have backup my db many times in one day,and there are many backup sets,how to know which is the the latest backup sets?

Report message to a moderator

Re: how to know the latest backup sets [message #535570 is a reply to message #535569]

Wed, 14 December 2011 23:29

BlackSwan
Messages: 26766
Registered: January 2009
Location: SoCal

Senior Member

andy huang wrote on Wed, 14 December 2011 21:25

Dear all,
I have backup my db many times in one day,and there are many backup sets,how to know which is the the latest backup sets?

It is the one with the latest/most recent timestamp.

Report message to a moderator

Re: how to know the latest backup sets [message #535572 is a reply to message #535570]

Wed, 14 December 2011 23:50

andy huang
Messages: 498
Registered: July 2011

Senior Member

Thanks BlackSwan,
I using list backup command,and found there is no the timestamp,just up to day date.

BS Key Type LV Size Device Type Elapsed Time Completion Time
------- ---- -- ---------- ----------- ------------ ---------------
5 Full 173.91M DISK 00:00:55 30-NOV-11 BP Key: 13 Status: AVAILABLE Compressed: NO Tag: TAG20111130T170752
Piece Name: /u01/rman_backup/2011/201111/mybak/df_768589674_6_1.bak
List of Datafiles in backup set 5
File LV Type Ckp SCN Ckp Time Name
---- -- ---- ---------- --------- ----
2 Full 530571 30-NOV-11 /u01/app/oracle/oradata/oracl/undotbs01.dbf
3 Full 530571 30-NOV-11 /u01/app/oracle/oradata/oracl/sysaux01.dbf
5 Full 530571 30-NOV-11 /u01/app/oracle/oradata/oracl/hxl01.dbf

Report message to a moderator

Re: how to know the latest backup sets [message #535573 is a reply to message #535572]

Wed, 14 December 2011 23:56

BlackSwan
Messages: 26766
Registered: January 2009
Location: SoCal

Senior Member

the database is NOT the center of the Universe.

the backups reside in OS space if they have any persistence; which has OS timestamp

Report message to a moderator

Re: how to know the latest backup sets [message #535574 is a reply to message #535573]

Thu, 15 December 2011 00:06

andy huang
Messages: 498
Registered: July 2011

Senior Member

Thanks BlackSwan,
I just want to know there is a command to find the latest backup sets in RMAN.

Report message to a moderator

Re: how to know the latest backup sets [message #535576 is a reply to message #535572]

Thu, 15 December 2011 00:53

Michel Cadot
Messages: 68637
Registered: March 2007
Location: Nanterre, France, http://...

Senior Member
Account Moderator

Quote:

there is no the timestamp,just up to day date.

Just set your NLS_DATE_FORMAT environment variable as you want BEFORE starting RMAN.

Regards
Michel

Report message to a moderator

Re: how to know the latest backup sets [message #535711 is a reply to message #535576]

Thu, 15 December 2011 19:17

andy huang
Messages: 498
Registered: July 2011

Senior Member

hi,
Michel,i have set the the NLS_DATE_FORMAT,but there is no effect.

[oracle@hxl ~]$ NLS_DATE_FORMAT='YYYY-MM-DD HH24:MI:SS'
[oracle@hxl ~]$ echo $NLS_DATE_FORMAT
YYYY-MM-DD HH24:MI:SS

[oracle@hxl ~]$ rman target /

Recovery Manager: Release 10.2.0.1.0 - Production on Thu Dec 15 21:11:31 2011

Copyright (c) 1982, 2005, Oracle. All rights reserved.

connected to target database: ORACL (DBID=1813843256)

RMAN> list backup;

using target database control file instead of recovery catalog

List of Backup Sets
===================

BS Key Type LV Size Device Type Elapsed Time Completion Time
------- ---- -- ---------- ----------- ------------ ---------------
4 Full 351.26M DISK 00:00:51 30-NOV-11 BP Key: 12 Status: AVAILABLE Compressed: NO Tag: TAG20111130T170752
Piece Name: /u01/rman_backup/2011/201111/mybak/df_768589674_5_1.bak
List of Datafiles in backup set 4
File LV Type Ckp SCN Ckp Time Name
---- -- ---- ---------- --------- ----
1 Full 530571 30-NOV-11 /u01/app/oracle/oradata/oracl/system01.dbf
4 Full 530571 30-NOV-11 /u01/app/oracle/oradata/oracl/users01.dbf

Report message to a moderator

Re: how to know the latest backup sets [message #535719 is a reply to message #535711]

Thu, 15 December 2011 23:18

Michel Cadot
Messages: 68637
Registered: March 2007
Location: Nanterre, France, http://...

Senior Member
Account Moderator

"export NLS_DATE_FORMAT" is missing.

Regards
Michel

Report message to a moderator

Re: how to know the latest backup sets [message #535728 is a reply to message #535719]

Fri, 16 December 2011 00:25

andy huang
Messages: 498
Registered: July 2011

Senior Member

hi,
Michel, there is no effect!

[oracle@hxl myscript]$ export nls_date_format='YYYY-MM-DD HH24:MI:SS'
[oracle@hxl myscript]$ echo $nls_date_format
YYYY-MM-DD HH24:MI:SS

RMAN> list backup;
List of Backup Sets
===================
BS Key Type LV Size Device Type Elapsed Time Completion Time
------- ---- -- ---------- ----------- ------------ ---------------
4 Full 351.26M DISK 00:00:51 30-NOV-11 BP Key: 12 Status: AVAILABLE Compressed: NO Tag: TAG20111130T170752
Piece Name: /u01/rman_backup/2011/201111/mybak/df_768589674_5_1.bak
List of Datafiles in backup set 4
File LV Type Ckp SCN Ckp Time Name
---- -- ---- ---------- --------- ----
1 Full 530571 30-NOV-11 /u01/app/oracle/oradata/oracl/system01.dbf
4 Full 530571 30-NOV-11 /u01/app/oracle/oradata/oracl/users01.dbf

Report message to a moderator

Re: how to know the latest backup sets [message #535732 is a reply to message #535728]

Fri, 16 December 2011 01:17

Michel Cadot
Messages: 68637
Registered: March 2007
Location: Nanterre, France, http://...

Senior Member
Account Moderator

1/ If you want to check an environment variable do NOT use "echo" but "env"
2/ NLS_DATE_FORMAT must be in UPPER case.

Regards
Michel

Report message to a moderator

Re: how to know the latest backup sets [message #535747 is a reply to message #535732]

Fri, 16 December 2011 03:05

andy huang
Messages: 498
Registered: July 2011

Senior Member

Thanks Michel very much,
It has effect!

[oracle@hxl myscript]$ env|grep NLS
NLS_DATE_FORMAT=YYYY-MM-DD HH24:MI:SS
[oracle@hxl myscript]$ rman target /

Recovery Manager: Release 10.2.0.1.0 - Production on Fri Dec 16 04:58:32 2011

Copyright (c) 1982, 2005, Oracle. All rights reserved.

connected to target database: ORACL (DBID=1813843256)

RMAN> list backup;

using target database control file instead of recovery catalog

List of Backup Sets
===================

BS Key Type LV Size Device Type Elapsed Time Completion Time
------- ---- -- ---------- ----------- ------------ -------------------
4 Full 351.26M DISK 00:00:51 2011-11-30 17:08:45 BP Key: 12 Status: AVAILABLE Compressed: NO Tag: TAG20111130T170752
Piece Name: /u01/rman_backup/2011/201111/mybak/df_768589674_5_1.bak
List of Datafiles in backup set 4
File LV Type Ckp SCN Ckp Time Name
---- -- ---- ---------- ------------------- ----
1 Full 530571 2011-11-30 17:07:19 /u01/app/oracle/oradata/oracl/system01.dbf
4 Full 530571 2011-11-30 17:07:19 /u01/app/oracle/oradata/oracl/users01.dbf

Report message to a moderator

Previous Topic:	Restore dabase + copied archivelogs
Next Topic:	backup set obsolete issue

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Tue Apr 16 11:59:47 CDT 2024