Quick Search:
CODE
Oracle PL/SQL Code Library
JOBS
Find Or Post Oracle Jobs
FORUM
Oracle Discussion & Chat
 Oracle PL/SQL: RMAN: Command Summary Jump to:  
Category: >> Oracle PL/SQL >> RMAN: Command Summary Bookmark and Share

<< lastnext >>

Snippet Name: RMAN: Command Summary

Description: Summary of RMAN commands that you can execute at the RMAN prompt, within a RUN command, or both.

Also see:
» RMAN: List the most recent Level 0 bac...
» RMAN: Format Directives
» RMAN: Data Dictionary Objects
» RMAN (Oracle Recovery Manager)

Comment: (none)

Language: PL/SQL
Highlight Mode: PLSQL
Last Modified: March 10th, 2009

@     
Run a command file.     
 
@@     
Run a command file IN the same directory AS another command 
file that IS currently running. The @@ command differs FROM 
the @ command only WHEN run FROM within a command file.     
 
ALLOCATE CHANNEL     
Establish a channel, which IS a connection BETWEEN RMAN AND a 
database instance.     
 
ALLOCATE CHANNEL FOR MAINTENANCE     
Allocate a channel IN preparation FOR issuing maintenance commands 
such AS DELETE.     
 
allocOperandList     
A subclause that specifies channel control options such AS PARMS 
AND FORMAT.
 
ALTER DATABASE     
Mount OR OPEN a database.     
 
archivelogRecordSpecifier     
Specify a RANGE OF archived redo logs files.     
 
BACKUP     
Back up database files, copies OF database files, archived logs, 
OR backup sets.     
 
BLOCKRECOVER     
Recover an individual data block OR SET OF data blocks within 
one OR more datafiles.
 
CATALOG     
Add information about a datafile copy, archived redo LOG, OR control 
file copy TO the repository.     
 
CHANGE     
Mark a backup piece, image copy, OR archived redo LOG AS HAVING the 
status UNAVAILABLE OR AVAILABLE; remove the repository RECORD FOR a 
backup OR copy; override the retention policy FOR a backup OR copy.     
 
completedTimeSpec     
Specify a TIME RANGE during which the backup OR copy completed.     
 
CONFIGURE     
Configure persistent RMAN settings. These settings apply TO ALL RMAN 
sessions until explicitly changed OR disabled.     
 
CONNECT     
Establish a connection BETWEEN RMAN AND a target, auxiliary, OR 
recovery catalog database.     
 
connectStringSpec     
Specify the username, password, AND net service name FOR connecting TO 
a target, recovery catalog, OR auxiliary database. The connection IS 
necessary TO authenticate the USER AND identify the database.     
 
CONVERT     
Converts datafile formats FOR transporting tablespaces across platforms.     
 
CREATE CATALOG     
CREATE the schema FOR the recovery catalog.     
 
CREATE SCRIPT     
CREATE a stored script AND store it IN the recovery catalog.     
 
CROSSCHECK     
Determine whether files managed BY RMAN, such AS archived logs, datafile 
copies, AND backup pieces, still exist ON disk OR tape.     
 
datafileSpec     
Specify a datafile BY filename OR absolute file NUMBER.     
 
DELETE     
DELETE backups AND copies, remove REFERENCES TO them FROM the recovery 
catalog, AND UPDATE their control file records TO status DELETED.     
 
DELETE SCRIPT     
DELETE a stored script FROM the recovery catalog.     
 
deviceSpecifier     
Specify the TYPE OF storage device FOR a backup OR copy.     
 
DROP CATALOG     
Remove the schema FROM the recovery catalog.     
 
DROP DATABASE     
Deletes the target database FROM disk AND unregisters it.     
 
DUPLICATE     
USE backups OF the target database TO CREATE a duplicate database 
that you can USE FOR testing purposes OR TO CREATE a standby database.     
 
EXECUTE SCRIPT     
Run an RMAN stored script.     
 
EXIT     
Quit the RMAN executable.     
 
fileNameConversionSpec     
Specify patterns TO transform source TO target filenames during 
BACKUP AS COPY, CONVERT AND DUPLICATE.     
 
FLASHBACK     
Returns the database TO its state AT a previous TIME OR SCN.     
 
formatSpec     
Specify a filename format FOR a backup OR copy.     
 
HOST     
Invoke an operating system command-line subshell FROM within 
RMAN OR run a specific 
operating system command.     
 
keepOption     
Specify that a backup OR copy should OR should NOT be exempt FROM 
the CURRENT retention policy.     
 
LIST     
Produce a detailed listing OF backup sets OR copies.     
 
listObjList     
A subclause used TO specify which items will be displayed BY the 
LIST command.     
 
maintQualifier     
A subclause used TO specify additional options FOR maintenance 
commands such AS DELETE AND CHANGE.     
 
maintSpec     
A subclause used TO specify the files operated ON BY maintenance 
commands such AS CHANGE, CROSSCHECK, AND DELETE.     
 
obsOperandList     
A subclause used TO determine which backups AND copies are obsolete.     
 
PRINT SCRIPT     
Display a stored script.     
 
QUIT     
EXIT the RMAN executable.     
 
recordSpec     
A subclause used TO specify which objects the maintenance commands 
should operate ON.     
RECOVER     
 
Apply redo logs AND incremental backups TO datafiles restored FROM 
backup OR datafile copies, IN ORDER TO UPDATE them TO a specified TIME.     
 
REGISTER     
Register the target database IN the recovery catalog.     
 
RELEASE CHANNEL     
RELEASE a channel that was allocated WITH an ALLOCATE CHANNEL command.     
 
releaseForMaint     
RELEASE a channel allocated WITH an ALLOCATE CHANNEL FOR MAINTENANCE 
command.     
 
REPLACE SCRIPT     
REPLACE an existing script stored IN the recovery catalog. IF the 
script does NOT exist, THEN REPLACE SCRIPT creates it.     
 
REPORT     
Perform detailed analyses OF the content OF the recovery catalog.     
 
RESET DATABASE     
Inform RMAN that the SQL statement ALTER DATABASE OPEN RESETLOGS 
has been executed AND that a NEW incarnation OF the target database 
has been created, OR reset the target database TO a PRIOR incarnation.     
 
RESTORE     
Restore files FROM backup sets OR FROM disk copies TO the DEFAULT 
OR a NEW location.     
 
RESYNC     
Perform a full resynchronization, which creates a snapshot control 
file AND THEN copies ANY NEW OR changed information FROM that snapshot 
control file TO the recovery catalog.     
 
RUN     
EXECUTE a sequence OF one OR more RMAN commands, which are one OR more 
statements executed within the braces OF RUN.     
 
SEND     
Send a vendor-specific quoted string TO one OR more specific channels.     
 
SET     
Sets the VALUE OF various attributes that affect RMAN behavior FOR 
the duration OF a RUN block OR a session.     
 
SHOW     
Displays the CURRENT CONFIGURE settings.     
 
SHUTDOWN     
Shut down the target database. This command IS equivalent TO the 
SQL*Plus SHUTDOWN command.     
 
SPOOL     
WRITE RMAN output TO a LOG file.     
 
SQL     
EXECUTE a SQL statement FROM within Recovery Manager.     
 
STARTUP     
START up the target database. This command IS equivalent TO the 
SQL*Plus STARTUP command.     
 
SWITCH     
Specify that a datafile copy IS now the CURRENT datafile, that IS, 
the datafile pointed TO BY the control file. This command IS equivalent 
TO the SQL statement ALTER DATABASE RENAME FILE AS it applies TO datafiles.     
 
UNREGISTER DATABASE     
Unregisters a database FROM the recovery catalog.     
 
untilClause     
A subclause specifying an UPPER limit BY TIME, SCN, OR LOG sequence 
NUMBER. This clause IS usually used TO specify the desired point IN 
TIME FOR an incomplete recovery.     
 
UPGRADE CATALOG     
Upgrade the recovery catalog schema FROM an older version TO the version 
required BY the RMAN executable.     
 
VALIDATE     
Examine a backup SET AND report whether its data IS intact. RMAN scans 
ALL OF the backup pieces IN the specified backup sets AND looks AT the 
checksums TO verify that the contents can be successfully restored.     
 
 
 


Free
Oracle Magazine
Subscriptions
and Oracle White Papers


SQL University.net courses meet the most demanding needs of the business world for advanced education in a cost-effective manner. SQL University.net courses are available immediately for IT professionals and can be taken without disruption of your workplace schedule or processes.

Compared to traditional travel-based training, SQL University.net saves time and valuable corporate resources, allowing companies to do more with less. That's our mission, and that's what we deliver.

Click here to find out more
 
Home      :      Code Library      :      Sponsors      :      Privacy      :      Terms of Use      :      Contact Us 198 users online    © 2009 psoug.org

PSOUG LOGIN
Username: 
Password: 
Forgot your password?