Home » RDBMS Server » Backup & Recovery » how to know the latest backup sets (11.2.0.1 windows xp)
how to know the latest backup sets [message #535569] Wed, 14 December 2011 23:25 Go to next message
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?
Re: how to know the latest backup sets [message #535570 is a reply to message #535569] Wed, 14 December 2011 23:29 Go to previous messageGo to next message
BlackSwan
Messages: 25859
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.
Re: how to know the latest backup sets [message #535572 is a reply to message #535570] Wed, 14 December 2011 23:50 Go to previous messageGo to next message
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
Re: how to know the latest backup sets [message #535573 is a reply to message #535572] Wed, 14 December 2011 23:56 Go to previous messageGo to next message
BlackSwan
Messages: 25859
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
Re: how to know the latest backup sets [message #535574 is a reply to message #535573] Thu, 15 December 2011 00:06 Go to previous messageGo to next message
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.
Re: how to know the latest backup sets [message #535576 is a reply to message #535572] Thu, 15 December 2011 00:53 Go to previous messageGo to next message
Michel Cadot
Messages: 65389
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
Re: how to know the latest backup sets [message #535711 is a reply to message #535576] Thu, 15 December 2011 19:17 Go to previous messageGo to next message
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
Re: how to know the latest backup sets [message #535719 is a reply to message #535711] Thu, 15 December 2011 23:18 Go to previous messageGo to next message
Michel Cadot
Messages: 65389
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
"export NLS_DATE_FORMAT" is missing.

Regards
Michel
Re: how to know the latest backup sets [message #535728 is a reply to message #535719] Fri, 16 December 2011 00:25 Go to previous messageGo to next message
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
Re: how to know the latest backup sets [message #535732 is a reply to message #535728] Fri, 16 December 2011 01:17 Go to previous messageGo to next message
Michel Cadot
Messages: 65389
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
Re: how to know the latest backup sets [message #535747 is a reply to message #535732] Fri, 16 December 2011 03:05 Go to previous message
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
Previous Topic: Restore dabase + copied archivelogs
Next Topic: backup set obsolete issue
Goto Forum:
  


Current Time: Sun Feb 25 12:43:46 CST 2018

Total time taken to generate the page: 0.02922 seconds