Today we are going to have look on the most important topic “script”. Being human being we are using the script from the long time ago. Before the start, our technical topic has some look use in normal life.
Definition
A script is any particular system of writing or the written means of human communication. Script originated as simply a means of communicating spoken language over long distances as necessitated by trade.
Now in the technical world, we use a script in the IT field to save time to communicate with the machine.
Create a Script:
D:\>rman target sys/sys@orcl catalog rcat/rcat@cat
Recovery Manager: Release 10.2.0.1.0 - Production on Mon Jan 23 22:37:02 2010
Copyright (c) 1982, 2005, Oracle. All rights reserved.
connected to target database: orcl (DBID=847812342)
connected to recovery catalog database
RMAN> create script full_backup
{
allocate channel c1 type disk;
allocate channel c2 type disk;
backup database;
}
created script full_backup
Run Script:
RMAN> run{execute script full_backup;}
Replace Script:
RMAN> replace script full_backup
{
allocate channel c1 type disk;
allocate channel c2 type disk;
allocate channel c3 type disk;
backup database;
backup(archivelog all);
}
replaced script full_backup
Delete Script:
RMAN> delete script full_back; deleted script: full_back
Data dictionary View:
RC_STORED_SCRIPT RC_STORED_SCRIPT_LINE
Thought of the day
Childhood means simplicity. Look at the world with the child’s eye – it is very beautiful — Kailash Satyarthi
Thank you for giving your valuable time to read the above information.
If you want to be updated with all our articles send us the Invitation or Follow us:
Skant Gupta’s LinkedIn: www.linkedin.com/in/skantali/
Joel Perez’s LinkedIn: Joel Perez’s Profile
LinkedIn Group: Oracle Cloud DBAAS
Facebook Page: OracleHelp
