++++++++++++++++++
REPORT Commands :
++++++++++++++++++
Report commands list/report specific information.
++++++++++++++++++++++++++++++++++++++++++
How to find which files need to backup?
+++++++++++++++++++++++++++++++++++++++++++
rman
Recovery Manager: Release 11.2.0.1.0 - Production on Fri Dec 27 22:07:16 2013
Copyright (c) 1982, 2009, Oracle and/or its affiliates. All rights reserved.
RMAN> connect target /;
connected to target database: PROD (DBID=246965557)
RMAN> report need backup;
RMAN retention policy will be applied to the command
RMAN retention policy is set to redundancy 2
Report of files with less than 2 redundant backups
File #bkps Name
---- ----- -----------------------------------------------------
2 0 /d01/oracle/oradata/prod/sysaux01.dbf
3 0 /d01/oracle/oradata/prod/undotbs01.dbf
4 0 /d01/oracle/oradata/prod/users01.dbf
REPORT Commands :
++++++++++++++++++
Report commands list/report specific information.
++++++++++++++++++++++++++++++++++++++++++
How to find which files need to backup?
+++++++++++++++++++++++++++++++++++++++++++
rman
Recovery Manager: Release 11.2.0.1.0 - Production on Fri Dec 27 22:07:16 2013
Copyright (c) 1982, 2009, Oracle and/or its affiliates. All rights reserved.
RMAN> connect target /;
connected to target database: PROD (DBID=246965557)
RMAN> report need backup;
RMAN retention policy will be applied to the command
RMAN retention policy is set to redundancy 2
Report of files with less than 2 redundant backups
File #bkps Name
---- ----- -----------------------------------------------------
2 0 /d01/oracle/oradata/prod/sysaux01.dbf
3 0 /d01/oracle/oradata/prod/undotbs01.dbf
4 0 /d01/oracle/oradata/prod/users01.dbf
No comments:
Post a Comment