Shulou(Shulou.com)06/01 Report--

RMAN diagnostic information collection [ID 1337285.1] for: Oracle Server-Personal Edition-Version: 10.1.0.2 to 11.2.0.2-Release: 10.1 to 11.2 for any platform following script is executed within RMAN. If you are using an RMAN recovery catalog please also make a connection to the catalog. Default path to the rman_diagnostics.out file: / tmp 1) Unix environment, set the following environment variable: $export NLS_DATE_FORMAT='DD MON YYYY HH24:MI:SS'2) run the following script on the RMAN command line: a) A) A small number of data files in the database or backup strategy using the following script spool trace to'/ tmp/rman_diag_long.out'; show all;list incarnation of database;list backup summary;report schema;list backup of database List copy of database;spool trace off;b) the following script is used in a large number of data files to view the backup information of a data file spool trace to'/ tmp/rman_diag_short.out'; show all;list incarnation of database;list backup summary;report schema;list backup of datafile 1 role list copy of datafile 1 role spool trace off

Welcome to subscribe "Shulou Technology Information " to get latest news, interesting things and hot topics in the IT industry, and controls the hottest and latest Internet news, technology news and IT industry trends.