notice that there is one space after slash inside the single quote.
imp userid='/ as sysdba' full=y log=d:\sysfull.txt file=d:\back\sysfull.dmp
Build an Oracle DBA on a firm foundation of sound practices and technical knowledge!
Translate
Popular Posts
-
configured "CONFIGURE ARCHIVELOG DELETION POLICY TO BACKED UP 2 TIMES TO DISK; " when RMAN> delete noprompt archivelog u...
-
I have one PT env using storage sync for database sync. Thought need to re-register DB after DB refresh, so unregister and register again....
-
RMAN> show all; RMAN configuration parameters for database with db_unique_name ORCL are: CONFIGURE RETENTION POLICY TO REDUNDANCY 1; # de...
-
Processing object type TABLE_EXPORT/TABLE/TABLE Processing object type TABLE_EXPORT/TABLE/GRANT/OWNER_GRANT/OBJECT_GRANT Processing object...
-
after rounds of recovery testing, I believer there are tons of obsolete files in FRA. There are some stubborn datafile copy can't be de...
-
[symptoms] orarac2poc:ORCL2:/home/oracle> . ./oms_agent_env orarac2poc:ORCL2:/home/oracle> $AGENT_HOME/bin/emctl start agent Oracl...
-
SQL> select * from dba_data_files where tablespace_name='TESTBS'; FILE_NAME ...
-
backup piece The physical file format used to store RMAN backup sets backup set A backup of one or more datafiles, control files, SPFILEs...
-
CRS-5019:All OCR locations are on ASM disk groups [DATA], and none of these disk groups are mounted.In my case , from ASM alert.log , actually it is due to ASM failed to start because of ORA-00600 as shown below. ORA-0060...
-
1. If follow proper procedure, backups should be deleted before unregistrating from recovery catalog Either using with RMAN command "...
Labels
- 10g (35)
- 11g (13)
- 12c (9)
- 4.3 (1)
- ACHI (1)
- AIX (3)
- Android (1)
- APEX (8)
- Architecture (2)
- ASM (3)
- audit (1)
- automation (1)
- AWR (4)
- backup and recovery (15)
- Basic (22)
- Best Practices (3)
- bind variable (2)
- BIOS (1)
- Bleeding Case (20)
- bug (3)
- career (2)
- case (7)
- centos (4)
- character set (1)
- cloud control (11)
- clusterware (1)
- Concept (1)
- cron (1)
- Cygwin (1)
- Data Guard (13)
- data management (6)
- DBConsole (5)
- dbua (2)
- delphix (2)
- Edge (2)
- Error latch (1)
- events (1)
- Exam (1)
- Experience (2)
- firmware (1)
- flashback (3)
- Fun (1)
- Fundamental (36)
- HDD (1)
- health check (1)
- Hidden Parameter (2)
- Howto (2)
- install (1)
- instantclient (1)
- ITIL (2)
- itpub (2)
- ITSM (2)
- Java (1)
- jmeter (1)
- joomla (2)
- knives (3)
- knowledge gained (1)
- labs (5)
- latch (1)
- Lazarus (2)
- life (6)
- Linux (36)
- Listener (3)
- LogMiner (1)
- management (5)
- migration (7)
- mind (1)
- mview (3)
- mysql (3)
- NewFeature (3)
- ODBC (1)
- OEM (9)
- oerr (27)
- opatch (2)
- ora600 (1)
- OS (1)
- outline (1)
- Partition (4)
- performance (5)
- PGA (2)
- PL/SQL (5)
- postgresql (1)
- Price (1)
- programming (1)
- qnap (2)
- question (2)
- RAC (6)
- raw device (3)
- Recovery (23)
- RHCE (1)
- RMAN (50)
- SAP Basis (1)
- scripts (1)
- security (7)
- Server-Generated Alert (2)
- shared server (3)
- Software Engineering (4)
- sql developer (3)
- sql*plus (2)
- sqlnet (1)
- sqlserver (13)
- SSD (2)
- SSD IO (1)
- standards (1)
- statistics (5)
- statspack (2)
- Stock (1)
- storage (2)
- timesten (2)
- tips (45)
- Tools (38)
- Trace (3)
- Tuning (17)
- Ubuntu (24)
- Unix (5)
- vertica (1)
- vmware (2)
- vnc (1)
- WhatIs (1)
- XServer (1)
- zabbix (1)
Blog Archive
-
▼
2008
(93)
-
▼
September
(11)
- Define your favorite editor for sqlplus
- lock and create/drop index
- Using gdb for debug
- install Oracle XE on Ubuntu x86_64
- One-time scheduling of tasks with 'at'
- 硬盘与闪存的IO性能
- timing of shrink database vs shrink datafile
- check current redo log file usage
- 7 Interview Questions
- 如何诊断PGA设定是否合适
- using sysdba for exp/imp
-
▼
September
(11)