Búsqueda

ry parameter. ==== RMAN-00556: could not open CMDFILE "string" ==== Cause: An error occurred when trying to open the file. Action: Check that the filename was specified correctly and that the file exist... the user running RMAN has read permission for the file. ==== RMAN-00557: could not open MSGLOG "string"

racle 10g]] </columns> ==== RMAN-07527: Reason: File was not created using DB_RECOVERY_FILE_DEST initi... panied by other message(s) indicating the name of file that was not created using DB_RECOVERY_FILE_DEST ... ios caused this error: 1) This is an archived log file and was created when the LOG_ARCHIVE_DEST_n initi

cion Oracle 10g]] </columns> ==== ORA-01167 two files are the same file/group number or the same file ==== Cause: There is an overlap of file numbers in the files specified on the command line or the same file is specified twice. If they are not the exact same file then one is likely to be a backup o

ion Oracle 10g]] </columns> ==== ORA-01167: two files are the same file/group number or the same file ==== Cause: There is an overlap of file numbers in the files specified on the command line or the same file is specified twice. If they are not the exact same file then one is likely to be a backup

ck_size'; COLUMN tablespace FORMAT A15 COLUMN file_name FORMAT A34 COLUMN use_pct FORMAT 999... | ' OFF' ) TABLESPACE, a.file_name, ROUND ((f.blocks * &blk_size) / (1024 * 102... 1 ) use_pct FROM SYS.dba_data_files a, SYS.uet$ s, SYS.file$ f, SYS.ts$ x WHERE x

tatpacks ====== <code> $ exp perfstat/perfstat file=SQL_SUMMARY.dmp log=SQL_SUMMARY.log tables="STATS... _SUMMARY" direct=y rows=n $ exp perfstat/perfstat file=SQLTEXT.dmp log=SQLTEXT.log tables="STATS\$SQLTEXT" direct=y rows=n $ exp perfstat/perfstat file=FILESTATXS.dmp log=FILESTATXS.log tables="STATS\$FIL

alacion Oracle 10g]] </columns> ==== ORA-01207: file is more recent than control file - old control file ==== Cause: The control file change sequence number in the data file is greater than the number in the control file. This implies that the wrong control file is being used. Note that repeatedly c

talacion Oracle 10g]] </columns> ==== ORA-01248 file string was created in the future of incomplete re... An attempt was made to do a RESETLOGS open with a file entry in the control file that was originally cre... llowing such an entry may hide the version of the file that is needed at this time. The file number may

discos', '3 E/S directas', '2 E/S discos', '4 BFILE reads', '2 E/S discos', '5 Otras E/S', '2 E/S d... Latencias', '2 Trafico Red', '4 Latencias', '3 file ops', '4 Latencias', '4 process ctl', '4 Latenc... d.kslednam, -- E/S discos 'db file sequential read', '1 E/S normales', 'db fi

iger@db10g tables=EMP,DEPT directory=TEST_DIR dumpfile=EMP_DEPT.dmp logfile=expdpEMP_DEPT.log impdp sco... iger@db10g tables=EMP,DEPT directory=TEST_DIR dumpfile=EMP_DEPT.dmp logfile=impdpEMP_DEPT.log </code> ... /tiger@db10g schemas=SCOTT directory=TEST_DIR dumpfile=SCOTT.dmp logfile=expdpSCOTT.log impdp scott/tig

mns> ==== ORA-00205 error in identifying controlfile, check alert log for more info ==== Cause: The system could not find a control file of the specified name and size. Action: One of the following: Check that the proper control file name is referenced in the CONTROL_FILES initialization parameter i

racle 10g]] </columns> ====== Listado de los datafiles ====== <quote> Listado de los datafiles </quote> <code sql> REM REM Listado de los datafiles REM PROMPT PROMPT D A T A F I L E S PROMPT ACCEPT fn PROMPT "File name like (ENTER for all): " ACCEPT ts PROMPT "Tablespace name like (ENTER for all):

ps de la BBDD disponibles RMAN> LIST COPY OF DATAFILE 1, 2, 3; Lista las copias disponibles de los datafiles 1, 2 y 3 RMAN> LIST BACKUP OF ARCHIVELOG FROM SEQUENCE <n> Lista las copias de los archivelogs... RMAN> LIST CONTROLFILECOPY "/tmp/cf.cpy"; RMAN> LIST BACKUPSET OF DATAFILE 1; RMAN> DELETE

====== Filesystems ====== <code sql> set lines 132 pages 5000 compute sum of "Mb" on report break on r... lect round(sum(bytes)/1048576) "Mb" From DBA_DATA_FILES UNION ALL Select round(sum(bytes)/1048576) "Mb" From DBA_TEMP_FILES UNION ALL Select round(sum(members*bytes)/1048576) "Mb" From V$LOG; col "File S